[MDEV-24119] MDL BF-BF Conflict caused by TRUNCATE TABLE Created: 2020-11-04  Updated: 2021-01-12  Resolved: 2020-11-11

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.2, 10.4
Fix Version/s: 10.4.18, 10.5.9, 10.6.0

Type: Bug Priority: Major
Reporter: Seppo Jaakola Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-21577 Galera crash after MDL BF-BF conflict Closed
relates to MDEV-23997 truncate is crashing mariadb galera c... Closed

 Description   

In the fix for issue MDEV-21577, OPTIMIZE REPAIR and ALTER table TOI replication was modified to look if affected table has foreign key constraints and append foreign key parent table names in the write set certification key list, if any. This was needed because these DDL statements take additional MDL shared lock on the FK parent table, and this could cause MDL BF-BF conflict situation with another applier operating on the FK parent table only.

After the MDEV-21577 fix, it has turned out that also TRUNCATE TABLE acquires MDL lock on FK parent table, and TOI replication for TRUNCATE will need similar fix.


Generated at Thu Feb 08 09:27:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.