[MDEV-22181] galera.galera_sst_mysqldump_with_key MTR failed: INSERT failed: 1146: Table 'test.t1' doesn't exist Created: 2020-04-07  Updated: 2020-12-29  Resolved: 2020-04-22

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.13, 10.5
Fix Version/s: 10.2.32, 10.3.23, 10.4.13, 10.5.3

Type: Bug Priority: Critical
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 1
Labels: None
Environment:

kvm-deb-eoan-amd64


Issue Links:
Relates
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-24500 galera_sr.GCF-900 MTR failed: query f... Closed

 Description   

galera.galera_sst_mysqldump_with_key failed on bb: INSERT failed: 1146: Table 'test.t1' doesn't exist.

stdio.log:

10.4.13 bdcecfa22cc2eb255610f5574ff0a91c8d247066

alera.galera_sst_mysqldump_with_key 'innodb,release' [ fail ]
        Test ended at 2020-03-31 08:52:00
 
CURRENT_TEST: galera.galera_sst_mysqldump_with_key
mysqltest: In included file "./suite/galera/include/galera_st_kill_slave.inc": 
included from /usr/share/mysql/mysql-test/suite/galera/t/galera_sst_mysqldump_with_key.test at line 27:
At line 17: query 'INSERT INTO t1 VALUES ('node2_committed_before')' failed: 1146: Table 'test.t1' doesn't exist
 
The result from queries just before the failure was:
< snip >
COUNT(*) = 0
1
DROP TABLE t1;
COMMIT;
SET AUTOCOMMIT=ON;
Performing State Transfer on a server that has been killed and restarted
connection node_1;
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
INSERT INTO t1 VALUES ('node1_committed_before');
INSERT INTO t1 VALUES ('node1_committed_before');
INSERT INTO t1 VALUES ('node1_committed_before');
INSERT INTO t1 VALUES ('node1_committed_before');
INSERT INTO t1 VALUES ('node1_committed_before');
COMMIT;
connection node_2;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
INSERT INTO t1 VALUES ('node2_committed_before');



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-04-10 ]

It failed also on Jenkins, 10.5 ES, debug build, ubuntu-2004.

Comment by Otto Kekäläinen [ 2020-04-11 ]

Another example: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-buster-amd64/builds/2128/steps/galera-sst-mysqldump/logs/stdio

Seems to be somewhat sporadic.

Comment by Otto Kekäläinen [ 2020-04-19 ]

And again:

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