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

galera.galera_toi_alter_auto_increment fails: unexpected AUTO_INCREMENT warning matching MDEV-41017

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 11.4
    • N/A
    • Galera, Tests, MTR
    • None
    • Unexpected results
    • Dup of MDEV-41017 which has not been merged into its upward releases.

    Description

      The test galera.galera_toi_alter_auto_increment fails on the 11.4 branch with a result diff identical to the one fixed in MDEV-41017.

      Build Run Info

      Branch Builder name Date Commit Variant
      11.4 s390x-ubuntu-2204 2026-09-27 20:05:40 322658cd442333a13b46521d1acca67d1e8366cb  

      Failure text

      galera.galera_toi_alter_auto_increment   w4 [ fail ]
              Test ended at 2026-09-27 18:10:22
       
      CURRENT_TEST: galera.galera_toi_alter_auto_increment
      --- /home/buildbot/s390x-ubuntu-2204/build/mysql-test/suite/galera/r/galera_toi_alter_auto_increment.result	2026-09-27 16:46:12.000000000 +0000
      +++ /home/buildbot/s390x-ubuntu-2204/build/mysql-test/suite/galera/r/galera_toi_alter_auto_increment.reject	2026-09-27 18:10:11.832218621 +0000
      @@ -20,6 +20,8 @@
       1	1	1
       connection node_1;
       ALTER TABLE t1 AUTO_INCREMENT = 5;
      +Warnings:
      +Note	4190	ALTER TABLE is implicitly changing the value of 'AUTO_INCREMENT' from '5' to '1039'
       INSERT INTO t1 (f2) SELECT 1 FROM ten;
       connection node_2;
       INSERT INTO t1 (f2) SELECT 1 FROM ten;
       
      Result length mismatch

      Analysis

      The same diff appears across four different builders in the last 7 days (aarch64-debian-12, amd64-freebsd-14, ppc64le-ubuntu-2204, s390x-ubuntu-2204), which points at the branch/test itself rather than a single builder's environment.

      Regression of MDEV-41017

      This diff is identical to the one reported in MDEV-41017, which was closed Fixed on 2026-09-07 with Fix Version/s 10.11.20, 11.4.14, 11.8.10, 12.3.4, 13.0.2, 13.1.1. The failure continues on the 11.4 branch HEAD as recently as 2026-09-27 (commit 322658cd442333a13b46521d1acca67d1e8366cb), 20 days after that ticket closed, indicating the fix has not landed on the 11.4 branch HEAD yet or the issue has regressed.

      Created via the mtr-failure-bug skill.

      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:
                Resolved:

                Git Integration

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