Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_duplicate_primary_value.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
5 connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1;
6 connect node_1d, 127.0.0.1, root, , test, $NODE_MYPORT_1;
7 connect node_1e, 127.0.0.1, root, , test, $NODE_MYPORT_1;
8 connection node_1;
9 CREATE TABLE t1(a int not null primary key auto_increment, b int) engine=innodb;
10 INSERT INTO t1(b) VALUES (1);
11 connection node_1c;
12 begin;
13 insert into t1 values (2,2);
14 connection node_1d;
15 begin;
16 insert into t1 values (3,3);
17 connection node_1a;
18 SET GLOBAL DEBUG_DBUG='+d,wsrep_after_kill';
19 connection node_2;
20 insert into t1 values (2,6);
21 connection node_1a;
22 SET SESSION wsrep_sync_wait=0;
23 SET DEBUG_SYNC='now WAIT_FOR wsrep_after_kill_reached';
24 SET GLOBAL DEBUG_DBUG='';
25 SET GLOBAL DEBUG_DBUG='+d,wsrep_after_kill_2';
26 connection node_3;
27 insert into t1 values (3,9);
28 connection node_1a;
29 SET DEBUG_SYNC='now WAIT_FOR wsrep_after_kill_reached_2';
30 SET GLOBAL DEBUG_DBUG='';
31 SET DEBUG_SYNC='now SIGNAL wsrep_after_kill_continue';
32 connection node_1c;
33 COMMIT;
34 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
35 connection node_1a;
36 SET GLOBAL DEBUG_DBUG='';
37 SET DEBUG_SYNC='now SIGNAL wsrep_after_kill_continue_2';
38 connection node_1d;
39 COMMIT;
40 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
41 connection node_2;
42 SELECT * from t1;
43 a b
44 1 1
45 2 6
46 3 9
47 connection node_3;
48 SELECT * from t1;
49 a b
50 1 1
51 2 6
52 3 9
53 connection node_1a;
54 SET DEBUG_SYNC = reset;
55 connection node_1e;
56 set debug_sync = reset;
57 connection node_1;
58 SELECT * from t1;
59 a b
60 1 1
61 2 6
62 3 9
63 disconnect node_1a;
64 disconnect node_1b;
65 disconnect node_1c;
66 disconnect node_1d;
67 disconnect node_1e;
68 drop table t1;