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

              jplindst Jan Lindström (Inactive)
              seppo Seppo Jaakola
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.