Marc, please send the printouts to me.
Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html ----- Original Message ----- From: "Marc Slemko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, March 25, 2004 8:40 PM Subject: innodb deadlock detection failing? > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]