[MDEV-32782] galera_sst_mysqldump_with_key test failed Created: 2023-11-11  Updated: 2023-12-12

Status: Open
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.31
Fix Version/s: 10.4

Type: Bug Priority: Critical
Reporter: Julius Goryavsky Assignee: Seppo Jaakola
Resolution: Unresolved Votes: 1
Labels: None

Issue Links:
Blocks
blocks MDEV-30172 Galera test case cleanup Stalled
Relates

 Description   

galera_sst_mysqldump_with_key test failed:

galera.galera_sst_mysqldump_with_key 'debug,innodb' [ fail ]
        Test ended at 2023-11-10 22:56:08
 
CURRENT_TEST: galera.galera_sst_mysqldump_with_key
mysqltest: In included file "./suite/galera/include/galera_st_kill_slave.inc": 
included from /home/panda/mariadb-10.4/mysql-test/suite/galera/t/galera_sst_mysqldump_with_key.test at line 27:
At line 24: query 'COMMIT' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 
The result from queries just before the failure was:
< snip >
Performing State Transfer on a server that has been killed and restarted
connection node_1;
CREATE TABLE t1 (id int not null primary key,f1 CHAR(255)) ENGINE=InnoDB;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
INSERT INTO t1 VALUES (1,'node1_committed_before');
INSERT INTO t1 VALUES (2,'node1_committed_before');
INSERT INTO t1 VALUES (3,'node1_committed_before');
INSERT INTO t1 VALUES (4,'node1_committed_before');
INSERT INTO t1 VALUES (5,'node1_committed_before');
COMMIT;
connection node_2;
SET AUTOCOMMIT=OFF;
START TRANSACTION;
INSERT INTO t1 VALUES (6,'node2_committed_before');
INSERT INTO t1 VALUES (7,'node2_committed_before');
INSERT INTO t1 VALUES (8,'node2_committed_before');
INSERT INTO t1 VALUES (9,'node2_committed_before');
INSERT INTO t1 VALUES (10,'node2_committed_before');
COMMIT;


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