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.
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
- relates to
-
MDEV-24462 galera.galera_truncate MTR fails: query 'TRUNCATE TABLE t1' failed: 1146: Table 'test.t1' doesn't exist
- Closed
-
MDEV-24464 galera.galera_toi_ddl_sequential MTR failed: query failed: 1146: Table 'test.t1' doesn't exist
- Closed
-
MDEV-24465 galera.galera_rsu_error MTR failed: query failed with wrong errno 1146: 'Table 'test.t1' doesn't exist'
- Closed
-
MDEV-24480 galera_3nodes.GCF-363 MTR failed: query failed: 1146: Table 'test.t1' doesn't exist
- Closed
-
MDEV-24500 galera_sr.GCF-900 MTR failed: query failed: 1146: Table 'test.t1' doesn't exist
- Closed