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

Galera test failure on galera_toi_alter_auto_increment

Details

    Description

      • http://buildbot.askmonty.org/buildbot/builders/kvm-deb-focal-aarch64/builds/888/steps/mtr-galera/logs/stdio

        galera.galera_toi_alter_auto_increment 'innodb' w2 [ fail ]
                Test ended at 2020-11-09 03:44:45
         
        CURRENT_TEST: galera.galera_toi_alter_auto_increment
        mysqltest: At line 87: query 'ALTER TABLE t1 AUTO_INCREMENT=100' failed: 1146: Table 'test.t1' doesn't exist
         
        The result from queries just before the failure was:
        < snip >
        SELECT MIN(f1) >= 1000, COUNT(*) = 40, COUNT(DISTINCT f1) = 40 FROM t1 WHERE f1 >= 1000;
        MIN(f1) >= 1000	COUNT(*) = 40	COUNT(DISTINCT f1) = 40
        1	1	1
        connection node_1;
        SELECT MIN(f1) >= 1000, COUNT(*) = 40, COUNT(DISTINCT f1) = 40 FROM t1 WHERE f1 >= 1000;
        MIN(f1) >= 1000	COUNT(*) = 40	COUNT(DISTINCT f1) = 40
        1	1	1
        DROP TABLE t1;
        connection node_1;
        SET GLOBAL wsrep_auto_increment_control = OFF;
        SET GLOBAL auto_increment_increment = 1;
        SET GLOBAL auto_increment_offset = 1;
        connection node_2;
        SET GLOBAL wsrep_auto_increment_control = OFF;
        SET GLOBAL auto_increment_increment = 1;
        SET GLOBAL auto_increment_offset = 1;
        connection node_1a;
        CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
        connection node_2a;
        ALTER TABLE t1 AUTO_INCREMENT=100;
        

      Attachments

        Activity

          jplindst Jan Lindström (Inactive) created issue -
          jplindst Jan Lindström (Inactive) made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2020-11-17 11:29:02.0 2020-11-17 11:29:02.074
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.2.37 [ 25112 ]
          Fix Version/s 10.3.28 [ 25111 ]
          Fix Version/s 10.4.18 [ 25110 ]
          Fix Version/s 10.5.9 [ 25109 ]
          Fix Version/s 10.6.0 [ 24431 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 115549 ] MariaDB v4 [ 158565 ]

          People

            jplindst Jan Lindström (Inactive)
            jplindst Jan Lindström (Inactive)
            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.