[MDEV-24699] galera.galera_truncate MTR failed: Table 'test.t2' doesn't exist Created: 2021-01-26  Updated: 2021-09-29  Resolved: 2021-01-28

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.18, 10.5, 10.6
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Stepan Patryshev (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

kvm-deb-bionic-amd64


Issue Links:
Relates
relates to MDEV-24462 galera.galera_truncate MTR fails: que... Closed

 Description   

galera.galera_truncate failed on BB 10.4 CS, BB 10.5 CS and BB 10.6 CS: "Table 'test.t2' doesn't exist".
It seems to be a sporadic issue.

stdio.log:

10.4.18, 1398160a719394cff3e7e4ee214f51375e8825a1, kvm-deb-bionic-amd64

galera.galera_truncate 'innodb'          w2 [ fail ]
        Test ended at 2021-01-26 09:23:46
 
CURRENT_TEST: galera.galera_truncate
mysqltest: At line 35: 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;


Generated at Thu Feb 08 09:32:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.