MySQL Bugs: #15136: Deadlock on tables with foreign key reference

Bug #15136	Deadlock on tables with foreign key reference
Submitted:	22 Nov 2005 14:52	Modified:	23 Nov 2005 10:07
Reporter:	Maxim M	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S2 (Serious)
Version:	5.0.15-standard-log,4.1.15,possible all	OS:	Linux (RH AS3, AS4,possible all)
Assigned to:	Bugs System	CPU Architecture:	Any

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Log of Mysql 5.0.15 with deadlock happens in Connection 6 (before SHOW ENGINE INNODB STATUS)

Attachment: mysql.log (application/octet-stream, text), 22.59 KiB.

Java test file

Attachment: DatabaseDeadlockTest.java (text/x-java), 3.36 KiB.

Example deadlock log (SHOW INNODB STATUS)

Attachment: deadlock.log (application/octet-stream, text), 6.83 KiB.

MySql configuration file attached

Attachment: my.ini (application/octet-stream, text), 11.80 KiB.