Debian Codegraph @

mysql-test/suite/galera_sr/r/MDEV-25717.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
5 INSERT INTO t1 VALUES (1), (2), (3);
6 connection node_2;
7 SET SESSION wsrep_trx_fragment_size = 1;
8 START TRANSACTION;
9 INSERT INTO t1 VALUES (4);
10 connection node_1;
11 SELECT COUNT(*) FROM t1;
12 COUNT(*)
13 3
14 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
15 connection node_2a;
16 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_apply_toi";
17 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
18 connection node_1a;
19 SET GLOBAL DEBUG_DBUG = "d,sync.wsrep_bf_abort";
20 connection node_1;
21 TRUNCATE TABLE t1;
22 connection node_1a;
23 SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_bf_abort_reached";
24 connection node_2a;
25 SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_toi_reached";
26 connection node_2;
27 INSERT INTO t1 VALUES (5);
28 connection node_2a;
29 SET SESSION wsrep_sync_wait = 0;
30 SET SESSION wsrep_sync_wait = DEFAULT;
31 SET GLOBAL DEBUG_DBUG = "";
32 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_toi";
33 connection node_2;
34 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
35 connection node_1a;
36 SET SESSION wsrep_sync_wait=0;
37 SET GLOBAL DEBUG_DBUG = "+d,sync.wsrep_log_dummy_write_set";
38 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_bf_abort";
39 SET DEBUG_SYNC = "now WAIT_FOR sync.wsrep_log_dummy_write_set_reached";
40 connection node_1;
41 connection node_2;
42 SET GLOBAL DEBUG_DBUG = "";
43 SET DEBUG_SYNC = "RESET";
44 connection node_1;
45 SET GLOBAL DEBUG_DBUG = "";
46 SET DEBUG_SYNC = "RESET";
47 DROP TABLE t1;