Debian Codegraph @

mysql-test/suite/galera/r/mysql-wsrep-bugs-607.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # test the order of wsrep XID storage after certifiation failure
5 #
6 connection node_1;
7 set session wsrep_sync_wait=0;
8 create table t1 (i int primary key, j int);
9 insert into t1 values (4, 0);
10 connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;
11 connection node_2b;
12 set session wsrep_sync_wait=0;
13 SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb";
14 connection node_1;
15 UPDATE test.t1 set j=1 where i=4;
16 connection node_2b;
17 SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
18 connection node_2;
19 set session wsrep_sync_wait=0;
20 set session wsrep_retry_autocommit=0;
21 UPDATE test.t1 SET j=2 WHERE i=4;
22 connection node_2b;
23 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
24 SET GLOBAL debug_dbug = "";
25 SET DEBUG_SYNC = "RESET";
26 connection node_2;
27 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
28 select * from t1;
29 i j
30 4 1
31 DROP TABLE t1;