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

        Activity

          Ascending order - Click to sort in descending order
          sciascid Daniele Sciascia added a comment -

          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)

          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.