[MDEV-21518] galera.galera_toi_ddl_nonconflicting MTR failed: 1213: Deadlock found when trying to get lock Created: 2020-01-17  Updated: 2023-07-21  Resolved: 2022-01-21

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.12
Fix Version/s: N/A

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

kvm-zyp-opensuse150-amd64



 Description   

galera.galera_toi_ddl_nonconflicting failed on bb.

stdout.log:

10.4.12 6a8a4c19e2db22573207f32a714d354f8e870df0

galera.galera_toi_ddl_nonconflicting 'innodb' w1 [ fail ]
        Test ended at 2020-01-15 20:00:46
 
CURRENT_TEST: galera.galera_toi_ddl_nonconflicting
mysqltest: At line 17: 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 AUTO_INCREMENT, f2 INTEGER);
connection node_2;
ALTER TABLE t1 ADD COLUMN f3 INTEGER; INSERT INTO t1 (f1, f2) VALUES (DEFAULT, 123);;
connection node_1;
CREATE UNIQUE INDEX i1 ON t1(f2);;
connection node_2;
 
 - skipping '/dev/shm/var/1/log/galera.galera_toi_ddl_nonconflicting-innodb/'
 
Retrying test galera.galera_toi_ddl_nonconflicting, attempt(2/3)...
 
worker[1] > Restart  - not started
worker[1] > Restart  - not started


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