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
Field | Original Value | New Value |
---|---|---|
Status | Open [ 1 ] | In Progress [ 3 ] |
Assignee | Seppo Jaakola [ seppo ] | Marko Mäkelä [ marko ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Marko Mäkelä [ marko ] | Seppo Jaakola [ seppo ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Assignee | Seppo Jaakola [ seppo ] | Thirunarayanan B [ thiru ] |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] |
Component/s | Storage Engine - InnoDB [ 10129 ] |
Link |
This issue relates to |
Link |
This issue relates to |
issue.field.resolutiondate | 2019-01-15 08:14:26.0 | 2019-01-15 08:14:26.926 |
Fix Version/s | 10.2.19 [ 23207 ] | |
Fix Version/s | 10.3.11 [ 23141 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Assignee | Thirunarayanan Balathandayuthapani [ thiru ] | Marko Mäkelä [ marko ] |
Resolution | Duplicate [ 3 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 88248 ] | MariaDB v4 [ 154626 ] |