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

          Transition Time In Source Status Execution Times
          Daniele Sciascia made transition -
          Open In Progress
          		2m 44s 1
          Daniele Sciascia made transition -
          In Progress In Review
          		26d 23h 26m 1
          Julius Goryavsky made transition -
          In Review Stalled
          		94d 15h 30m 1
          Julius Goryavsky made transition -
          Stalled In Progress
          		4s 1
          Julius Goryavsky made transition -
          In Progress Closed
          		1m 20s 1

          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.