Bug #45694 Deadlock in replicated statement is not retried
Submitted: 24 Jun 2009 7:04 Modified: 16 Sep 2009 10:11
Reporter: Jesper Wisborg Krogh Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:5.0.77, 5.0 5.1, azalea bzr OS:Linux
Assigned to: Alfranio Junior CPU Architecture:Any
Tags: deadlock, innodb, replication

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:

[24 Jun 2009 7:05] Jesper Wisborg Krogh
Test case

Attachment: replication_deadlock.sql (text/x-sql), 1.19 KiB.

[22 Jul 2009 0:28] Jesper Wisborg Krogh
The my.cnf file used for the test setup

Attachment: my.cnf (application/octet-stream, text), 85 bytes.

[24 Jul 2009 7:03] Jesper Wisborg Krogh
Test case where the transaction is retried

Attachment: replication_deadlock_2.sql (text/x-sql), 877 bytes.

[24 Jul 2009 7:37] Sveta Smirnova
test case for the testsuite

Attachment: rpl_bug45694.test (application/octet-stream, text), 1.23 KiB.

[24 Jul 2009 7:38] Sveta Smirnova
option file

Attachment: rpl_bug45694-slave.opt (application/octet-stream, text), 40 bytes.