[MDEV-24463] galera.galera_sst_mysqldump_with_key MTR failed: 'INSERT failed: 1213: Deadlock found when trying to get lock Created: 2020-12-21  Updated: 2021-01-25  Resolved: 2021-01-23

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.18
Fix Version/s: 10.4.18, 10.5.9

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

kvm-deb-xenial-amd64


Attachments: Zip Archive MDEV-24463_104_logs_201211.zip    
Issue Links:
Relates

 Description   

galera.galera_sst_mysqldump_with_key failed on BB 10.4 CS: "galera_sst_mysqldump_with_key.test at line 27:
At line 17: query 'INSERT INTO t1 VALUES ('node2_committed_before')' failed: 1213: Deadlock found when trying to get lock;".
It seems to be a sporadic issue.

stdio.log:

10.4.18, 4addd31531f722438b8b702c9cd00c28b61efce3, kvm-deb-xenial-amd64

galera.galera_sst_mysqldump_with_key 'innodb,release' [ fail ]
        Test ended at 2020-12-11 12:06:58
 
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: 1213: Deadlock found when trying to get lock; try restarting transaction
 
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');

Server logs.


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