Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gtid_reconnect.result

raw
1 include/rpl_init.inc [topology=1->2]
2 connection server_1;
3 CREATE TABLE t1 (a INT);
4 FLUSH LOGS;
5 connection server_2;
6 connection server_1;
7 SET gtid_domain_id=10;
8 INSERT INTO t1 VALUES (1);
9 INSERT INTO t1 VALUES (2);
10 SET gtid_seq_no=100;
11 INSERT INTO t1 VALUES (3);
12 INSERT INTO t1 VALUES (4);
13 INSERT INTO t1 VALUES (5);
14 connection server_2;
15 include/stop_slave.inc
16 SELECT * FROM t1 ORDER BY a;
17 a
18 1
19 2
20 3
21 4
22 5
23 connection server_1;
24 include/kill_binlog_dump_threads.inc
25 INSERT INTO t1 VALUES (10);
26 SET @old_debug= @@GLOBAL.debug_dbug;
27 SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output";
28 SET GLOBAL debug_dbug="+d,gtid_force_reconnect_at_10_1_100";
29 connection server_2;
30 include/start_slave.inc
31 SELECT * FROM t1 ORDER BY a;
32 a
33 1
34 2
35 3
36 4
37 5
38 10
39 include/stop_slave.inc
40 TRUNCATE t1;
41 RESET MASTER;
42 SET GLOBAL gtid_slave_pos= "";
43 connection server_1;
44 SET GLOBAL debug_dbug= @old_debug;
45 TRUNCATE t1;
46 RESET MASTER;
47 SET gtid_domain_id=10;
48 SET gtid_seq_no=50;
49 INSERT INTO t1 VALUES (1);
50 SET gtid_domain_id=11;
51 INSERT INTO t1 VALUES (11);
52 SET gtid_domain_id=10;
53 SET gtid_seq_no=100;
54 INSERT INTO t1 VALUES (2);
55 SET gtid_domain_id=11;
56 INSERT INTO t1 VALUES (12);
57 SET gtid_domain_id=10;
58 INSERT INTO t1 VALUES (3);
59 SET gtid_domain_id=11;
60 SET gtid_seq_no=200;
61 INSERT INTO t1 VALUES (13);
62 connection server_2;
63 START SLAVE UNTIL master_gtid_pos="10-1-50,11-1-200";
64 include/wait_for_slave_to_stop.inc
65 SELECT * FROM t1 ORDER BY a;
66 a
67 1
68 11
69 12
70 13
71 connection server_1;
72 include/kill_binlog_dump_threads.inc
73 INSERT INTO t1 VALUES (20);
74 SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output";
75 SET GLOBAL debug_dbug="+d,gtid_force_reconnect_at_10_1_100";
76 connection server_2;
77 include/start_slave.inc
78 SELECT * FROM t1 ORDER BY a;
79 a
80 1
81 2
82 3
83 11
84 12
85 13
86 20
87 include/stop_slave.inc
88 TRUNCATE t1;
89 RESET MASTER;
90 SET GLOBAL gtid_slave_pos= "";
91 connection server_1;
92 SET GLOBAL debug_dbug= @old_debug;
93 TRUNCATE t1;
94 RESET MASTER;
95 include/kill_binlog_dump_threads.inc
96 SET gtid_domain_id= 9;
97 SET gtid_seq_no= 50;
98 INSERT INTO t1 VALUES (1);
99 SET gtid_domain_id= 10;
100 INSERT INTO t1 VALUES (11);
101 SET gtid_domain_id= 9;
102 INSERT INTO t1 VALUES (2);
103 SET gtid_domain_id= 10;
104 SET gtid_seq_no= 100;
105 INSERT INTO t1 VALUES (12);
106 SET gtid_domain_id= 9;
107 INSERT INTO t1 VALUES (3);
108 SET gtid_domain_id= 10;
109 SET gtid_seq_no= 200;
110 INSERT INTO t1 VALUES (13);
111 SET gtid_domain_id= 10;
112 SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output";
113 SET GLOBAL debug_dbug="+d,gtid_force_reconnect_at_10_1_100";
114 connection server_2;
115 START SLAVE UNTIL master_gtid_pos="9-1-50,10-1-200";
116 include/wait_for_slave_to_stop.inc
117 SELECT * FROM t1 ORDER BY a;
118 a
119 1
120 11
121 12
122 13
123 connection server_1;
124 SET GLOBAL debug_dbug= @old_debug;
125 INSERT INTO t1 VALUES (20);
126 connection server_2;
127 include/start_slave.inc
128 SELECT * FROM t1 ORDER BY a;
129 a
130 1
131 2
132 3
133 11
134 12
135 13
136 20
137 *** Test when slave IO thread needs to reconnect in the middle of an event group. ***
138 connection server_2;
139 include/stop_slave.inc
140 TRUNCATE t1;
141 RESET MASTER;
142 SET GLOBAL gtid_slave_pos= "";
143 connection server_1;
144 SET GLOBAL debug_dbug= @old_debug;
145 TRUNCATE t1;
146 RESET MASTER;
147 include/kill_binlog_dump_threads.inc
148 SET GLOBAL debug_dbug="+d,dummy_disable_default_dbug_output";
149 SET GLOBAL debug_dbug="+d,binlog_force_reconnect_after_22_events";
150 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
151 INSERT INTO t2 VALUES (1);
152 BEGIN;
153 INSERT INTO t2 VALUES (10);
154 INSERT INTO t2 VALUES (11);
155 COMMIT;
156 BEGIN;
157 INSERT INTO t2 VALUES (20);
158 INSERT INTO t2 VALUES (21);
159 INSERT INTO t2 VALUES (22);
160 INSERT INTO t2 VALUES (23);
161 INSERT INTO t2 VALUES (24);
162 INSERT INTO t2 VALUES (25);
163 INSERT INTO t2 VALUES (26);
164 INSERT INTO t2 VALUES (27);
165 INSERT INTO t2 VALUES (28);
166 INSERT INTO t2 VALUES (29);
167 COMMIT;
168 connection server_2;
169 include/start_slave.inc
170 SELECT * FROM t2 ORDER BY a;
171 a
172 1
173 10
174 11
175 20
176 21
177 22
178 23
179 24
180 25
181 26
182 27
183 28
184 29
185 connection server_1;
186 SET GLOBAL debug_dbug= @old_debug;
187 connection server_1;
188 DROP TABLE t1, t2;
189 include/rpl_end.inc