Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_3;
6 connection node_1;
7 CREATE TABLE t1 (pk INT PRIMARY KEY, node INT) ENGINE=innodb;
8 INSERT INTO t1 VALUES (1, 1);
9 connection node_2;
10 connection node_1;
11 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
12 connection node_2;
13 connection node_3;
14 INSERT INTO t1 VALUES (2, 3);
15 connection node_2;
16 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
17 SET wsrep_sync_wait = 0;
18 SET wsrep_on = OFF;
19 SET GLOBAL wsrep_provider_options = 'dbug=d,after_shift_to_joining';
20 connection node_1;
21 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
22 connection node_2;
23 INSERT INTO t1 VALUES (3, 2);
24 connection node_1a;
25 SET SESSION wsrep_on = 0;
26 SET SESSION wsrep_on = 0;
27 connection node_3;
28 connection node_1;
29 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
30 connection node_2;
31 connection node_3;
32 INSERT INTO t1 VALUES (4, 3);
33 connection node_2;
34 connection node_1;
35 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
36 connection node_2;
37 INSERT INTO t1 VALUES (5, 2);
38 connection node_3;
39 connection node_1a;
40 SET GLOBAL wsrep_provider_options = 'dbug=d,before_send_state_request';
41 SET GLOBAL wsrep_provider_options = 'signal=after_shift_to_joining';
42 SET SESSION wsrep_on = 0;
43 SET SESSION wsrep_on = 0;
44 SET GLOBAL wsrep_provider_options = 'dbug=';
45 connection node_1;
46 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
47 connection node_2;
48 connection node_3;
49 connection node_1a;
50 SET GLOBAL wsrep_provider_options = 'dbug=d,after_shift_to_joining';
51 SET GLOBAL wsrep_provider_options = 'signal=before_send_state_request';
52 4
53 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters';
54 VARIABLE_NAME VARIABLE_VALUE
55 WSREP_DEBUG_SYNC_WAITERS
56 connection node_3;
57 INSERT INTO t1 VALUES (6, 3);
58 connection node_2;
59 connection node_1;
60 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
61 connection node_2;
62 INSERT INTO t1 VALUES (7, 2);
63 connection node_3;
64 connection node_1a;
65 SET SESSION wsrep_on = 0;
66 SET SESSION wsrep_on = 0;
67 SET GLOBAL wsrep_provider_options = 'dbug=';
68 SET GLOBAL wsrep_provider_options = 'dbug=d,process_primary_configuration';
69 SET GLOBAL wsrep_provider_options = 'signal=after_shift_to_joining';
70 connection node_1;
71 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
72 connection node_2;
73 connection node_3;
74 INSERT INTO t1 VALUES (8, 3);
75 connection node_2;
76 connection node_1;
77 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
78 connection node_2;
79 connection node_1a;
80 SET SESSION wsrep_on = 0;
81 SET SESSION wsrep_on = 0;
82 connection node_2;
83 INSERT INTO t1 VALUES (9, 2);
84 connection node_3;
85 connection node_1a;
86 SET GLOBAL wsrep_provider_options = 'signal=process_primary_configuration';
87 SET SESSION wsrep_on = 0;
88 SET SESSION wsrep_on = 0;
89 SET GLOBAL wsrep_provider_options = 'dbug=';
90 SET GLOBAL wsrep_provider_options = 'signal=process_primary_configuration';
91 SET SESSION wsrep_on = 0;
92 SET SESSION wsrep_on = 0;
93 SET GLOBAL wsrep_provider_options = 'dbug=';
94 SET GLOBAL wsrep_provider_options = 'signal=after_shift_to_joining';
95 connection node_1;
96 DROP TABLE t1;
97 call mtr.add_suppression("WSREP: Send action {.* STATE_REQUEST} returned -107 \\((Transport endpoint|Socket) is not connected\\)");
98 call mtr.add_suppression("WSREP: Rejecting JOIN message from .+: new State Transfer required\\.");
99 connection node_2;
100 call mtr.add_suppression("WSREP: Rejecting JOIN message from .+: new State Transfer required\\.");
101 connection node_3;
102 call mtr.add_suppression("WSREP: Rejecting JOIN message from .+: new State Transfer required\\.");