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

galera.galera_toi_ddl_sequential MTR failed: query failed: 1146: Table 'test.t1' doesn't exist

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.18, 10.5.9, 10.6.0
    • Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-deb-buster-aarch64, kvm-rpm-centos74-aarch64, kvm-deb-bionic-aarch64

      Description

      galera.galera_toi_ddl_sequential failed on BB 10.4 CS, BB 10.5 CS and BB 10.6 CS: "query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 1146: Table 'test.t1' doesn't exist".

      stdio.log:

      10.4.18, dcc7f93965f7fb534f29c5c682b2abf22e808fe2, kvm-deb-buster-aarch64

      galera.galera_toi_ddl_sequential 'innodb' w2 [ fail ]
              Test ended at 2020-12-11 23:35:32
       
      CURRENT_TEST: galera.galera_toi_ddl_sequential
      mysqltest: At line 12: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 1146: Table 'test.t1' doesn't exist
       
      The result from queries just before the failure was:
      connection node_2;
      connection node_1;
      CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1);
      connection node_2;
      ALTER TABLE t1 ADD COLUMN f2 INTEGER;
       
       - saving '/dev/shm/var/2/log/galera.galera_toi_ddl_sequential-innodb/' to '/dev/shm/var/log/galera.galera_toi_ddl_sequential-innodb/'
       
      Retrying test galera.galera_toi_ddl_sequential, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      galera.galera_toi_ddl_sequential 'innodb' w2 [ retry-pass ]   2036
       
      Retrying test galera.galera_toi_ddl_sequential, attempt(3/3)...
       
      galera.galera_toi_ddl_sequential 'innodb' w2 [ retry-pass ]   2049
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stepan.patryshev Stepan Patryshev
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: