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
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
11h 26m | 1 |
|
17m 14s | 1 |
|
2h 6m | 1 |
|
193d 22h 35m | 1 |