Debian Codegraph @

mysql-test/suite/galera_3nodes/t/galera_duplicate_primary_value.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_debug.inc
4 --source include/have_debug_sync.inc
5 --source include/big_test.inc
6
7 --let $galera_connection_name = node_3
8 --let $galera_server_number = 3
9 --source include/galera_connect.inc
10
11 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
12 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
13 --connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1
14 --connect node_1d, 127.0.0.1, root, , test, $NODE_MYPORT_1
15 --connect node_1e, 127.0.0.1, root, , test, $NODE_MYPORT_1
16
17 --connection node_1
18 CREATE TABLE t1(a int not null primary key auto_increment, b int) engine=innodb;
19 INSERT INTO t1(b) VALUES (1);
20
21 --connection node_1c
22 begin;
23 insert into t1 values (2,2);
24
25 --connection node_1d
26 begin;
27 insert into t1 values (3,3);
28
29 --connection node_1a
30 SET GLOBAL DEBUG_DBUG='+d,wsrep_after_kill';
31
32 --connection node_2
33 insert into t1 values (2,6);
34
35 --connection node_1a
36 SET SESSION wsrep_sync_wait=0;
37 SET DEBUG_SYNC='now WAIT_FOR wsrep_after_kill_reached';
38 SET GLOBAL DEBUG_DBUG='';
39 SET GLOBAL DEBUG_DBUG='+d,wsrep_after_kill_2';
40
41 --connection node_3
42 insert into t1 values (3,9);
43
44 --connection node_1a
45 SET DEBUG_SYNC='now WAIT_FOR wsrep_after_kill_reached_2';
46 SET GLOBAL DEBUG_DBUG='';
47 SET DEBUG_SYNC='now SIGNAL wsrep_after_kill_continue';
48
49 --connection node_1c
50 --error 1213
51 COMMIT;
52
53 --connection node_1a
54 SET GLOBAL DEBUG_DBUG='';
55 SET DEBUG_SYNC='now SIGNAL wsrep_after_kill_continue_2';
56
57 --connection node_1d
58 --error 1213
59 COMMIT;
60
61 --connection node_2
62 SELECT * from t1;
63
64 --connection node_3
65 SELECT * from t1;
66
67 --connection node_1a
68 SET DEBUG_SYNC = reset;
69
70 --connection node_1e
71 set debug_sync = reset;
72
73 --connection node_1
74 SELECT * from t1;
75
76 --disconnect node_1a
77 --disconnect node_1b
78 --disconnect node_1c
79 --disconnect node_1d
80 --disconnect node_1e
81
82 drop table t1;