Details
-
Bug
-
Status: In Testing (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6
-
None
Description
If both FK and UK checks are disabled on appliers, and there's at least two appliers, and they both execute INSERT statements into the same table, it happens that such inserts are treated as bulk inserts in InnoDB and the first insert grabs an X-lock on a table. The other applier with similar INSERT statement has to wait, but if the lock holder has seqno higher than the waiter, then it will deadlock in Galera waiting on the earlier applier to commit, while that earlier applier is waiting for InnoDB table lock to be released.
Attachments
Issue Links
- blocks
-
MDEV-34822 Skip FK checks in Galera during applying in IST
-
- In Testing
-