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

galera_sr.GCF-900 MTR failed: query failed: 1146: Table 'test.t1' doesn't exist

    XMLWordPrintable

Details

    Description

      galera_sr.GCF-900 failed on BB 10.5 CS: "query 'ALTER TABLE t1 DROP COLUMN f2' failed: 1146: Table 'test.t1' doesn't exist".
      It seems to be a sporadic issue.

      stdio.log:

      10.5.9, ed5d675c75011603ee04f154fd4162ba1f0b630b, kvm-deb-xenial-x86

      galera_sr.GCF-900 'innodb'               w1 [ fail ]
              Test ended at 2020-12-22 11:37:14
       
      CURRENT_TEST: galera_sr.GCF-900
      mysqltest: At line 18: query 'ALTER TABLE t1 DROP COLUMN f2' 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 INT PRIMARY KEY, f2 INT) ENGINE=InnoDB;
      connection node_1;
      SET SESSION wsrep_trx_fragment_size = 128;
      START TRANSACTION;
      INSERT INTO t1 VALUES (1, 0);
      connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
      connection node_1a;
      SET SESSION wsrep_trx_fragment_size = 1;
      START TRANSACTION;
      INSERT INTO t1 VALUES (2, 0);
      connection node_2;
      ALTER TABLE t1 DROP COLUMN f2;
       
       - skipping '/dev/shm/var/1/log/galera_sr.GCF-900-innodb/'
       
      Retrying test galera_sr.GCF-900, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      galera_sr.GCF-900 'innodb'               w1 [ retry-pass ]   2151
       
      Retrying test galera_sr.GCF-900, attempt(3/3)...
       
      galera_sr.GCF-900 'innodb'               w1 [ retry-pass ]   2020
      

      Attachments

        Issue Links

          Activity

            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.