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

    XMLWordPrintable

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

            People

              sysprg Julius Goryavsky (Inactive)
              frelist William Wong
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 6d 3.75h
                  6d 3.75h

                  Git Integration

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