cascading FK constraint can cause slave hanging
Bug #1130888 reported by
Seppo Jaakola
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 |
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.
Fix was pushed in revision: http:// bazaar. launchpad. net/~codership/ codership- mysql/5. 5-23/revision/ 3846