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

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.18, 10.5.9, 10.6.0
    • 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0
    • Galera, Tests
    • None
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22181 galera.galera_sst_mysqldump_with_key MTR failed: INSERT failed: 1146: Table 'test.t1' doesn't exist

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24462 galera.galera_truncate MTR fails: query 'TRUNCATE TABLE t1' failed: 1146: Table 'test.t1' doesn't exist

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24465 galera.galera_rsu_error MTR failed: query failed with wrong errno 1146: 'Table 'test.t1' doesn't exist'

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24480 galera_3nodes.GCF-363 MTR failed: query failed: 1146: Table 'test.t1' doesn't exist

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24482 galera.galera_truncate_temporary MTR failed: query failed: 1146: Table 'test.t1' doesn't exist

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24500 galera_sr.GCF-900 MTR failed: query failed: 1146: Table 'test.t1' doesn't exist

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            stepan.patryshev Stepan Patryshev (Inactive) created issue -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Field Original Value New Value
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            stepan.patryshev Stepan Patryshev (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.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 117265 ] MariaDB v4 [ 158720 ]

            People

              stepan.patryshev Stepan Patryshev (Inactive)
              stepan.patryshev Stepan Patryshev (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.