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

Concurrent UPDATE and DROP TABLE cause MDL BF-BF conflict

    XMLWordPrintable

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36123 WSREP: MDL BF-BF conflict

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              sysprg Julius Goryavsky
              sciascid Daniele Sciascia (Inactive)
              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.