[MDEV-24500] galera_sr.GCF-900 MTR failed: query failed: 1146: Table 'test.t1' doesn't exist Created: 2020-12-29  Updated: 2021-01-05  Resolved: 2021-01-05

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.5.9
Fix Version/s: 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-xenial-x86


Issue Links:
Relates
relates to MDEV-22181 galera.galera_sst_mysqldump_with_key ... Closed
relates to MDEV-24462 galera.galera_truncate MTR fails: que... Closed
relates to MDEV-24464 galera.galera_toi_ddl_sequential MTR ... 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

 Description   

galera_sr.GCF-900 failed on BB 10.5 CS: "query 'ALTER TABLE t1 DROP COLUMN f2' failed: 1146: Table 'test.t1' doesn't exist".
It seems to be a sporadic issue.

stdio.log:

10.5.9, ed5d675c75011603ee04f154fd4162ba1f0b630b, kvm-deb-xenial-x86

galera_sr.GCF-900 'innodb'               w1 [ fail ]
        Test ended at 2020-12-22 11:37:14
 
CURRENT_TEST: galera_sr.GCF-900
mysqltest: At line 18: query 'ALTER TABLE t1 DROP COLUMN f2' 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 INT PRIMARY KEY, f2 INT) ENGINE=InnoDB;
connection node_1;
SET SESSION wsrep_trx_fragment_size = 128;
START TRANSACTION;
INSERT INTO t1 VALUES (1, 0);
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1a;
SET SESSION wsrep_trx_fragment_size = 1;
START TRANSACTION;
INSERT INTO t1 VALUES (2, 0);
connection node_2;
ALTER TABLE t1 DROP COLUMN f2;
 
 - skipping '/dev/shm/var/1/log/galera_sr.GCF-900-innodb/'
 
Retrying test galera_sr.GCF-900, attempt(2/3)...
 
worker[1] > Restart  - not started
worker[1] > Restart  - not started
galera_sr.GCF-900 'innodb'               w1 [ retry-pass ]   2151
 
Retrying test galera_sr.GCF-900, attempt(3/3)...
 
galera_sr.GCF-900 'innodb'               w1 [ retry-pass ]   2020


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