[MDEV-24462] galera.galera_truncate MTR fails: query 'TRUNCATE TABLE t1' failed: 1146: Table 'test.t1' doesn't exist Created: 2020-12-21  Updated: 2021-01-26  Resolved: 2021-01-04

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
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

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

kvm-rpm-centos74-aarch64, kvm-rpm-centos73-ppc64, kvm-deb-bionic-aarch64


Attachments: Zip Archive MDEV-24462_104_logs_201208.zip    
Issue Links:
Relates
relates to MDEV-24464 galera.galera_toi_ddl_sequential MTR ... Closed
relates to MDEV-22181 galera.galera_sst_mysqldump_with_key ... Closed
relates to MDEV-24465 galera.galera_rsu_error MTR failed: q... Closed
relates to MDEV-24480 galera_3nodes.GCF-363 MTR failed: que... Closed
relates to MDEV-24482 galera.galera_truncate_temporary MTR ... Closed
relates to MDEV-24500 galera_sr.GCF-900 MTR failed: query f... Closed
relates to MDEV-24699 galera.galera_truncate MTR failed: Ta... Closed

 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.


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