Percona XtraDB Cluster - HA scalable solution for MySQL

cascading FK constraint can cause slave hanging

Reported by Seppo Jaakola on 2013-02-20
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
High
Seppo Jaakola
5.5
High
Seppo Jaakola
Percona XtraDB Cluster
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
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

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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers