cascading FK constraint can cause slave hanging

Bug #1130888 reported by Seppo Jaakola
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Fix Released
High
Seppo Jaakola
5.5
Fix Released
High
Seppo Jaakola
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC
Fix Released
Undecided
Unassigned

Bug Description

Replication of a delete on table which is referenced by cascading foreign key constraint can interfere with a write on the child table and under certain conditions this can lead to unresolved replication conflict. As a result the slave thread can remain hanging.

A separate regression test has been created for this issue.

Related branches

Changed in codership-mysql:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Seppo Jaakola (seppo-jaakola)
milestone: none → 5.5.29-23.7.3
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :
Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Problem was introduced by wsrep originated FK checks for referenced table, which did not check the possible deadlock error happening during the FK checking

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

The fix revision was wrong in the comment above, correct fix revision is: http://bazaar.launchpad.net/~codership/codership-mysql/5.5-23/revision/3847

Changed in percona-xtradb-cluster:
milestone: none → 5.5.30-23.7.4
status: New → Fix Released
Revision history for this message
Marc Castrovinci (marc-castrovinci) wrote :

Will this fix be applied in 5.6? I believe this could have caused a deadlock which lead to this bug: https://bugs.launchpad.net/codership-mysql/+bug/1158221

Revision history for this message
vineet khanna (khannavin) wrote :

Please confirm If this bug is not affecting 5.6?

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1293

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.