Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
Description
After MDEV-26682 InnoDB releases gap locks on XA PREPARE. This is safe and doesn't impact correctness, while fixing some deadlocks in parallel replication.
But it's not enough, row locks can still cause deadlocks. This task is about releasing row locks on XA PREPARE. InnoDB cannot release all row locks, of course, it'll cause incorrect results if a concurrent transaction will be able to see uncommitted changes.
Still InnoDB can release row locks on all unmodified rows at XA PREPARE — this should be safe.
Attachments
Issue Links
- blocks
-
MDEV-33455 skip modified rows in parallel XA replication, don't wait
- Open
- causes
-
MDEV-34466 XA prepare don't release unmodified records in non-blocking mode
- In Progress
-
MDEV-34690 lock_rec_unlock_unmodified() causes deadlock
- Stalled
-
MDEV-34777 Wrong page mode during getting page from buffer pool for lock_rec_unlock_unmodified()
- Closed
- relates to
-
MDEV-26682 slave lock timeout with xa and gap locks
- Closed