Debian Codegraph @

mysql-test/suite/galera/r/MDEV-20793.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 INT);
4 INSERT INTO t1 VALUES (1, 0), (5, 0);
5 connection node_1_ctrl;
6 SET SESSION wsrep_sync_wait = 0;
7 SET GLOBAL wsrep_slave_threads = 2;
8 connection node_1;
9 SET SESSION wsrep_retry_autocommit = 0;
10 START TRANSACTION;
11 UPDATE t1 SET f2 = 1;
12 connection node_1_ctrl;
13 SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync';
14 connection node_2;
15 INSERT INTO t1 VALUES (2, 2);
16 connection node_1_ctrl;
17 SET SESSION wsrep_on = 0;
18 SET SESSION wsrep_on = 1;
19 SET GLOBAL wsrep_provider_options = 'dbug=';
20 SET GLOBAL wsrep_provider_options = 'dbug=d,local_monitor_slave_enter_sync';
21 connection node_2;
22 UPDATE t1 SET f2 = 2 WHERE f1 = 5;
23 connection node_1_ctrl;
24 SET SESSION wsrep_on = 0;
25 SET SESSION wsrep_on = 1;
26 SET GLOBAL wsrep_provider_options = 'dbug=';
27 SET GLOBAL wsrep_provider_options = 'dbug=d,after_replicate_sync';
28 connection node_1;
29 SET SESSION debug_sync = "wsrep_before_replay SIGNAL reached WAIT_FOR continue";
30 COMMIT;
31 connection node_1_ctrl;
32 SET SESSION wsrep_on = 0;
33 SET SESSION wsrep_on = 1;
34 SET GLOBAL wsrep_provider_options = 'signal=after_replicate_sync';
35 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
36 SET SESSION debug_sync = "now WAIT_FOR reached";
37 SET GLOBAL wsrep_provider_options = 'signal=local_monitor_slave_enter_sync';
38 SET GLOBAL wsrep_provider_options = 'dbug=';
39 SET SESSION debug_sync = "now SIGNAL continue";
40 connection node_1;
41 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
42 SET debug_sync = "RESET";
43 DROP TABLE t1;
44 SET GLOBAL wsrep_slave_threads = DEFAULT;