Debian Codegraph @

mysql-test/suite/galera/r/galera_bf_abort_at_after_statement.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (id INT PRIMARY KEY, val INT);
5 INSERT INTO t1 VALUES (1, 1);
6 connection node_2;
7 SET DEBUG_SYNC = 'RESET';
8 START TRANSACTION;
9 SET DEBUG_SYNC = 'wsrep_after_statement_enter SIGNAL blocked WAIT_FOR continue';
10 UPDATE t1 SET val=2 WHERE id=1;
11 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
12 SET DEBUG_SYNC = 'now WAIT_FOR blocked';
13 connection node_1;
14 UPDATE t1 SET val=3 WHERE id=1;
15 connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;
16 set session wsrep_sync_wait=0;
17 connection node_2a;
18 SET DEBUG_SYNC = 'now SIGNAL continue';
19 connection node_2;
20 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
21 COMMIT;
22 SET DEBUG_SYNC = 'RESET';
23 connection node_1;
24 SET DEBUG_SYNC = 'RESET';
25 DROP TABLE t1;
26 disconnect node_2a;
27 disconnect node_2b;