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
              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.