Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24119

MDL BF-BF Conflict caused by TRUNCATE TABLE

    XMLWordPrintable

    Details

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              seppo Seppo Jaakola
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: