Debian Codegraph @

mysql-test/suite/binlog/include/mysqlbinlog_gtid_strict_mode.inc

raw
1 #
2 # This file runs test cases for using --gtid-strict-mode with mariadb-binlog to
3 # ensure warnings are properly displayed
4 #
5 # param $is_strict_mode boolean (0 for false, 1 for true) to enable or
6 # disable strict mode for GTID processing
7 #
8
9 --let MYSQLD_DATADIR=`select @@datadir`
10 --let OUT_FILE=$MYSQLTEST_VARDIR/tmp/binlog.out
11
12 if ($is_strict_mode == 0)
13 {
14 --let BINLOG_STRICT_MODE_PARAM=--skip-gtid-strict-mode
15 }
16 if ($is_strict_mode == 1)
17 {
18 --let BINLOG_STRICT_MODE_PARAM=--gtid-strict-mode
19 }
20 if ($is_verbose == 1)
21 {
22 --let BINLOG_STRICT_MODE_PARAM=$BINLOG_STRICT_MODE_PARAM -vvv
23 }
24
25 --let $log_error_ = $MYSQLTEST_VARDIR/tmp/out.err
26 --let SEARCH_FILE=$log_error_
27
28 --echo #
29 --echo # Test Case 1:
30 --echo # Sequential sequence numbers results in no errors or warnings
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 INSERT INTO t1 values (3);
37 FLUSH LOGS;
38 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
39 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
40 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX
41 --source include/search_pattern_in_file.inc
42 --remove_file $log_error_
43 DROP TABLE t1;
44 RESET MASTER;
45
46 --echo #
47 --echo # Test Case 2:
48 --echo # A skipped sequence number results in no errors or warnings if all
49 --echo # numbers are monotonic (i.e. gaps in sequence number are allowed
50 --echo # provided they never decrease)
51 RESET MASTER;
52 SET @@session.gtid_domain_id= 0;
53 SET @@session.server_id= 1;
54 CREATE TABLE t1 (a int);
55 INSERT INTO t1 values (1);
56 INSERT INTO t1 values (2);
57 SET @@session.gtid_seq_no= 5;
58 INSERT INTO t1 values (3);
59 FLUSH LOGS;
60 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
61 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
62 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX
63 --source include/search_pattern_in_file.inc
64 --remove_file $log_error_
65 DROP TABLE t1;
66 RESET MASTER;
67
68 --echo #
69 --echo # Test Case 3:
70 --echo # A sequence number lower than the last processed value results in a
71 --echo # warning or error
72 CREATE TABLE t1 (a int);
73 RESET MASTER;
74 SET @@session.gtid_domain_id= 0;
75 SET @@session.server_id= 1;
76 SET @@session.gtid_seq_no= 2;
77 INSERT INTO t1 values (2);
78 SET @@session.gtid_seq_no= 1;
79 INSERT INTO t1 values (1);
80 FLUSH LOGS;
81 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
82 --error $is_strict_mode
83 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
84 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
85 --source include/search_pattern_in_file.inc
86 --remove_file $log_error_
87 DROP TABLE t1;
88 RESET MASTER;
89
90 --echo #
91 --echo # Test Case 4:
92 --echo # Skipping a GTID and later receiving it results in a warning or error
93 SET @@session.gtid_domain_id= 0;
94 SET @@session.server_id= 1;
95 CREATE TABLE t1 (a int);
96 SET @@session.gtid_seq_no= 3;
97 INSERT INTO t1 values (2);
98 SET @@session.gtid_seq_no= 2;
99 INSERT INTO t1 values (3);
100 SET @@session.gtid_seq_no= 4;
101 INSERT INTO t1 values (4);
102 INSERT INTO t1 values (5);
103 FLUSH LOGS;
104 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
105 --error $is_strict_mode
106 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
107 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
108 --source include/search_pattern_in_file.inc
109 --remove_file $log_error_
110 DROP TABLE t1;
111 RESET MASTER;
112
113 --echo #
114 --echo # Test Case 5:
115 --echo # Repeat sequence numbers produce a warning
116 SET @@session.gtid_domain_id= 0;
117 SET @@session.server_id= 1;
118 CREATE TABLE t1 (a int);
119 SET @@session.gtid_seq_no= 2;
120 INSERT INTO t1 values (2);
121 SET @@session.gtid_seq_no= 2;
122 INSERT INTO t1 values (2);
123 SET @@session.gtid_seq_no= 3;
124 INSERT INTO t1 values (3);
125 INSERT INTO t1 values (4);
126 FLUSH LOGS;
127 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
128 --error $is_strict_mode
129 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
130 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
131 --source include/search_pattern_in_file.inc
132 --remove_file $log_error_
133 DROP TABLE t1;
134 RESET MASTER;
135
136 --echo #
137 --echo # Test Case 6:
138 --echo # Warnings from different domains are all displayed
139 SET @@session.gtid_domain_id= 0;
140 SET @@session.server_id= 1;
141 CREATE TABLE t1 (a int);
142 SET @@session.gtid_seq_no= 3;
143 INSERT INTO t1 values (2);
144 SET @@session.gtid_seq_no= 2;
145 INSERT INTO t1 values (3);
146 SET @@session.gtid_seq_no= 4;
147 INSERT INTO t1 values (4);
148 SET @@session.gtid_domain_id= 1;
149 SET @@session.server_id= 2;
150 CREATE TABLE t2 (a int);
151 SET @@session.gtid_seq_no= 3;
152 INSERT INTO t2 values (2);
153 SET @@session.gtid_seq_no= 2;
154 INSERT INTO t2 values (3);
155 SET @@session.gtid_seq_no= 4;
156 INSERT INTO t2 values (4);
157 FLUSH LOGS;
158 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
159 --error $is_strict_mode
160 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
161 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
162 --source include/search_pattern_in_file.inc
163 --remove_file $log_error_
164 DROP TABLE t1;
165 DROP TABLE t2;
166 RESET MASTER;
167
168 --echo #
169 --echo # Test Case 7:
170 --echo # A decreasing seq_no before a start-position is ignored
171 SET @@session.gtid_domain_id= 0;
172 SET @@session.server_id= 1;
173 SET @@session.gtid_seq_no= 1;
174 CREATE TABLE t1 (a int);
175 SET @@session.gtid_seq_no= 3;
176 INSERT INTO t1 values (1);
177 SET @@session.gtid_seq_no= 2;
178 INSERT INTO t1 values (2);
179 --let $start_binlog_pos= query_get_value(SHOW MASTER STATUS,Position, 1)
180 SET @@session.gtid_seq_no= 4;
181 INSERT INTO t1 values (4);
182 INSERT INTO t1 values (3);
183 INSERT INTO t1 values (5);
184 FLUSH LOGS;
185
186 --echo # GTID-based start-position
187 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-4 $BINLOG_STRICT_MODE_PARAM > log_error_ > OUT_FILE
188 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-4 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
189 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX
190 --source include/search_pattern_in_file.inc
191
192 --echo # Position-based start-position
193 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
194 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=$start_binlog_pos $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
195 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX
196 --source include/search_pattern_in_file.inc
197
198 --remove_file $log_error_
199 DROP TABLE t1;
200 RESET MASTER;
201
202 --echo #
203 --echo # Test Case 8:
204 --echo # A decreasing seq_no inside of a --start/--stop position window is
205 --echo # displayed
206 SET @@session.gtid_domain_id= 0;
207 SET @@session.server_id= 1;
208 CREATE TABLE t1 (a int);
209 --let $start_binlog_pos= query_get_value(SHOW MASTER STATUS,Position, 1)
210 INSERT INTO t1 values (1);
211 INSERT INTO t1 values (2);
212 SET @@session.gtid_seq_no= 5;
213 INSERT INTO t1 values (4);
214 SET @@session.gtid_seq_no= 4;
215 INSERT INTO t1 values (3);
216 SET @@session.gtid_seq_no= 6;
217 INSERT INTO t1 values (5);
218 --let $stop_binlog_pos= query_get_value(SHOW MASTER STATUS,Position, 1)
219 FLUSH LOGS;
220
221 --echo # GTID-based window
222 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --stop-position=0-1-6 $BINLOG_STRICT_MODE_PARAM > log_error_ > OUT_FILE
223 --error $is_strict_mode
224 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --stop-position=0-1-6 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
225 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
226 --source include/search_pattern_in_file.inc
227
228 --echo # Position-based window
229 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=start_binlog_pos --stop-position=stop_binlog_pos $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
230 --error $is_strict_mode
231 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=$start_binlog_pos --stop-position=$stop_binlog_pos $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
232 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
233 --source include/search_pattern_in_file.inc
234
235 --remove_file $log_error_
236 DROP TABLE t1;
237 RESET MASTER;
238
239 --echo #
240 --echo # Test Case 9:
241 --echo # Error if --stop-position is not greater than or equal to
242 --echo # --start-position
243 --echo #
244 --echo # Note: Error is only displayed in strict mode, -vvv has no effect here
245 FLUSH LOGS;
246 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2 --stop-position=0-1-1 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
247 --error $is_strict_mode
248 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2 --stop-position=0-1-1 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
249 --let SEARCH_PATTERN=ERROR: Queried GTID range is invalid in strict mode
250 --source include/search_pattern_in_file.inc
251
252 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2,1-2-1 --stop-position=0-1-1,1-2-2 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
253 --error $is_strict_mode
254 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-2,1-2-1 --stop-position=0-1-1,1-2-2 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
255 --let SEARCH_PATTERN=ERROR: Queried GTID range is invalid in strict mode
256 --source include/search_pattern_in_file.inc
257 RESET MASTER;
258
259 --echo #
260 --echo # Test Case 10:
261 --echo # Strict mode warnings should be independent of --offset option
262 --echo # specification
263 SET @@session.gtid_domain_id= 0;
264 SET @@session.server_id= 1;
265 SET @@session.gtid_seq_no= 1;
266 CREATE TABLE t1 (a int);
267 SET @@session.gtid_seq_no= 3;
268 INSERT INTO t1 values (1);
269 SET @@session.gtid_seq_no= 2;
270 INSERT INTO t1 values (2);
271 SET @@session.gtid_seq_no= 4;
272 INSERT INTO t1 values (3);
273 INSERT INTO t1 values (4);
274 FLUSH LOGS;
275 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --offset=8 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
276 --error $is_strict_mode
277 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --offset=8 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
278 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
279 --source include/search_pattern_in_file.inc
280 --remove_file $log_error_
281 DROP TABLE t1;
282 RESET MASTER;
283
284 --echo #
285 --echo # Test Case 11:
286 --echo # Strict mode warnings should be independent of --start-timestamp
287 --echo # option specification
288 set @a=UNIX_TIMESTAMP("1970-01-21 15:32:22");
289 SET @@session.gtid_domain_id= 0;
290 SET @@session.server_id= 1;
291 SET @@session.gtid_seq_no= 1;
292 SET timestamp=@a;
293 CREATE TABLE t1 (a int);
294 SET @@session.gtid_seq_no= 3;
295 SET timestamp=@a+1;
296 INSERT INTO t1 values (1);
297 SET @@session.gtid_seq_no= 2;
298 SET timestamp=@a+2;
299 INSERT INTO t1 values (2);
300 SET @@session.gtid_seq_no= 4;
301 SET timestamp=@a+3;
302 INSERT INTO t1 values (3);
303 INSERT INTO t1 values (4);
304 FLUSH LOGS;
305 --echo # MYSQL_BINLOG MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --start-datetime="1970-01-21 15:32:24" $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
306 --error $is_strict_mode
307 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000001 --start-position=0-1-1 --start-datetime="1970-01-21 15:32:24" $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
308 --let SEARCH_PATTERN=$DEFAULT_ERROR_PREFIX: Found out of order GTID
309 --source include/search_pattern_in_file.inc
310 --remove_file $log_error_
311 DROP TABLE t1;
312 RESET MASTER;
313
314 --echo #
315 --echo # Test Case 12:
316 --echo # Specifying multiple binary logs with a log-position start should
317 --echo # skip GTID state verification
318 RESET MASTER;
319 SET @@session.gtid_domain_id= 0;
320 SET @@session.server_id= 1;
321 CREATE TABLE t1 (a int);
322 INSERT INTO t1 values (1);
323 --let $b2_start_pos= query_get_value(SHOW MASTER STATUS,Position, 1)
324 SET @@session.gtid_domain_id= 1;
325 SET @@session.server_id= 2;
326 CREATE TABLE t2 (a int);
327 INSERT INTO t2 values (1);
328 FLUSH LOGS;
329 INSERT INTO t2 values (2);
330 FLUSH LOGS;
331 --let BINLOG_FILE1= query_get_value(SHOW BINARY LOGS, Log_name, 1)
332 # Skip file 2 as input
333 --let BINLOG_FILE2= query_get_value(SHOW BINARY LOGS, Log_name, 2)
334 --echo # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE2 --start-position=b2_start_pos $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
335 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/$BINLOG_FILE1 $MYSQLD_DATADIR/$BINLOG_FILE2 --start-position=$b2_start_pos $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
336 DROP TABLE t1;
337 DROP TABLE t2;
338
339
340 --echo #
341 --echo # Test Case 13:
342 --echo # If multiple binary logs should be specified but a middle log is
343 --echo # missing, we should detect that and warn when using -vvv
344
345 RESET MASTER;
346 SET @@session.gtid_domain_id= 0;
347 SET @@session.server_id= 1;
348 CREATE TABLE t1 (a int);
349 FLUSH LOGS;
350 INSERT INTO t1 values (1);
351 --let $b2_start_pos= query_get_value(SHOW MASTER STATUS,Position, 1)
352 SET @@session.gtid_domain_id= 1;
353 SET @@session.server_id= 2;
354 CREATE TABLE t2 (a int);
355 FLUSH LOGS;
356 SET @@session.gtid_domain_id= 2;
357 SET @@session.server_id= 3;
358 CREATE TABLE t3 (a int);
359 FLUSH LOGS;
360
361 --echo #
362 --echo # GLLE from each log for state reference
363 --let $binlog_file= query_get_value(SHOW BINARY LOGS, Log_name, 1)
364 --source include/show_gtid_list.inc
365 --let $binlog_file=
366 --let $binlog_file= query_get_value(SHOW BINARY LOGS, Log_name, 2)
367 --source include/show_gtid_list.inc
368 --let $binlog_file=
369 --let $binlog_file= query_get_value(SHOW BINARY LOGS, Log_name, 3)
370 --source include/show_gtid_list.inc
371 --let $binlog_file=
372
373 --let BINLOG_FILE1= query_get_value(SHOW BINARY LOGS, Log_name, 1)
374 # Skip file 2 as input
375 --let BINLOG_FILE3= query_get_value(SHOW BINARY LOGS, Log_name, 3)
376 --echo # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE1 MYSQLD_DATADIR/BINLOG_FILE3 $BINLOG_STRICT_MODE_PARAM 2> log_error_ > OUT_FILE
377 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/$BINLOG_FILE1 $MYSQLD_DATADIR/$BINLOG_FILE3 $BINLOG_STRICT_MODE_PARAM 2> $log_error_ > $OUT_FILE
378 --echo # We should have two warnings about missing data from domains 0 and 1 if
379 --echo # -vvv is specified
380 --let SEARCH_FILE=$log_error_
381 --let SEARCH_PATTERN=WARNING: Binary logs are missing data for domain 0[^\n]+the last seen event was
382 --source include/search_pattern_in_file.inc
383 --let SEARCH_PATTERN=WARNING: Binary logs are missing data for domain 1[^\n]+neither the starting GTID position list nor any processed events
384 --source include/search_pattern_in_file.inc
385 --remove_file $log_error_
386 DROP TABLE t1;
387 DROP TABLE t2;
388 DROP TABLE t3;
389 RESET MASTER;
390
391 --echo #
392 --echo # Test Case 14:
393 --echo # If a --stop-position GTID occurs before the first specified binlog's
394 --echo # GLLE, error
395 RESET MASTER;
396 SET @@session.gtid_domain_id= 0;
397 SET @@session.server_id= 1;
398 CREATE TABLE t1 (a int);
399 INSERT INTO t1 values (1);
400 INSERT INTO t1 values (2);
401 FLUSH LOGS;
402 INSERT INTO t1 values (3);
403 FLUSH LOGS;
404
405 --echo #
406 --echo # GLLE from each log for state reference
407 --let $binlog_file= query_get_value(SHOW BINARY LOGS, Log_name, 1)
408 --source include/show_gtid_list.inc
409 --let $binlog_file=
410 --let $binlog_file= query_get_value(SHOW BINARY LOGS, Log_name, 2)
411 --source include/show_gtid_list.inc
412 --let $binlog_file=
413 --echo # MYSQL_BINLOG MYSQLD_DATADIR/BINLOG_FILE2 $BINLOG_STRICT_MODE_PARAM --stop-position=0-1-2 2> log_error_ > OUT_FILE
414 --error 1
415 --exec $MYSQL_BINLOG $MYSQLD_DATADIR/$BINLOG_FILE2 $BINLOG_STRICT_MODE_PARAM --stop-position=0-1-2 2> $log_error_ > $OUT_FILE
416 --let SEARCH_PATTERN=ERROR: --stop-position GTID
417 --source include/search_pattern_in_file.inc
418 --remove_file $log_error_
419 DROP TABLE t1;
420
421 --remove_file $OUT_FILE