Has anyone seen situations where innodb's deadlock detection fails to detect a deadlock, and things remain deadlocked until the lock wait timeout expires and the server returns a "Lock wait timeout exceeded; Try restarting transaction", or have any ideas for why it may be happening?
There are no mysql locks (ie. "lock table ...", "get_lock()", etc.) explicitly being used. I was under the impression that innodb's deadlock detection was guaranteed to always work if no mysql locks were involved. This is running 4.0.15a on Linux, all tables on the server (aside from the "mysql" database) are innodb. I have some innodb lock monitor dumps, but they aren't overly illuminating, at least to me... all the active transactions are blocking waiting for something, but I can't fully trace who is waiting for who since only 10 locks are printed for each one. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
