Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a,127.0.0.1,root,,test,$NODE_MYPORT_1;
4 connection node_1;
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
6 SET GLOBAL DEBUG_DBUG = 'd,sync.wsrep_rollback_mdl_release';
7 connection node_2;
8 SET SESSION wsrep_trx_fragment_size = 1;
9 START TRANSACTION;
10 INSERT INTO t1 VALUES (1);
11 connection node_1a;
12 SELECT COUNT(*) FROM t1;
13 COUNT(*)
14 0
15 SET SESSION wsrep_retry_autocommit = 0;
16 SET DEBUG_SYNC = 'ha_write_row_start SIGNAL may_toi WAIT_FOR bf_abort';
17 INSERT INTO t1 VALUES (2);
18 connection node_1;
19 SET DEBUG_SYNC = 'now WAIT_FOR may_toi';
20 SET DEBUG_SYNC = 'after_wsrep_thd_abort WAIT_FOR sync.wsrep_rollback_mdl_release_reached';
21 TRUNCATE TABLE t1;
22 connection node_1a;
23 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
24 SET DEBUG_SYNC = 'now SIGNAL signal.wsrep_rollback_mdl_release';
25 connection node_2;
26 INSERT INTO t1 VALUES (3);
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 connection node_1;
29 SET GLOBAL DEBUG_DBUG = '';
30 SET DEBUG_SYNC = 'RESET';
31 DROP TABLE t1;
32 disconnect node_1a;
33 disconnect node_2;
34 disconnect node_1;