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

WSREP: MDL BF-BF conflict

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.11.9
    • 10.11
    • Galera
    • None

    Description

      Last night we encountered a MDL BF-BF conflict on the second node of one of our clusters.

      logging for the error:
      Feb 18 21:50:08 node02 mariadbd[1071]: 2025-02-18 21:50:08 9 [Note] WSREP: MDL BF-BF conflict
      Feb 18 21:50:08 node02 mariadbd[1071]: schema: db
      Feb 18 21:50:08 node02 mariadbd[1071]: request: (9 #011seqno 113068570 #011wsrep (high priority, exec, executing) cmd 0 161 #011update `c` set `s` = 'de4def60-4e1a-4c44-b2cc-544a02119308', `c`.`updated_at` = '2025-02-18T20:50:07Z' where `id` = '889d45d4-1617-4d72-83ff-28fc241b156b'^?ò´g#023#001)
      Feb 18 21:50:08 node02 mariadbd[1071]: granted: (8 #011seqno 113068568 #011wsrep (toi, exec, committed) cmd 0 45 #011OPTIMIZE TABLE `db`.`c_d_t`)
      Feb 18 21:50:08 node02 mariadbd[1071]: 2025-02-18 21:50:08 9 [ERROR] Aborting

      after that the node set wsrep_ready to "off"

      I've spoken to the developers, the tables in the 2 queries are not related (no triggers or anything affecting the table that is being optimized). From what I've gathered from the developers the OPTIMIZE is part of cronjob for multiple tables and multiple dbs. This cron started at 21:48:02
      The OPTIMIZE started at the first node at 21:50:07 and finished in 1.2024 seconds.

      unfortunately logging does not show any additional information.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28452 wsrep_ready: OFF after MDL BF-BF conflict

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30303 run optimize table got [Note] WSREP: MDL BF-BF conflict and [ERROR] Aborting

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31544 MariaDB crash on OPTIMIZE with "MDL BF-BF conflict"

          • Major - Major loss of function.
          • Open

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

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25039 MDL BF-BF conflict because of foreign key

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30413 run sequence nextval got [Note] WSREP: MDL BF-BF conflict and [ERROR] Aborting

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34606 Node never joins back - WSREP: gcs_caused() returned -103 (Software caused connection abort) after WSREP: MDL BF-BF conflict

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34834 cluster hang because of conflict between DDL from wsrep and DML executed from trigger

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35018 Concurrent UPDATE and DROP TABLE cause MDL BF-BF conflict

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

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

          • Major - Major loss of function.
          • Open

          Activity

            Transition Time In Source Status Execution Times
            Julius Goryavsky made transition -
            Open In Progress
            		6d 5h 29m 1
            JiraAutomate made transition -
            In Progress Stalled
            		54d 1h 46m 1
            Jan Lindström made transition -
            Stalled Needs Feedback
            		1d 11h 10m 1
            Jan Lindström made transition -
            Needs Feedback Open
            		5h 4m 1

            People

              hemantdangi Hemant Dangi
              rtuk Rick Tuk
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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