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

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

    XMLWordPrintable

    Details

      Description

      galera.galera_truncate_temporary failed on BB 10.5 CS and BB 10.6 CS: "query 'TRUNCATE TABLE t1' failed: 1146: Table 'test.t1' doesn't exist".
      It seems to be a sporadic issue.

      stdio.log:

      10.5.9, 2c226e01a88e18ae8bcc7f584ac6c9c37fb800b0, kvm-rpm-fedora32-amd64

      galera.galera_truncate_temporary 'innodb' w2 [ fail ]
              Test ended at 2020-12-14 19:14:16
       
      CURRENT_TEST: galera.galera_truncate_temporary
      mysqltest: At line 70: query 'TRUNCATE TABLE t1' failed: 1146: Table 'test.t1' doesn't exist
       
      The result from queries just before the failure was:
      < snip >
      SELECT f1 = 1 FROM t1;
      f1 = 1
      1
      TRUNCATE TABLE t1;
      SELECT COUNT(*) = 0 FROM t1;
      COUNT(*) = 0
      1
      connection node_2;
      SELECT COUNT(*) = 0 FROM t1;
      COUNT(*) = 0
      1
      connection node_1;
      DROP TABLE t1;
      connection node_1;
      CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1);
      CREATE TEMPORARY TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (2);
      connection node_2;
      TRUNCATE TABLE t1;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/galera_truncate_temporary.log
       
       - saving '/dev/shm/var/2/log/galera.galera_truncate_temporary-innodb/' to '/dev/shm/var/log/galera.galera_truncate_temporary-innodb/'
       
      Retrying test galera.galera_truncate_temporary, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      

        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: