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

Galera test failure on galera_toi_alter_auto_increment

    XMLWordPrintable

    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

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            jplindst Jan Lindström
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration