Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mysqlbinlog_gtid_strict_mode.result

raw
1 ###############################
2 # Test Setup
3 ###############################
4 RESET MASTER;
5 ####################################################
6 # Test Case Group 1
7 #
8 # Tests with --gtid-strict-mode should error and
9 # immediately quit with error on out of order GTIDs
10 ####################################################
11 #
12 # Test Case 1:
13 # Sequential sequence numbers results in no errors or warnings
14 SET @@session.gtid_domain_id= 0;
15 SET @@session.server_id= 1;
16 CREATE TABLE t1 (a int);
17 INSERT INTO t1 values (1);
18 INSERT INTO t1 values (2);
19 INSERT INTO t1 values (3);
20 FLUSH LOGS;
21 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --gtid-strict-mode 2> log_error_ > OUT_FILE
22 NOT FOUND /ERROR/ in out.err
23 DROP TABLE t1;
24 RESET MASTER;
25 #
26 # Test Case 2:
27 # A skipped sequence number results in no errors or warnings if all
28 # numbers are monotonic (i.e. gaps in sequence number are allowed
29 # provided they never decrease)
30 RESET MASTER;
31 SET @@session.gtid_domain_id= 0;
32 SET @@session.server_id= 1;
33 CREATE TABLE t1 (a int);
34 INSERT INTO t1 values (1);
35 INSERT INTO t1 values (2);
36 SET @@session.gtid_seq_no= 5;
37 INSERT INTO t1 values (3);
38 FLUSH LOGS;
39 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --gtid-strict-mode 2> log_error_ > OUT_FILE
40 NOT FOUND /ERROR/ in out.err
41 DROP TABLE t1;
42 RESET MASTER;
43 #
44 # Test Case 3:
45 # A sequence number lower than the last processed value results in a
46 # warning or error
47 CREATE TABLE t1 (a int);
48 RESET MASTER;
49 SET @@session.gtid_domain_id= 0;
50 SET @@session.server_id= 1;
51 SET @@session.gtid_seq_no= 2;
52 INSERT INTO t1 values (2);
53 SET @@session.gtid_seq_no= 1;
54 INSERT INTO t1 values (1);
55 FLUSH LOGS;
56 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --gtid-strict-mode 2> log_error_ > OUT_FILE
57 FOUND 1 /ERROR: Found out of order GTID/ in out.err
58 DROP TABLE t1;
59 RESET MASTER;
60 #
61 # Test Case 4:
62 # Skipping a GTID and later receiving it results in a warning or error
63 SET @@session.gtid_domain_id= 0;
64 SET @@session.server_id= 1;
65 CREATE TABLE t1 (a int);
66 SET @@session.gtid_seq_no= 3;
67 INSERT INTO t1 values (2);
68 SET @@session.gtid_seq_no= 2;
69 INSERT INTO t1 values (3);
70 SET @@session.gtid_seq_no= 4;
71 INSERT INTO t1 values (4);
72 INSERT INTO t1 values (5);
73 FLUSH LOGS;
74 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --gtid-strict-mode 2> log_error_ > OUT_FILE
75 FOUND 1 /ERROR: Found out of order GTID/ in out.err
76 DROP TABLE t1;
77 RESET MASTER;
78 #
79 # Test Case 5:
80 # Repeat sequence numbers produce a warning
81 SET @@session.gtid_domain_id= 0;
82 SET @@session.server_id= 1;
83 CREATE TABLE t1 (a int);
84 SET @@session.gtid_seq_no= 2;
85 INSERT INTO t1 values (2);
86 SET @@session.gtid_seq_no= 2;
87 INSERT INTO t1 values (2);
88 SET @@session.gtid_seq_no= 3;
89 INSERT INTO t1 values (3);
90 INSERT INTO t1 values (4);
91 FLUSH LOGS;
92 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --gtid-strict-mode 2> log_error_ > OUT_FILE
93 FOUND 1 /ERROR: Found out of order GTID/ in out.err
94 DROP TABLE t1;
95 RESET MASTER;
96 #
97 # Test Case 6:
98 # Warnings from different domains are all displayed
99 SET @@session.gtid_domain_id= 0;
100 SET @@session.server_id= 1;
101 CREATE TABLE t1 (a int);
102 SET @@session.gtid_seq_no= 3;
103 INSERT INTO t1 values (2);
104 SET @@session.gtid_seq_no= 2;
105 INSERT INTO t1 values (3);
106 SET @@session.gtid_seq_no= 4;
107 INSERT INTO t1 values (4);
108 SET @@session.gtid_domain_id= 1;
109 SET @@session.server_id= 2;
110 CREATE TABLE t2 (a int);
111 SET @@session.gtid_seq_no= 3;
112 INSERT INTO t2 values (2);
113 SET @@session.gtid_seq_no= 2;
114 INSERT INTO t2 values (3);
115 SET @@session.gtid_seq_no= 4;
116 INSERT INTO t2 values (4);
117 FLUSH LOGS;
118 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --gtid-strict-mode 2> log_error_ > OUT_FILE
119 FOUND 1 /ERROR: Found out of order GTID/ in out.err
120 DROP TABLE t1;
121 DROP TABLE t2;
122 RESET MASTER;
123 #
124 # Test Case 7:
125 # A decreasing seq_no before a start-position is ignored
126 SET @@session.gtid_domain_id= 0;
127 SET @@session.server_id= 1;
128 SET @@session.gtid_seq_no= 1;
129 CREATE TABLE t1 (a int);
130 SET @@session.gtid_seq_no= 3;
131 INSERT INTO t1 values (1);
132 SET @@session.gtid_seq_no= 2;
133 INSERT INTO t1 values (2);
134 SET @@session.gtid_seq_no= 4;
135 INSERT INTO t1 values (4);
136 INSERT INTO t1 values (3);
137 INSERT INTO t1 values (5);
138 FLUSH LOGS;
139 # GTID-based start-position
140 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-4 --gtid-strict-mode > log_error_ > OUT_FILE
141 NOT FOUND /ERROR/ in out.err
142 # Position-based start-position
143 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos --gtid-strict-mode 2> log_error_ > OUT_FILE
144 NOT FOUND /ERROR/ in out.err
145 DROP TABLE t1;
146 RESET MASTER;
147 #
148 # Test Case 8:
149 # A decreasing seq_no inside of a --start/--stop position window is
150 # displayed
151 SET @@session.gtid_domain_id= 0;
152 SET @@session.server_id= 1;
153 CREATE TABLE t1 (a int);
154 INSERT INTO t1 values (1);
155 INSERT INTO t1 values (2);
156 SET @@session.gtid_seq_no= 5;
157 INSERT INTO t1 values (4);
158 SET @@session.gtid_seq_no= 4;
159 INSERT INTO t1 values (3);
160 SET @@session.gtid_seq_no= 6;
161 INSERT INTO t1 values (5);
162 FLUSH LOGS;
163 # GTID-based window
164 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --stop-position=0-1-6 --gtid-strict-mode > log_error_ > OUT_FILE
165 FOUND 1 /ERROR: Found out of order GTID/ in out.err
166 # Position-based window
167 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos --stop-position=stop_binlog_pos --gtid-strict-mode 2> log_error_ > OUT_FILE
168 FOUND 1 /ERROR: Found out of order GTID/ in out.err
169 DROP TABLE t1;
170 RESET MASTER;
171 #
172 # Test Case 9:
173 # Error if --stop-position is not greater than or equal to
174 # --start-position
175 #
176 # Note: Error is only displayed in strict mode, -vvv has no effect here
177 FLUSH LOGS;
178 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2 --stop-position=0-1-1 --gtid-strict-mode 2> log_error_ > OUT_FILE
179 FOUND 1 /ERROR: Queried GTID range is invalid in strict mode/ in out.err
180 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2,1-2-1 --stop-position=0-1-1,1-2-2 --gtid-strict-mode 2> log_error_ > OUT_FILE
181 FOUND 1 /ERROR: Queried GTID range is invalid in strict mode/ in out.err
182 RESET MASTER;
183 #
184 # Test Case 10:
185 # Strict mode warnings should be independent of --offset option
186 # specification
187 SET @@session.gtid_domain_id= 0;
188 SET @@session.server_id= 1;
189 SET @@session.gtid_seq_no= 1;
190 CREATE TABLE t1 (a int);
191 SET @@session.gtid_seq_no= 3;
192 INSERT INTO t1 values (1);
193 SET @@session.gtid_seq_no= 2;
194 INSERT INTO t1 values (2);
195 SET @@session.gtid_seq_no= 4;
196 INSERT INTO t1 values (3);
197 INSERT INTO t1 values (4);
198 FLUSH LOGS;
199 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --offset=8 --gtid-strict-mode 2> log_error_ > OUT_FILE
200 FOUND 1 /ERROR: Found out of order GTID/ in out.err
201 DROP TABLE t1;
202 RESET MASTER;
203 #
204 # Test Case 11:
205 # Strict mode warnings should be independent of --start-timestamp
206 # option specification
207 set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22");
208 SET @@session.gtid_domain_id= 0;
209 SET @@session.server_id= 1;
210 SET @@session.gtid_seq_no= 1;
211 SET timestamp=@a;
212 CREATE TABLE t1 (a int);
213 SET @@session.gtid_seq_no= 3;
214 SET timestamp=@a+1;
215 INSERT INTO t1 values (1);
216 SET @@session.gtid_seq_no= 2;
217 SET timestamp=@a+2;
218 INSERT INTO t1 values (2);
219 SET @@session.gtid_seq_no= 4;
220 SET timestamp=@a+3;
221 INSERT INTO t1 values (3);
222 INSERT INTO t1 values (4);
223 FLUSH LOGS;
224 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --start-datetime="1970-01-21 15:32:24" --gtid-strict-mode 2> log_error_ > OUT_FILE
225 FOUND 1 /ERROR: Found out of order GTID/ in out.err
226 DROP TABLE t1;
227 RESET MASTER;
228 #
229 # Test Case 12:
230 # Specifying multiple binary logs with a log-position start should
231 # skip GTID state verification
232 RESET MASTER;
233 SET @@session.gtid_domain_id= 0;
234 SET @@session.server_id= 1;
235 CREATE TABLE t1 (a int);
236 INSERT INTO t1 values (1);
237 SET @@session.gtid_domain_id= 1;
238 SET @@session.server_id= 2;
239 CREATE TABLE t2 (a int);
240 INSERT INTO t2 values (1);
241 FLUSH LOGS;
242 INSERT INTO t2 values (2);
243 FLUSH LOGS;
244 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE2 --start-position=b2_start_pos --gtid-strict-mode 2> log_error_ > OUT_FILE
245 DROP TABLE t1;
246 DROP TABLE t2;
247 #
248 # Test Case 13:
249 # If multiple binary logs should be specified but a middle log is
250 # missing, we should detect that and warn when using -vvv
251 RESET MASTER;
252 SET @@session.gtid_domain_id= 0;
253 SET @@session.server_id= 1;
254 CREATE TABLE t1 (a int);
255 FLUSH LOGS;
256 INSERT INTO t1 values (1);
257 SET @@session.gtid_domain_id= 1;
258 SET @@session.server_id= 2;
259 CREATE TABLE t2 (a int);
260 FLUSH LOGS;
261 SET @@session.gtid_domain_id= 2;
262 SET @@session.server_id= 3;
263 CREATE TABLE t3 (a int);
264 FLUSH LOGS;
265 #
266 # GLLE from each log for state reference
267 show binlog events in 'master-bin.000001' limit 1,1;
268 Log_name Pos Event_type Server_id End_log_pos Info
269 master-bin.000001 # Gtid_list 1 # []
270 show binlog events in 'master-bin.000002' limit 1,1;
271 Log_name Pos Event_type Server_id End_log_pos Info
272 master-bin.000002 # Gtid_list 1 # [0-1-1]
273 show binlog events in 'master-bin.000003' limit 1,1;
274 Log_name Pos Event_type Server_id End_log_pos Info
275 master-bin.000003 # Gtid_list 1 # [0-1-2,1-2-1]
276 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE3 --gtid-strict-mode 2> log_error_ > OUT_FILE
277 # We should have two warnings about missing data from domains 0 and 1 if
278 # -vvv is specified
279 NOT FOUND /WARNING: Binary logs are missing data for domain 0[^\n]+the last seen event was/ in out.err
280 NOT FOUND /WARNING: Binary logs are missing data for domain 1[^\n]+neither the starting GTID position list nor any processed events/ in out.err
281 DROP TABLE t1;
282 DROP TABLE t2;
283 DROP TABLE t3;
284 RESET MASTER;
285 #
286 # Test Case 14:
287 # If a --stop-position GTID occurs before the first specified binlog's
288 # GLLE, error
289 RESET MASTER;
290 SET @@session.gtid_domain_id= 0;
291 SET @@session.server_id= 1;
292 CREATE TABLE t1 (a int);
293 INSERT INTO t1 values (1);
294 INSERT INTO t1 values (2);
295 FLUSH LOGS;
296 INSERT INTO t1 values (3);
297 FLUSH LOGS;
298 #
299 # GLLE from each log for state reference
300 show binlog events in 'master-bin.000001' limit 1,1;
301 Log_name Pos Event_type Server_id End_log_pos Info
302 master-bin.000001 # Gtid_list 1 # []
303 show binlog events in 'master-bin.000002' limit 1,1;
304 Log_name Pos Event_type Server_id End_log_pos Info
305 master-bin.000002 # Gtid_list 1 # [0-1-3]
306 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE2 --gtid-strict-mode --stop-position=0-1-2 2> log_error_ > OUT_FILE
307 FOUND 1 /ERROR: --stop-position GTID/ in out.err
308 DROP TABLE t1;
309 ####################################################
310 # Test Case Group 2
311 #
312 # Test cases with --skip-gtid-strict-mode -vvv
313 # should not quit early or with error when
314 # encountering out of order GTIDs; however should
315 # produce warnings after binlog processing
316 ####################################################
317 #
318 # Test Case 1:
319 # Sequential sequence numbers results in no errors or warnings
320 SET @@session.gtid_domain_id= 0;
321 SET @@session.server_id= 1;
322 CREATE TABLE t1 (a int);
323 INSERT INTO t1 values (1);
324 INSERT INTO t1 values (2);
325 INSERT INTO t1 values (3);
326 FLUSH LOGS;
327 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
328 NOT FOUND /WARNING/ in out.err
329 DROP TABLE t1;
330 RESET MASTER;
331 #
332 # Test Case 2:
333 # A skipped sequence number results in no errors or warnings if all
334 # numbers are monotonic (i.e. gaps in sequence number are allowed
335 # provided they never decrease)
336 RESET MASTER;
337 SET @@session.gtid_domain_id= 0;
338 SET @@session.server_id= 1;
339 CREATE TABLE t1 (a int);
340 INSERT INTO t1 values (1);
341 INSERT INTO t1 values (2);
342 SET @@session.gtid_seq_no= 5;
343 INSERT INTO t1 values (3);
344 FLUSH LOGS;
345 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
346 NOT FOUND /WARNING/ in out.err
347 DROP TABLE t1;
348 RESET MASTER;
349 #
350 # Test Case 3:
351 # A sequence number lower than the last processed value results in a
352 # warning or error
353 CREATE TABLE t1 (a int);
354 RESET MASTER;
355 SET @@session.gtid_domain_id= 0;
356 SET @@session.server_id= 1;
357 SET @@session.gtid_seq_no= 2;
358 INSERT INTO t1 values (2);
359 SET @@session.gtid_seq_no= 1;
360 INSERT INTO t1 values (1);
361 FLUSH LOGS;
362 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
363 FOUND 1 /WARNING: Found out of order GTID/ in out.err
364 DROP TABLE t1;
365 RESET MASTER;
366 #
367 # Test Case 4:
368 # Skipping a GTID and later receiving it results in a warning or error
369 SET @@session.gtid_domain_id= 0;
370 SET @@session.server_id= 1;
371 CREATE TABLE t1 (a int);
372 SET @@session.gtid_seq_no= 3;
373 INSERT INTO t1 values (2);
374 SET @@session.gtid_seq_no= 2;
375 INSERT INTO t1 values (3);
376 SET @@session.gtid_seq_no= 4;
377 INSERT INTO t1 values (4);
378 INSERT INTO t1 values (5);
379 FLUSH LOGS;
380 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
381 FOUND 1 /WARNING: Found out of order GTID/ in out.err
382 DROP TABLE t1;
383 RESET MASTER;
384 #
385 # Test Case 5:
386 # Repeat sequence numbers produce a warning
387 SET @@session.gtid_domain_id= 0;
388 SET @@session.server_id= 1;
389 CREATE TABLE t1 (a int);
390 SET @@session.gtid_seq_no= 2;
391 INSERT INTO t1 values (2);
392 SET @@session.gtid_seq_no= 2;
393 INSERT INTO t1 values (2);
394 SET @@session.gtid_seq_no= 3;
395 INSERT INTO t1 values (3);
396 INSERT INTO t1 values (4);
397 FLUSH LOGS;
398 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
399 FOUND 1 /WARNING: Found out of order GTID/ in out.err
400 DROP TABLE t1;
401 RESET MASTER;
402 #
403 # Test Case 6:
404 # Warnings from different domains are all displayed
405 SET @@session.gtid_domain_id= 0;
406 SET @@session.server_id= 1;
407 CREATE TABLE t1 (a int);
408 SET @@session.gtid_seq_no= 3;
409 INSERT INTO t1 values (2);
410 SET @@session.gtid_seq_no= 2;
411 INSERT INTO t1 values (3);
412 SET @@session.gtid_seq_no= 4;
413 INSERT INTO t1 values (4);
414 SET @@session.gtid_domain_id= 1;
415 SET @@session.server_id= 2;
416 CREATE TABLE t2 (a int);
417 SET @@session.gtid_seq_no= 3;
418 INSERT INTO t2 values (2);
419 SET @@session.gtid_seq_no= 2;
420 INSERT INTO t2 values (3);
421 SET @@session.gtid_seq_no= 4;
422 INSERT INTO t2 values (4);
423 FLUSH LOGS;
424 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
425 FOUND 2 /WARNING: Found out of order GTID/ in out.err
426 DROP TABLE t1;
427 DROP TABLE t2;
428 RESET MASTER;
429 #
430 # Test Case 7:
431 # A decreasing seq_no before a start-position is ignored
432 SET @@session.gtid_domain_id= 0;
433 SET @@session.server_id= 1;
434 SET @@session.gtid_seq_no= 1;
435 CREATE TABLE t1 (a int);
436 SET @@session.gtid_seq_no= 3;
437 INSERT INTO t1 values (1);
438 SET @@session.gtid_seq_no= 2;
439 INSERT INTO t1 values (2);
440 SET @@session.gtid_seq_no= 4;
441 INSERT INTO t1 values (4);
442 INSERT INTO t1 values (3);
443 INSERT INTO t1 values (5);
444 FLUSH LOGS;
445 # GTID-based start-position
446 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-4 --skip-gtid-strict-mode -vvv > log_error_ > OUT_FILE
447 NOT FOUND /WARNING/ in out.err
448 # Position-based start-position
449 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
450 NOT FOUND /WARNING/ in out.err
451 DROP TABLE t1;
452 RESET MASTER;
453 #
454 # Test Case 8:
455 # A decreasing seq_no inside of a --start/--stop position window is
456 # displayed
457 SET @@session.gtid_domain_id= 0;
458 SET @@session.server_id= 1;
459 CREATE TABLE t1 (a int);
460 INSERT INTO t1 values (1);
461 INSERT INTO t1 values (2);
462 SET @@session.gtid_seq_no= 5;
463 INSERT INTO t1 values (4);
464 SET @@session.gtid_seq_no= 4;
465 INSERT INTO t1 values (3);
466 SET @@session.gtid_seq_no= 6;
467 INSERT INTO t1 values (5);
468 FLUSH LOGS;
469 # GTID-based window
470 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --stop-position=0-1-6 --skip-gtid-strict-mode -vvv > log_error_ > OUT_FILE
471 FOUND 1 /WARNING: Found out of order GTID/ in out.err
472 # Position-based window
473 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos --stop-position=stop_binlog_pos --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
474 FOUND 1 /WARNING: Found out of order GTID/ in out.err
475 DROP TABLE t1;
476 RESET MASTER;
477 #
478 # Test Case 9:
479 # Error if --stop-position is not greater than or equal to
480 # --start-position
481 #
482 # Note: Error is only displayed in strict mode, -vvv has no effect here
483 FLUSH LOGS;
484 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2 --stop-position=0-1-1 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
485 NOT FOUND /ERROR: Queried GTID range is invalid in strict mode/ in out.err
486 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2,1-2-1 --stop-position=0-1-1,1-2-2 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
487 NOT FOUND /ERROR: Queried GTID range is invalid in strict mode/ in out.err
488 RESET MASTER;
489 #
490 # Test Case 10:
491 # Strict mode warnings should be independent of --offset option
492 # specification
493 SET @@session.gtid_domain_id= 0;
494 SET @@session.server_id= 1;
495 SET @@session.gtid_seq_no= 1;
496 CREATE TABLE t1 (a int);
497 SET @@session.gtid_seq_no= 3;
498 INSERT INTO t1 values (1);
499 SET @@session.gtid_seq_no= 2;
500 INSERT INTO t1 values (2);
501 SET @@session.gtid_seq_no= 4;
502 INSERT INTO t1 values (3);
503 INSERT INTO t1 values (4);
504 FLUSH LOGS;
505 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --offset=8 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
506 FOUND 1 /WARNING: Found out of order GTID/ in out.err
507 DROP TABLE t1;
508 RESET MASTER;
509 #
510 # Test Case 11:
511 # Strict mode warnings should be independent of --start-timestamp
512 # option specification
513 set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22");
514 SET @@session.gtid_domain_id= 0;
515 SET @@session.server_id= 1;
516 SET @@session.gtid_seq_no= 1;
517 SET timestamp=@a;
518 CREATE TABLE t1 (a int);
519 SET @@session.gtid_seq_no= 3;
520 SET timestamp=@a+1;
521 INSERT INTO t1 values (1);
522 SET @@session.gtid_seq_no= 2;
523 SET timestamp=@a+2;
524 INSERT INTO t1 values (2);
525 SET @@session.gtid_seq_no= 4;
526 SET timestamp=@a+3;
527 INSERT INTO t1 values (3);
528 INSERT INTO t1 values (4);
529 FLUSH LOGS;
530 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --start-datetime="1970-01-21 15:32:24" --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
531 FOUND 1 /WARNING: Found out of order GTID/ in out.err
532 DROP TABLE t1;
533 RESET MASTER;
534 #
535 # Test Case 12:
536 # Specifying multiple binary logs with a log-position start should
537 # skip GTID state verification
538 RESET MASTER;
539 SET @@session.gtid_domain_id= 0;
540 SET @@session.server_id= 1;
541 CREATE TABLE t1 (a int);
542 INSERT INTO t1 values (1);
543 SET @@session.gtid_domain_id= 1;
544 SET @@session.server_id= 2;
545 CREATE TABLE t2 (a int);
546 INSERT INTO t2 values (1);
547 FLUSH LOGS;
548 INSERT INTO t2 values (2);
549 FLUSH LOGS;
550 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE2 --start-position=b2_start_pos --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
551 DROP TABLE t1;
552 DROP TABLE t2;
553 #
554 # Test Case 13:
555 # If multiple binary logs should be specified but a middle log is
556 # missing, we should detect that and warn when using -vvv
557 RESET MASTER;
558 SET @@session.gtid_domain_id= 0;
559 SET @@session.server_id= 1;
560 CREATE TABLE t1 (a int);
561 FLUSH LOGS;
562 INSERT INTO t1 values (1);
563 SET @@session.gtid_domain_id= 1;
564 SET @@session.server_id= 2;
565 CREATE TABLE t2 (a int);
566 FLUSH LOGS;
567 SET @@session.gtid_domain_id= 2;
568 SET @@session.server_id= 3;
569 CREATE TABLE t3 (a int);
570 FLUSH LOGS;
571 #
572 # GLLE from each log for state reference
573 show binlog events in 'master-bin.000001' limit 1,1;
574 Log_name Pos Event_type Server_id End_log_pos Info
575 master-bin.000001 # Gtid_list 1 # []
576 show binlog events in 'master-bin.000002' limit 1,1;
577 Log_name Pos Event_type Server_id End_log_pos Info
578 master-bin.000002 # Gtid_list 1 # [0-1-1]
579 show binlog events in 'master-bin.000003' limit 1,1;
580 Log_name Pos Event_type Server_id End_log_pos Info
581 master-bin.000003 # Gtid_list 1 # [0-1-2,1-2-1]
582 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE3 --skip-gtid-strict-mode -vvv 2> log_error_ > OUT_FILE
583 # We should have two warnings about missing data from domains 0 and 1 if
584 # -vvv is specified
585 FOUND 1 /WARNING: Binary logs are missing data for domain 0[^\n]+the last seen event was/ in out.err
586 FOUND 1 /WARNING: Binary logs are missing data for domain 1[^\n]+neither the starting GTID position list nor any processed events/ in out.err
587 DROP TABLE t1;
588 DROP TABLE t2;
589 DROP TABLE t3;
590 RESET MASTER;
591 #
592 # Test Case 14:
593 # If a --stop-position GTID occurs before the first specified binlog's
594 # GLLE, error
595 RESET MASTER;
596 SET @@session.gtid_domain_id= 0;
597 SET @@session.server_id= 1;
598 CREATE TABLE t1 (a int);
599 INSERT INTO t1 values (1);
600 INSERT INTO t1 values (2);
601 FLUSH LOGS;
602 INSERT INTO t1 values (3);
603 FLUSH LOGS;
604 #
605 # GLLE from each log for state reference
606 show binlog events in 'master-bin.000001' limit 1,1;
607 Log_name Pos Event_type Server_id End_log_pos Info
608 master-bin.000001 # Gtid_list 1 # []
609 show binlog events in 'master-bin.000002' limit 1,1;
610 Log_name Pos Event_type Server_id End_log_pos Info
611 master-bin.000002 # Gtid_list 1 # [0-1-3]
612 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE2 --skip-gtid-strict-mode -vvv --stop-position=0-1-2 2> log_error_ > OUT_FILE
613 FOUND 1 /ERROR: --stop-position GTID/ in out.err
614 DROP TABLE t1;
615 ####################################################
616 # Test Case Group 3
617 #
618 # Run test cases with --skip-gtid-strict-mode should
619 # neither produce errors nor warnings when
620 # encountering out of order GTIDs
621 ####################################################
622 #
623 # Test Case 1:
624 # Sequential sequence numbers results in no errors or warnings
625 SET @@session.gtid_domain_id= 0;
626 SET @@session.server_id= 1;
627 CREATE TABLE t1 (a int);
628 INSERT INTO t1 values (1);
629 INSERT INTO t1 values (2);
630 INSERT INTO t1 values (3);
631 FLUSH LOGS;
632 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
633 NOT FOUND /(ERROR|WARNING)/ in out.err
634 DROP TABLE t1;
635 RESET MASTER;
636 #
637 # Test Case 2:
638 # A skipped sequence number results in no errors or warnings if all
639 # numbers are monotonic (i.e. gaps in sequence number are allowed
640 # provided they never decrease)
641 RESET MASTER;
642 SET @@session.gtid_domain_id= 0;
643 SET @@session.server_id= 1;
644 CREATE TABLE t1 (a int);
645 INSERT INTO t1 values (1);
646 INSERT INTO t1 values (2);
647 SET @@session.gtid_seq_no= 5;
648 INSERT INTO t1 values (3);
649 FLUSH LOGS;
650 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
651 NOT FOUND /(ERROR|WARNING)/ in out.err
652 DROP TABLE t1;
653 RESET MASTER;
654 #
655 # Test Case 3:
656 # A sequence number lower than the last processed value results in a
657 # warning or error
658 CREATE TABLE t1 (a int);
659 RESET MASTER;
660 SET @@session.gtid_domain_id= 0;
661 SET @@session.server_id= 1;
662 SET @@session.gtid_seq_no= 2;
663 INSERT INTO t1 values (2);
664 SET @@session.gtid_seq_no= 1;
665 INSERT INTO t1 values (1);
666 FLUSH LOGS;
667 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
668 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
669 DROP TABLE t1;
670 RESET MASTER;
671 #
672 # Test Case 4:
673 # Skipping a GTID and later receiving it results in a warning or error
674 SET @@session.gtid_domain_id= 0;
675 SET @@session.server_id= 1;
676 CREATE TABLE t1 (a int);
677 SET @@session.gtid_seq_no= 3;
678 INSERT INTO t1 values (2);
679 SET @@session.gtid_seq_no= 2;
680 INSERT INTO t1 values (3);
681 SET @@session.gtid_seq_no= 4;
682 INSERT INTO t1 values (4);
683 INSERT INTO t1 values (5);
684 FLUSH LOGS;
685 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
686 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
687 DROP TABLE t1;
688 RESET MASTER;
689 #
690 # Test Case 5:
691 # Repeat sequence numbers produce a warning
692 SET @@session.gtid_domain_id= 0;
693 SET @@session.server_id= 1;
694 CREATE TABLE t1 (a int);
695 SET @@session.gtid_seq_no= 2;
696 INSERT INTO t1 values (2);
697 SET @@session.gtid_seq_no= 2;
698 INSERT INTO t1 values (2);
699 SET @@session.gtid_seq_no= 3;
700 INSERT INTO t1 values (3);
701 INSERT INTO t1 values (4);
702 FLUSH LOGS;
703 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
704 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
705 DROP TABLE t1;
706 RESET MASTER;
707 #
708 # Test Case 6:
709 # Warnings from different domains are all displayed
710 SET @@session.gtid_domain_id= 0;
711 SET @@session.server_id= 1;
712 CREATE TABLE t1 (a int);
713 SET @@session.gtid_seq_no= 3;
714 INSERT INTO t1 values (2);
715 SET @@session.gtid_seq_no= 2;
716 INSERT INTO t1 values (3);
717 SET @@session.gtid_seq_no= 4;
718 INSERT INTO t1 values (4);
719 SET @@session.gtid_domain_id= 1;
720 SET @@session.server_id= 2;
721 CREATE TABLE t2 (a int);
722 SET @@session.gtid_seq_no= 3;
723 INSERT INTO t2 values (2);
724 SET @@session.gtid_seq_no= 2;
725 INSERT INTO t2 values (3);
726 SET @@session.gtid_seq_no= 4;
727 INSERT INTO t2 values (4);
728 FLUSH LOGS;
729 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
730 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
731 DROP TABLE t1;
732 DROP TABLE t2;
733 RESET MASTER;
734 #
735 # Test Case 7:
736 # A decreasing seq_no before a start-position is ignored
737 SET @@session.gtid_domain_id= 0;
738 SET @@session.server_id= 1;
739 SET @@session.gtid_seq_no= 1;
740 CREATE TABLE t1 (a int);
741 SET @@session.gtid_seq_no= 3;
742 INSERT INTO t1 values (1);
743 SET @@session.gtid_seq_no= 2;
744 INSERT INTO t1 values (2);
745 SET @@session.gtid_seq_no= 4;
746 INSERT INTO t1 values (4);
747 INSERT INTO t1 values (3);
748 INSERT INTO t1 values (5);
749 FLUSH LOGS;
750 # GTID-based start-position
751 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-4 --skip-gtid-strict-mode > log_error_ > OUT_FILE
752 NOT FOUND /(ERROR|WARNING)/ in out.err
753 # Position-based start-position
754 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
755 NOT FOUND /(ERROR|WARNING)/ in out.err
756 DROP TABLE t1;
757 RESET MASTER;
758 #
759 # Test Case 8:
760 # A decreasing seq_no inside of a --start/--stop position window is
761 # displayed
762 SET @@session.gtid_domain_id= 0;
763 SET @@session.server_id= 1;
764 CREATE TABLE t1 (a int);
765 INSERT INTO t1 values (1);
766 INSERT INTO t1 values (2);
767 SET @@session.gtid_seq_no= 5;
768 INSERT INTO t1 values (4);
769 SET @@session.gtid_seq_no= 4;
770 INSERT INTO t1 values (3);
771 SET @@session.gtid_seq_no= 6;
772 INSERT INTO t1 values (5);
773 FLUSH LOGS;
774 # GTID-based window
775 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --stop-position=0-1-6 --skip-gtid-strict-mode > log_error_ > OUT_FILE
776 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
777 # Position-based window
778 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos --stop-position=stop_binlog_pos --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
779 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
780 DROP TABLE t1;
781 RESET MASTER;
782 #
783 # Test Case 9:
784 # Error if --stop-position is not greater than or equal to
785 # --start-position
786 #
787 # Note: Error is only displayed in strict mode, -vvv has no effect here
788 FLUSH LOGS;
789 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2 --stop-position=0-1-1 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
790 NOT FOUND /ERROR: Queried GTID range is invalid in strict mode/ in out.err
791 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2,1-2-1 --stop-position=0-1-1,1-2-2 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
792 NOT FOUND /ERROR: Queried GTID range is invalid in strict mode/ in out.err
793 RESET MASTER;
794 #
795 # Test Case 10:
796 # Strict mode warnings should be independent of --offset option
797 # specification
798 SET @@session.gtid_domain_id= 0;
799 SET @@session.server_id= 1;
800 SET @@session.gtid_seq_no= 1;
801 CREATE TABLE t1 (a int);
802 SET @@session.gtid_seq_no= 3;
803 INSERT INTO t1 values (1);
804 SET @@session.gtid_seq_no= 2;
805 INSERT INTO t1 values (2);
806 SET @@session.gtid_seq_no= 4;
807 INSERT INTO t1 values (3);
808 INSERT INTO t1 values (4);
809 FLUSH LOGS;
810 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --offset=8 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
811 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
812 DROP TABLE t1;
813 RESET MASTER;
814 #
815 # Test Case 11:
816 # Strict mode warnings should be independent of --start-timestamp
817 # option specification
818 set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22");
819 SET @@session.gtid_domain_id= 0;
820 SET @@session.server_id= 1;
821 SET @@session.gtid_seq_no= 1;
822 SET timestamp=@a;
823 CREATE TABLE t1 (a int);
824 SET @@session.gtid_seq_no= 3;
825 SET timestamp=@a+1;
826 INSERT INTO t1 values (1);
827 SET @@session.gtid_seq_no= 2;
828 SET timestamp=@a+2;
829 INSERT INTO t1 values (2);
830 SET @@session.gtid_seq_no= 4;
831 SET timestamp=@a+3;
832 INSERT INTO t1 values (3);
833 INSERT INTO t1 values (4);
834 FLUSH LOGS;
835 # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --start-datetime="1970-01-21 15:32:24" --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
836 NOT FOUND /(ERROR|WARNING): Found out of order GTID/ in out.err
837 DROP TABLE t1;
838 RESET MASTER;
839 #
840 # Test Case 12:
841 # Specifying multiple binary logs with a log-position start should
842 # skip GTID state verification
843 RESET MASTER;
844 SET @@session.gtid_domain_id= 0;
845 SET @@session.server_id= 1;
846 CREATE TABLE t1 (a int);
847 INSERT INTO t1 values (1);
848 SET @@session.gtid_domain_id= 1;
849 SET @@session.server_id= 2;
850 CREATE TABLE t2 (a int);
851 INSERT INTO t2 values (1);
852 FLUSH LOGS;
853 INSERT INTO t2 values (2);
854 FLUSH LOGS;
855 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE2 --start-position=b2_start_pos --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
856 DROP TABLE t1;
857 DROP TABLE t2;
858 #
859 # Test Case 13:
860 # If multiple binary logs should be specified but a middle log is
861 # missing, we should detect that and warn when using -vvv
862 RESET MASTER;
863 SET @@session.gtid_domain_id= 0;
864 SET @@session.server_id= 1;
865 CREATE TABLE t1 (a int);
866 FLUSH LOGS;
867 INSERT INTO t1 values (1);
868 SET @@session.gtid_domain_id= 1;
869 SET @@session.server_id= 2;
870 CREATE TABLE t2 (a int);
871 FLUSH LOGS;
872 SET @@session.gtid_domain_id= 2;
873 SET @@session.server_id= 3;
874 CREATE TABLE t3 (a int);
875 FLUSH LOGS;
876 #
877 # GLLE from each log for state reference
878 show binlog events in 'master-bin.000001' limit 1,1;
879 Log_name Pos Event_type Server_id End_log_pos Info
880 master-bin.000001 # Gtid_list 1 # []
881 show binlog events in 'master-bin.000002' limit 1,1;
882 Log_name Pos Event_type Server_id End_log_pos Info
883 master-bin.000002 # Gtid_list 1 # [0-1-1]
884 show binlog events in 'master-bin.000003' limit 1,1;
885 Log_name Pos Event_type Server_id End_log_pos Info
886 master-bin.000003 # Gtid_list 1 # [0-1-2,1-2-1]
887 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE3 --skip-gtid-strict-mode 2> log_error_ > OUT_FILE
888 # We should have two warnings about missing data from domains 0 and 1 if
889 # -vvv is specified
890 NOT FOUND /WARNING: Binary logs are missing data for domain 0[^\n]+the last seen event was/ in out.err
891 NOT FOUND /WARNING: Binary logs are missing data for domain 1[^\n]+neither the starting GTID position list nor any processed events/ in out.err
892 DROP TABLE t1;
893 DROP TABLE t2;
894 DROP TABLE t3;
895 RESET MASTER;
896 #
897 # Test Case 14:
898 # If a --stop-position GTID occurs before the first specified binlog's
899 # GLLE, error
900 RESET MASTER;
901 SET @@session.gtid_domain_id= 0;
902 SET @@session.server_id= 1;
903 CREATE TABLE t1 (a int);
904 INSERT INTO t1 values (1);
905 INSERT INTO t1 values (2);
906 FLUSH LOGS;
907 INSERT INTO t1 values (3);
908 FLUSH LOGS;
909 #
910 # GLLE from each log for state reference
911 show binlog events in 'master-bin.000001' limit 1,1;
912 Log_name Pos Event_type Server_id End_log_pos Info
913 master-bin.000001 # Gtid_list 1 # []
914 show binlog events in 'master-bin.000002' limit 1,1;
915 Log_name Pos Event_type Server_id End_log_pos Info
916 master-bin.000002 # Gtid_list 1 # [0-1-3]
917 # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE2 --skip-gtid-strict-mode --stop-position=0-1-2 2> log_error_ > OUT_FILE
918 FOUND 1 /ERROR: --stop-position GTID/ in out.err
919 DROP TABLE t1;
920 ##############################
921 # Cleanup
922 ##############################
923 SET @@global.gtid_domain_id= 0;
924 SET @@global.server_id= 1;
925 End of the tests