[MDEV-24166] Galera test failure on galera_toi_alter_auto_increment Created: 2020-11-09  Updated: 2020-11-17  Resolved: 2020-11-17

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 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;
    


Generated at Thu Feb 08 09:27:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.