Comment 20 for bug 1514608

Revision history for this message
Russell Boyatt (russell-boyatt) wrote :

Hmmm...."Error 1213: Deadlock found when trying to get lock" is from MySQL rather than from mysqli. So the error message has come from the db at some point but that seems at odds with the lack of a latest deadlock section in 'show engine innodb status'. I'm not aware of an option that if enabled would not report deadlocks in this way.

In your test cases, if you enable 'innodb_print_all_deadlocks' option do you see a deadlock reported in the mysql error log? (With isolation level at read commited, I'm afraid I can't still trigger a deadlock for copy pages/collections)