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

run sequence nextval got [Note] WSREP: MDL BF-BF conflict and [ERROR] Aborting

Details

    Description

      Hi,

      Our Galera cluster architecture is 2 DB nodes + 1 witness node. Most DB traffic is redirected to one DB node.

      One of our Galera cluster encounter one node down (wsrep_ready=OFF). We restarted the DB node but IST encountered the same error. We need to remove data directory and let Galera to trigger SST in order to resume the DB node.

      DB version is 10.6.10 and Galera version is 26.4.12

      We have another similar incident MDEV-30303

      2023-01-06 22:04:55 2 [Note] WSREP: MDL BF-BF conflict
      schema:  tswtrn1
      request: (2     seqno 31040753  wsrep (high priority, exec, executing) cmd 0 161        select nextval(`SEQUENCE_LPCO_ID`)<87>*<B8>c^S^A)
      granted: (6     seqno 31040752  wsrep (high priority, exec, preparing) cmd 0 161        (null))
      2023-01-06 22:04:55 2 [ERROR] Aborting
      

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Julius Goryavsky made transition -
            Open In Progress
            19d 4h 2m 1
            Jan Lindström made transition -
            In Progress Stalled
            38d 14h 29m 1
            Jan Lindström made transition -
            Stalled In Progress
            18m 14s 1
            Jan Lindström made transition -
            In Progress Needs Feedback
            45s 1
            Ramesh Sivaraman made transition -
            Needs Feedback Open
            1d 1h 17m 1
            Ramesh Sivaraman made transition -
            Open Confirmed
            7s 1
            Julien Fritsch made transition -
            Confirmed In Progress
            7d 4h 7m 1
            Jan Lindström made transition -
            In Progress In Review
            4d 18h 45m 1
            Jan Lindström made transition -
            In Review In Testing
            21h 20m 1
            Jan Lindström made transition -
            In Testing Stalled
            7s 1
            Jan Lindström made transition -
            Stalled In Review
            2m 29s 2
            Julius Goryavsky made transition -
            In Review Stalled
            2d 8h 2
            Julius Goryavsky made transition -
            Stalled Closed
            11m 35s 1

            People

              sysprg Julius Goryavsky
              frelist William Wong
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.