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

galera.galera_truncate MTR fails: query 'TRUNCATE TABLE t1' 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-rpm-centos74-aarch64, kvm-rpm-centos73-ppc64, kvm-deb-bionic-aarch64

      Description

      galera.galera_truncate failed on BB 10.4 CS, BB 10.5 CS and BB 10.6 CS: "query 'TRUNCATE TABLE t1' failed: 1146: Table 'test.t1' doesn't exist".

      stdio.log:

      10.4.18, e007fcf59dd02407277b130dbd3984a7b5352c5e, kvm-rpm-centos74-aarch64

      galera.galera_truncate 'innodb'          w2 [ fail ]
              Test ended at 2020-12-08 11:20:11
       
      CURRENT_TEST: galera.galera_truncate
      mysqltest: At line 17: query 'TRUNCATE TABLE t1' 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;
      TRUNCATE TABLE t1;
       
       - saving '/dev/shm/var/2/log/galera.galera_truncate-innodb/' to '/dev/shm/var/log/galera.galera_truncate-innodb/'
       
      Retrying test galera.galera_truncate, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      galera.galera_truncate 'innodb'          w2 [ retry-fail ]
              Test ended at 2020-12-08 11:20:19
       
      CURRENT_TEST: galera.galera_truncate
      mysqltest: At line 32: query 'TRUNCATE TABLE t2' failed: 1146: Table 'test.t2' doesn't exist
       
      The result from queries just before the failure was:
      < snip >
      connection node_2;
      TRUNCATE TABLE t1;
      SELECT COUNT(*) = 0 FROM t1;
      COUNT(*) = 0
      1
      connection node_1;
      SELECT COUNT(*) = 0 FROM t1;
      COUNT(*) = 0
      1
      connection node_2;
      CREATE TABLE t2 (f1 VARCHAR(255)) Engine=InnoDB;
      INSERT INTO t2 VALUES ('abc');
      connection node_1;
      TRUNCATE TABLE t2;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/galera_truncate.log
       
       - skipping '/dev/shm/var/2/log/galera.galera_truncate-innodb/'
       
      Test galera.galera_truncate has failed 2 times, no more retries!
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      

      Server logs.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration