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

WSREP: MDL BF-BF conflict

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.18
    • N/A
    • Server
    • None

    Description

      1. it caused by creating Index successfully on node1, failed on node2.

      CREATE INDEX IF NOT EXISTS IDX_ABC ON ABC (MinuteID, TYPE(50))

      2. db error log at node2:
      2026-06-22 19:41:11 9 [ERROR] WSREP: MDL BF-BF conflict

      schema.name: lteps.ecmfolio

      request: (9 seqno 3679076 wsrep (toi, exec, committed, BF1) cmd 0 2 CREATE INDEX IF NOT EXISTS IDX_ABC ON ABC(MinuteID, TYPE(50)))

      granted: (18 seqno 3679081 wsrep (high priority, exec, committing, BF1) cmd 0 161 NULL)

      3,our environment is 3 nodes: node1+node2+witness, the mariadb version is 10.11.18, and galera version is galera-4-26.4.27

      4. it need restart node2 to resume

      Attachments

        Activity

          People

            seppo Seppo Jaakola
            johngou johngou
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.25d
                0.25d

                Git Integration

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