Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_mts_until.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 CREATE DATABASE db1;
7 CREATE DATABASE db2;
8 CREATE DATABASE db3;
9 CREATE TABLE db1.t1(c1 INT PRIMARY KEY, c2 CHAR(20));
10 CREATE TABLE db2.t1(c1 INT PRIMARY KEY, c2 CHAR(20));
11 CREATE TABLE db3.t1(c1 INT PRIMARY KEY, c2 CHAR(20));
12 CREATE VIEW db1.v1 AS SELECT * FROM db1.t1 WHERE c1 <= 4;
13 include/sync_slave_sql_with_master.inc
14 include/stop_slave_sql.inc
15 SET @saved_replica_parallel_type = @@GLOBAL.replica_parallel_type;
16 Warnings:
17 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
18 SET @saved_replica_parallel_workers = @@GLOBAL.replica_parallel_workers;
19 SET @saved_replica_preserve_commit_order = @@GLOBAL.replica_preserve_commit_order;
20 SET @saved_innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout;
21 SET @saved_relay_log_purge = @@GLOBAL.relay_log_purge;
22 SET GLOBAL innodb_lock_wait_timeout = 1000;
23 SET GLOBAL relay_log_purge = FALSE;
24 SET GLOBAL replica_parallel_type = "LOGICAL_CLOCK";
25 Warnings:
26 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
27 SET GLOBAL replica_parallel_workers = 4;
28 SET GLOBAL replica_preserve_commit_order=0;
29 [connection slave]
30 include/stop_slave_sql.inc
31 Warnings:
32 Note 3084 Replication thread(s) for channel '' are already stopped.
33 [connection master]
34 SET debug="d,set_commit_parent_100";
35 INSERT INTO db1.t1 VALUES(1, 'SOURCE_POS');
36 INSERT INTO db1.t1 VALUES(2, 'SOURCE_POS');
37 INSERT INTO db2.t1 VALUES(1, 'SOURCE_POS');
38 INSERT INTO db2.t1 VALUES(2, 'SOURCE_POS');
39 INSERT INTO db3.t1 VALUES(1, 'SOURCE_POS');
40 INSERT INTO db3.t1 VALUES(2, 'SOURCE_POS');
41 FLUSH BINARY LOGS;
42 INSERT INTO db1.t1 VALUES(3, 'SOURCE_POS');
43 INSERT INTO db1.t1 VALUES(4, 'SOURCE_POS');
44 INSERT INTO db2.t1 VALUES(3, 'SOURCE_POS');
45 INSERT INTO db2.t1 VALUES(4, 'SOURCE_POS');
46 INSERT INTO db3.t1 VALUES(3, 'SOURCE_POS');
47 INSERT INTO db3.t1 VALUES(4, 'SOURCE_POS');
48 INSERT INTO db1.t1 VALUES(5, 'SOURCE_POS');
49 INSERT INTO db1.t1 VALUES(6, 'SOURCE_POS');
50 INSERT INTO db2.t1 VALUES(5, 'SOURCE_POS');
51 INSERT INTO db2.t1 VALUES(6, 'SOURCE_POS');
52 INSERT INTO db3.t1 VALUES(5, 'SOURCE_POS');
53 INSERT INTO db3.t1 VALUES(6, 'SOURCE_POS');
54 include/save_master_pos.inc
55 [connection server_2]
56 BEGIN;
57 INSERT INTO db1.t1 VALUES(4, "block a worker");
58 [connection slave]
59 START SLAVE SQL_THREAD UNTIL SOURCE_LOG_FILE="SOURCE_LOG_FILE", SOURCE_LOG_POS=SOURCE_LOG_POS;
60 Warnings:
61 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
62 [connection server_2]
63 ROLLBACK;
64 include/wait_for_slave_sql_to_stop.inc
65 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
66 START SLAVE SQL_THREAD UNTIL SAME_UNTIO_OPTION;
67 Warnings:
68 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
69 include/wait_for_slave_sql_to_stop.inc
70 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
71 include/start_slave_sql.inc
72 [connection master]
73 TRUNCATE db1.t1;
74 TRUNCATE db2.t1;
75 TRUNCATE db3.t1;
76 include/sync_slave_sql_with_master.inc
77 [connection slave]
78 include/stop_slave_sql.inc
79 [connection master]
80 SET debug="d,set_commit_parent_100";
81 INSERT INTO db1.t1 VALUES(1, 'RELAY_POS');
82 INSERT INTO db1.t1 VALUES(2, 'RELAY_POS');
83 INSERT INTO db2.t1 VALUES(1, 'RELAY_POS');
84 INSERT INTO db2.t1 VALUES(2, 'RELAY_POS');
85 INSERT INTO db3.t1 VALUES(1, 'RELAY_POS');
86 INSERT INTO db3.t1 VALUES(2, 'RELAY_POS');
87 FLUSH BINARY LOGS;
88 INSERT INTO db1.t1 VALUES(3, 'RELAY_POS');
89 INSERT INTO db1.t1 VALUES(4, 'RELAY_POS');
90 INSERT INTO db2.t1 VALUES(3, 'RELAY_POS');
91 INSERT INTO db2.t1 VALUES(4, 'RELAY_POS');
92 INSERT INTO db3.t1 VALUES(3, 'RELAY_POS');
93 INSERT INTO db3.t1 VALUES(4, 'RELAY_POS');
94 include/sync_slave_io_with_master.inc
95 include/include/rpl_get_end_of_relay_log.inc
96 [connection master]
97 INSERT INTO db1.t1 VALUES(5, 'RELAY_POS');
98 INSERT INTO db1.t1 VALUES(6, 'RELAY_POS');
99 INSERT INTO db2.t1 VALUES(5, 'RELAY_POS');
100 INSERT INTO db2.t1 VALUES(6, 'RELAY_POS');
101 INSERT INTO db3.t1 VALUES(5, 'RELAY_POS');
102 INSERT INTO db3.t1 VALUES(6, 'RELAY_POS');
103 include/save_master_pos.inc
104 [connection server_2]
105 BEGIN;
106 INSERT INTO db1.t1 VALUES(4, "block a worker");
107 [connection slave]
108 START SLAVE SQL_THREAD UNTIL RELAY_LOG_FILE="RELAY_LOG_FILE", RELAY_LOG_POS=RELAY_LOG_POS;
109 Warnings:
110 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
111 [connection server_2]
112 ROLLBACK;
113 include/wait_for_slave_sql_to_stop.inc
114 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
115 START SLAVE SQL_THREAD UNTIL SAME_UNTIO_OPTION;
116 Warnings:
117 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
118 include/wait_for_slave_sql_to_stop.inc
119 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
120 include/start_slave_sql.inc
121 [connection master]
122 TRUNCATE db1.t1;
123 TRUNCATE db2.t1;
124 TRUNCATE db3.t1;
125 include/sync_slave_sql_with_master.inc
126 [connection slave]
127 include/stop_slave_sql.inc
128 [connection master]
129 SET debug="d,set_commit_parent_100";
130 INSERT INTO db1.t1 VALUES(1, 'BEFORE_GTIDS');
131 INSERT INTO db1.t1 VALUES(2, 'BEFORE_GTIDS');
132 INSERT INTO db2.t1 VALUES(1, 'BEFORE_GTIDS');
133 INSERT INTO db2.t1 VALUES(2, 'BEFORE_GTIDS');
134 INSERT INTO db3.t1 VALUES(1, 'BEFORE_GTIDS');
135 INSERT INTO db3.t1 VALUES(2, 'BEFORE_GTIDS');
136 FLUSH BINARY LOGS;
137 INSERT INTO db1.t1 VALUES(3, 'BEFORE_GTIDS');
138 INSERT INTO db1.t1 VALUES(4, 'BEFORE_GTIDS');
139 INSERT INTO db2.t1 VALUES(3, 'BEFORE_GTIDS');
140 INSERT INTO db2.t1 VALUES(4, 'BEFORE_GTIDS');
141 INSERT INTO db3.t1 VALUES(3, 'BEFORE_GTIDS');
142 INSERT INTO db3.t1 VALUES(4, 'BEFORE_GTIDS');
143 SET @gtids_should_applied = @@GLOBAL.gtid_executed;
144 INSERT INTO db1.t1 VALUES(5, 'BEFORE_GTIDS');
145 INSERT INTO db1.t1 VALUES(6, 'BEFORE_GTIDS');
146 INSERT INTO db2.t1 VALUES(5, 'BEFORE_GTIDS');
147 INSERT INTO db2.t1 VALUES(6, 'BEFORE_GTIDS');
148 INSERT INTO db3.t1 VALUES(5, 'BEFORE_GTIDS');
149 INSERT INTO db3.t1 VALUES(6, 'BEFORE_GTIDS');
150 include/save_master_pos.inc
151 [connection server_2]
152 BEGIN;
153 INSERT INTO db1.t1 VALUES(4, "block a worker");
154 [connection slave]
155 START SLAVE SQL_THREAD UNTIL SQL_BEFORE_GTIDS="GTIDS";
156 Warnings:
157 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
158 [connection server_2]
159 ROLLBACK;
160 include/wait_for_slave_sql_to_stop.inc
161 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
162 START SLAVE SQL_THREAD UNTIL SAME_UNTIO_OPTION;
163 Warnings:
164 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
165 include/wait_for_slave_sql_to_stop.inc
166 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
167 include/start_slave_sql.inc
168 [connection master]
169 TRUNCATE db1.t1;
170 TRUNCATE db2.t1;
171 TRUNCATE db3.t1;
172 include/sync_slave_sql_with_master.inc
173 include/stop_slave_sql.inc
174 SET GLOBAL replica_parallel_type = "DATABASE";
175 Warnings:
176 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
177 SET GLOBAL replica_parallel_workers = 4;
178 SET GLOBAL innodb_lock_wait_timeout = 1000;
179 SET GLOBAL relay_log_purge = FALSE;
180 [connection slave]
181 include/stop_slave_sql.inc
182 Warnings:
183 Note 3084 Replication thread(s) for channel '' are already stopped.
184 [connection master]
185 SET debug="d,set_commit_parent_100";
186 INSERT INTO db1.t1 VALUES(1, 'SOURCE_POS');
187 INSERT INTO db1.t1 VALUES(2, 'SOURCE_POS');
188 INSERT INTO db2.t1 VALUES(1, 'SOURCE_POS');
189 INSERT INTO db2.t1 VALUES(2, 'SOURCE_POS');
190 INSERT INTO db3.t1 VALUES(1, 'SOURCE_POS');
191 INSERT INTO db3.t1 VALUES(2, 'SOURCE_POS');
192 FLUSH BINARY LOGS;
193 INSERT INTO db1.t1 VALUES(3, 'SOURCE_POS');
194 INSERT INTO db1.t1 VALUES(4, 'SOURCE_POS');
195 INSERT INTO db2.t1 VALUES(3, 'SOURCE_POS');
196 INSERT INTO db2.t1 VALUES(4, 'SOURCE_POS');
197 INSERT INTO db3.t1 VALUES(3, 'SOURCE_POS');
198 INSERT INTO db3.t1 VALUES(4, 'SOURCE_POS');
199 INSERT INTO db1.t1 VALUES(5, 'SOURCE_POS');
200 INSERT INTO db1.t1 VALUES(6, 'SOURCE_POS');
201 INSERT INTO db2.t1 VALUES(5, 'SOURCE_POS');
202 INSERT INTO db2.t1 VALUES(6, 'SOURCE_POS');
203 INSERT INTO db3.t1 VALUES(5, 'SOURCE_POS');
204 INSERT INTO db3.t1 VALUES(6, 'SOURCE_POS');
205 include/save_master_pos.inc
206 [connection server_2]
207 BEGIN;
208 INSERT INTO db1.t1 VALUES(4, "block a worker");
209 [connection slave]
210 START SLAVE SQL_THREAD UNTIL SOURCE_LOG_FILE="SOURCE_LOG_FILE", SOURCE_LOG_POS=SOURCE_LOG_POS;
211 Warnings:
212 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
213 [connection server_2]
214 ROLLBACK;
215 include/wait_for_slave_sql_to_stop.inc
216 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
217 START SLAVE SQL_THREAD UNTIL SAME_UNTIO_OPTION;
218 Warnings:
219 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
220 include/wait_for_slave_sql_to_stop.inc
221 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
222 include/start_slave_sql.inc
223 [connection master]
224 TRUNCATE db1.t1;
225 TRUNCATE db2.t1;
226 TRUNCATE db3.t1;
227 include/sync_slave_sql_with_master.inc
228 [connection slave]
229 include/stop_slave_sql.inc
230 [connection master]
231 SET debug="d,set_commit_parent_100";
232 INSERT INTO db1.t1 VALUES(1, 'RELAY_POS');
233 INSERT INTO db1.t1 VALUES(2, 'RELAY_POS');
234 INSERT INTO db2.t1 VALUES(1, 'RELAY_POS');
235 INSERT INTO db2.t1 VALUES(2, 'RELAY_POS');
236 INSERT INTO db3.t1 VALUES(1, 'RELAY_POS');
237 INSERT INTO db3.t1 VALUES(2, 'RELAY_POS');
238 FLUSH BINARY LOGS;
239 INSERT INTO db1.t1 VALUES(3, 'RELAY_POS');
240 INSERT INTO db1.t1 VALUES(4, 'RELAY_POS');
241 INSERT INTO db2.t1 VALUES(3, 'RELAY_POS');
242 INSERT INTO db2.t1 VALUES(4, 'RELAY_POS');
243 INSERT INTO db3.t1 VALUES(3, 'RELAY_POS');
244 INSERT INTO db3.t1 VALUES(4, 'RELAY_POS');
245 include/sync_slave_io_with_master.inc
246 include/include/rpl_get_end_of_relay_log.inc
247 [connection master]
248 INSERT INTO db1.t1 VALUES(5, 'RELAY_POS');
249 INSERT INTO db1.t1 VALUES(6, 'RELAY_POS');
250 INSERT INTO db2.t1 VALUES(5, 'RELAY_POS');
251 INSERT INTO db2.t1 VALUES(6, 'RELAY_POS');
252 INSERT INTO db3.t1 VALUES(5, 'RELAY_POS');
253 INSERT INTO db3.t1 VALUES(6, 'RELAY_POS');
254 include/save_master_pos.inc
255 [connection server_2]
256 BEGIN;
257 INSERT INTO db1.t1 VALUES(4, "block a worker");
258 [connection slave]
259 START SLAVE SQL_THREAD UNTIL RELAY_LOG_FILE="RELAY_LOG_FILE", RELAY_LOG_POS=RELAY_LOG_POS;
260 Warnings:
261 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
262 [connection server_2]
263 ROLLBACK;
264 include/wait_for_slave_sql_to_stop.inc
265 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
266 START SLAVE SQL_THREAD UNTIL SAME_UNTIO_OPTION;
267 Warnings:
268 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
269 include/wait_for_slave_sql_to_stop.inc
270 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
271 include/start_slave_sql.inc
272 [connection master]
273 TRUNCATE db1.t1;
274 TRUNCATE db2.t1;
275 TRUNCATE db3.t1;
276 include/sync_slave_sql_with_master.inc
277 [connection slave]
278 include/stop_slave_sql.inc
279 [connection master]
280 SET debug="d,set_commit_parent_100";
281 INSERT INTO db1.t1 VALUES(1, 'BEFORE_GTIDS');
282 INSERT INTO db1.t1 VALUES(2, 'BEFORE_GTIDS');
283 INSERT INTO db2.t1 VALUES(1, 'BEFORE_GTIDS');
284 INSERT INTO db2.t1 VALUES(2, 'BEFORE_GTIDS');
285 INSERT INTO db3.t1 VALUES(1, 'BEFORE_GTIDS');
286 INSERT INTO db3.t1 VALUES(2, 'BEFORE_GTIDS');
287 FLUSH BINARY LOGS;
288 INSERT INTO db1.t1 VALUES(3, 'BEFORE_GTIDS');
289 INSERT INTO db1.t1 VALUES(4, 'BEFORE_GTIDS');
290 INSERT INTO db2.t1 VALUES(3, 'BEFORE_GTIDS');
291 INSERT INTO db2.t1 VALUES(4, 'BEFORE_GTIDS');
292 INSERT INTO db3.t1 VALUES(3, 'BEFORE_GTIDS');
293 INSERT INTO db3.t1 VALUES(4, 'BEFORE_GTIDS');
294 SET @gtids_should_applied = @@GLOBAL.gtid_executed;
295 INSERT INTO db1.t1 VALUES(5, 'BEFORE_GTIDS');
296 INSERT INTO db1.t1 VALUES(6, 'BEFORE_GTIDS');
297 INSERT INTO db2.t1 VALUES(5, 'BEFORE_GTIDS');
298 INSERT INTO db2.t1 VALUES(6, 'BEFORE_GTIDS');
299 INSERT INTO db3.t1 VALUES(5, 'BEFORE_GTIDS');
300 INSERT INTO db3.t1 VALUES(6, 'BEFORE_GTIDS');
301 include/save_master_pos.inc
302 [connection server_2]
303 BEGIN;
304 INSERT INTO db1.t1 VALUES(4, "block a worker");
305 [connection slave]
306 START SLAVE SQL_THREAD UNTIL SQL_BEFORE_GTIDS="GTIDS";
307 Warnings:
308 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
309 [connection server_2]
310 ROLLBACK;
311 include/wait_for_slave_sql_to_stop.inc
312 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
313 START SLAVE SQL_THREAD UNTIL SAME_UNTIO_OPTION;
314 Warnings:
315 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
316 include/wait_for_slave_sql_to_stop.inc
317 include/diff_tables.inc [master:db1.v1, slave:db1.t1, slave:db2.t1, slave:db3.t1]
318 include/start_slave_sql.inc
319 [connection master]
320 TRUNCATE db1.t1;
321 TRUNCATE db2.t1;
322 TRUNCATE db3.t1;
323 include/sync_slave_sql_with_master.inc
324 [connection master]
325 DROP DATABASE db1;
326 DROP DATABASE db2;
327 DROP DATABASE db3;
328 include/sync_slave_sql_with_master.inc
329 include/stop_slave_sql.inc
330 SET GLOBAL replica_parallel_type = @saved_replica_parallel_type;
331 Warnings:
332 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
333 SET GLOBAL replica_parallel_workers = @saved_replica_parallel_workers;
334 SET GLOBAL replica_preserve_commit_order= @saved_replica_preserve_commit_order;
335 SET GLOBAL innodb_lock_wait_timeout = @saved_innodb_lock_wait_timeout;
336 SET GLOBAL relay_log_purge = @saved_relay_log_purge;
337 include/rpl_end.inc