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

Concurrent UPDATE and DROP TABLE cause MDL BF-BF conflict

Details

    Description

      DROP TABLE of child may apply concurrently with UPDATE parent table. It appears that DROP TABLE does not append certification key for parent table, even though it takes MDL lock on the parent (thus causing the BF-BF conflict).

      2024-09-26 15:45:15 2 [Note] WSREP: MDL BF-BF conflict
      schema:  test
      request: (2     seqno 9         wsrep (toi, exec, executing) cmd 0 9    DROP TABLE t2)
      granted: (11    seqno 10        wsrep (high priority, exec, committing) cmd 0 161       (null))
      

      Attachments

        Issue Links

          Activity

            A pull request to fix the issue is available here: https://github.com/MariaDB/server/pull/3568

            sciascid Daniele Sciascia added a comment - A pull request to fix the issue is available here: https://github.com/MariaDB/server/pull/3568
            sysprg Julius Goryavsky added a comment - The fix has been merged with the head revision: https://github.com/MariaDB/server/commit/841a7d391bead2e486967ed73aed091ac633b4f2 Additional changes: https://github.com/MariaDB/server/commit/50cf189717a3fce90a9f2407ed57e59c108f91ef (to overcome MDEV-26266 regression)

            People

              sysprg Julius Goryavsky
              sciascid Daniele Sciascia
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.