[MDEV-24055] galera_3nodes.galera_parallel_apply_3nodes MTR failed: query 'reap' failed: 1213: Deadlock found when trying to get lock Created: 2020-10-29  Updated: 2020-11-19  Resolved: 2020-11-19

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

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

kvm-deb-groovy-aarch64



 Description   

galera_3nodes.galera_parallel_apply_3nodes MTR failed on BB, 10.5: "query 'reap' failed: 1213: Deadlock found when trying to get lock".

stdio.log:

10.5.7 c27e53f45992d0b0b5eb5ff6242cfe1a78eba8b5

galera_3nodes.galera_parallel_apply_3nodes 'innodb' w1 [ fail ]
        Test ended at 2020-10-26 21:05:15
 
CURRENT_TEST: galera_3nodes.galera_parallel_apply_3nodes
mysqltest: At line 27: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 
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_3;
SET GLOBAL wsrep_slave_threads = 2;
connection node_1;
UPDATE t1 SET f1 = f1 + 10;;
connection node_2;
UPDATE t1 SET f1 = f1 + 100;;
connection node_1;



 Comments   
Comment by Jan Lindström (Inactive) [ 2020-11-18 ]

https://github.com/MariaDB/server/pull/1703

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