Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2.16, 10.3.8
-
None
Description
Cluster node may enter in unresolved conflict state when there are two inserts, with same primary key, into a table which has foreign key constraint for a parent table. These inserts must be issued in separate cluster nodes, and there has to be simultaneous writes (updates or deletes), for the referenced parent row.
As a result of such scenario, replication applier thread may end in unresolved conflict state, And error log will be filled by messages of type:
"WSREP: BF lock wait long"
followed by InnoDB monitor outputs
Attachments
Issue Links
- relates to
-
MDEV-17541 KILL QUERY during lock wait in FOREIGN KEY check causes hang
- Closed
-
MDEV-18174 Galera node terminated due to foreign key constraint
- Closed