cascading FK constraint can cause slave hanging
|||MySQL patches by Codership||
|||Percona XtraDB Cluster||
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.
|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|