[MDEV-14147] galera.MW-258 fails with a deadlock Created: 2017-10-26  Updated: 2020-01-15  Resolved: 2020-01-15

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

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Stepan Patryshev (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: need_feedback
Environment:

libgalera 25.3.14



 Description   

10.2 e99c7c8334f842a debug build

galera.MW-258 'innodb'                   w2 [ fail ]
        Test ended at 2017-10-26 03:58:36
 
CURRENT_TEST: galera.MW-258
mysqltest: At line 33: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
 
The result from queries just before the failure was:
< snip >
connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1a;
SET SESSION wsrep_sync_wait = 0;
SET SESSION wsrep_osu_method = RSU;
ALTER TABLE t1 ADD COLUMN f2 INTEGER;;
connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
connection node_1b;
SET SESSION wsrep_sync_wait = 0;
SET SESSION wsrep_osu_method = RSU;
ALTER TABLE t1 ADD COLUMN f3 INTEGER;;
connection node_1;
value during RSU:
SHOW STATUS LIKE 'wsrep_desync_count';
Variable_name   Value
SHOW VARIABLES LIKE 'wsrep_desync';
Variable_name   Value
wsrep_desync    OFF
UNLOCK TABLES;
connection node_1a;
connection node_1b;



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-01-15 ]

Closed since it is not reproduced on bb or Azure.

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