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

galera.galera_sequences fails on recent builds

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4
    • None
    • Galera, Tests, MTR
    • None

    Description

      galera.galera_sequences fails on recent build 10.6, 10.11 and 11.4 branches.

      Here are the details:

      {
          "builder_name": "amd64-freebsd-14",
          "commit": "c57069561c4fe8f72191d4a2a4a829e5b57537dc",
          "branch": "11.4",
          "dt": "2026-07-31T13:20:44Z",
          "test_name": "galera.galera_sequences",
          "test_variant": "binlogoff",
          "info_text": "",
          "failure_text": "galera.galera_sequences 'binlogoff'      w11 [ fail ]\n        Test ended at 2026-07-31 13:31:31\n\nWSREP did not transition to state READY\n\n - saving '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/11/log/galera.galera_sequences-binlogoff/' to '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/log/galera.galera_sequences-binlogoff/'\n\nRetrying test galera.galera_sequences, attempt(2/3)...\n"
        },
        {
          "builder_name": "amd64-freebsd-14",
          "commit": "67ea07dd3400004e4f7ae01bf977f4344bbe064b",
          "branch": "10.6",
          "dt": "2026-07-29T10:17:53Z",
          "test_name": "galera.galera_sequences",
          "test_variant": "binlogoff",
          "info_text": "",
          "failure_text": "galera.galera_sequences 'binlogoff'      w10 [ fail ]\n        Test ended at 2026-07-29 10:25:26\n\nCURRENT_TEST: galera.galera_sequences\nmysqltest: At line 308: query 'INSERT INTO t1(a,b) VALUES (2,2)' failed: ER_DUP_ENTRY (1062): Duplicate entry '2' for key 'PRIMARY'\n\nThe result from queries just before the failure was:\n< snip >\nconnection node_1;\nDROP SEQUENCE t;\nDROP TABLE t1;\nCREATE SEQUENCE t INCREMENT BY 0 CACHE=20 ENGINE=INNODB;\nALTER TABLE t ENGINE=MYISAM;\nERROR 42000: This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'\nALTER SEQUENCE t INCREMENT BY 1 CACHE=10;\nERROR 42000: This version of MariaDB doesn't yet support 'CACHE without INCREMENT BY 0 in Galera cluster'\nALTER SEQUENCE t INCREMENT BY 1 NOCACHE;\nALTER SEQUENCE t INCREMENT BY 0 NOCACHE;\nALTER SEQUENCE t INCREMENT BY 0 CACHE=10;\nDROP SEQUENCE t;\nCREATE SEQUENCE t INCREMENT BY 0 CACHE=20 ENGINE=INNODB;\nCREATE TABLE t1(a int not null primary key default nextval(t), b int) engine=innodb;\nBEGIN;\nINSERT INTO t1(b) VALUES (1);\nINSERT INTO t1(b) VALUES (2);\nINSERT INTO t1(b) VALUES (3);\nINSERT INTO t1(b) VALUES (4);\nINSERT INTO t1(a,b) VALUES (2,2);\n\nMore results from queries before failure can be found in /data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/10/log/galera_sequences,binlogoff.log\n\n - saving '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/10/log/galera.galera_sequences-binlogoff/' to '/data/buildbot/workers/prod/amd64-freebsd-14/build/mysql-test/var/log/galera.galera_sequences-binlogoff/'\n\nRetrying test galera.galera_sequences, attempt(2/3)...\n"
        },
        {
          "builder_name": "aarch64-debian-12",
          "commit": "ac3f338b3d02e2944305e6b6296b0413ad5e592c",
          "branch": "10.11",
          "dt": "2026-07-28T00:21:08Z",
          "test_name": "galera.galera_sequences",
          "test_variant": "binlogon",
          "info_text": "",
          "failure_text": "galera.galera_sequences 'binlogon'       w5 [ fail ]\n        Test ended at 2026-07-27 22:35:55\n\nCURRENT_TEST: galera.galera_sequences\n\n\nFailed to start mysqld.2\nmysqltest failed but provided no output\n - skipping '/home/buildbot/aarch64-debian-12/build/mysql-test/var/5/log/galera.galera_sequences-binlogon/'\n\nRetrying test galera.galera_sequences, attempt(2/3)...\n\n"
        }
      

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              susil.behera Susil Behera
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.