Debian Codegraph @

mysql-test/suite/rpl/r/rpl_binlog_transaction_dependency_tracking.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 #### INITIALIZE ####
7 call mtr.add_suppression("Transaction is tagged with inconsistent logical timestamps");
8 call mtr.add_suppression("Cannot execute the current event group in the parallel mode.");
9 include/stop_slave.inc
10 SET @save_replica_parallel_type = @@GLOBAL.replica_parallel_type;
11 Warnings:
12 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
13 SET @save_replica_parallel_workers = @@GLOBAL.replica_parallel_workers;
14 SET @save_replica_transaction_retries = @@GLOBAL.replica_transaction_retries;
15 SET GLOBAL replica_parallel_type = LOGICAL_CLOCK;
16 Warnings:
17 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
18 SET GLOBAL replica_parallel_workers = 3;
19 SET GLOBAL replica_transaction_retries = 0;
20 SET @save_binlog_transaction_dependency_tracking = @@GLOBAL.binlog_transaction_dependency_tracking;
21 Warnings:
22 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
23 SET @save_binlog_transaction_dependency_history_size = @@GLOBAL.binlog_transaction_dependency_history_size;
24 SET GLOBAL binlog_transaction_dependency_tracking = COMMIT_ORDER;
25 Warnings:
26 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
27 CREATE TABLE tests (`id` INT NOT NULL, `description` VARCHAR(50), `results` VARCHAR(100), PRIMARY KEY(`id`));
28 INSERT INTO `tests` (`id`, `description`, `results`) VALUES
29 (1, 'Writeset', '0 1;1 2;1 3;1 4;3 5;3 6;4 7;7 8;6 9;9 10'),
30 (2, 'Writeset+DDL', '0 1;1 2;1 3;1 4;4 5;5 6;6 7;7 8;4 9;7 10;10 11;9 12;12 13'),
31 (3, 'Writeset+rotation', '0 1;0 2;1 3;3 4;2 5;5 6'),
32 (4, 'Writeset+history', '0 1;1 2;1 3;1 4;4 5;4 6;6 7;7 8;6 9;9 10'),
33 (5, 'Writeset_session', '0 1;1 2;1 3;2 4;3 5;3 6;5 7;7 8;7 9;9 10'),
34 (6, 'Writeset_session+DDL', '0 1;1 2;1 3;2 4;4 5;5 6;6 7;7 8;4 9;8 10;10 11;10 12;12 13'),
35 (7, 'Writeset_session+rotation', '0 1;0 2;1 3;3 4;3 5;5 6'),
36 (8, 'Writeset_session+history', '0 1;1 2;1 3;2 4;4 5;4 6;6 7;7 8;7 9;9 10'),
37 (9, 'Commit_order', '0 1;1 2;1 3;3 4;4 5;4 6;6 7;7 8;7 9;9 10'),
38 (10, 'Commit_order+DDL', '0 1;1 2;1 3;3 4;4 5;5 6;6 7;7 8;4 9;9 10;10 11;10 12;12 13'),
39 (11, 'Commit_order+rotation', '0 1;0 2;2 3;3 4;3 5;5 6'),
40 (12, 'Commit_order+history', '0 1;1 2;1 3;3 4;4 5;4 6;6 7;7 8;7 9;9 10');
41 FLUSH LOGS;
42 #### TEST ####
43 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
44 Warnings:
45 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
46 ######## 1. WRITESET ########
47 #### STEP 1.1 TEST Writeset ####
48 SET GLOBAL binlog_transaction_dependency_history_size=25000;
49 SELECT @@binlog_transaction_dependency_tracking,
50 @@binlog_transaction_dependency_history_size;
51 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
52 WRITESET 25000
53 Warnings:
54 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
55 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
56 PRIMARY KEY (`id`)) ENGINE=InnoDB;
57 Warnings:
58 Warning 1681 Integer display width is deprecated and will be removed in a future release.
59 Warning 1681 Integer display width is deprecated and will be removed in a future release.
60 #TRX2 (session A, independent)
61 BEGIN;
62 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
63 #TRX1 (session B, independent)
64 BEGIN;
65 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
66 COMMIT;
67 finish TRX2 after TRX1
68 COMMIT;
69 #TRX3 (session B, no data dependency, depends on TRX1 (session))
70 BEGIN;
71 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
72 COMMIT;
73 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
74 BEGIN;
75 INSERT INTO t1(id, val) VALUES (8, 1);
76 UPDATE t1 SET val=val+1 WHERE id=1;
77 UPDATE t1 SET val=val+1 WHERE id=4;
78 #TRX4 (session C, depends on TRX2 (data))
79 BEGIN;
80 UPDATE t1 SET val=val+1 WHERE id=3;
81 INSERT INTO t1(id, val) VALUES (9, 1);
82 COMMIT;
83 finish TRX5 after TRX4
84 COMMIT;
85 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
86 BEGIN;
87 DELETE FROM t1 WHERE id=6;
88 COMMIT;
89 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
90 BEGIN;
91 UPDATE t1 SET val=val+1 WHERE id=4;
92 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
93 BEGIN;
94 UPDATE t1 SET val=val+1 WHERE id=5;
95 INSERT INTO t1(id, val) VALUES (6, 0);
96 COMMIT;
97 finish TRX8 after TRX7
98 COMMIT;
99 Drop table and flush logs to force binlog to rotate
100 DROP TABLE t1;
101 Processing binlog master-bin.000002
102 FLUSH LOGS;
103 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;1 4;3 5;3 6;4 7;7 8;6 9;9 10]
104 #### STEP 1.2 TEST Writeset+DDL ####
105 SET GLOBAL binlog_transaction_dependency_history_size=25000;
106 SELECT @@binlog_transaction_dependency_tracking,
107 @@binlog_transaction_dependency_history_size;
108 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
109 WRITESET 25000
110 Warnings:
111 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
112 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
113 PRIMARY KEY (`id`)) ENGINE=InnoDB;
114 Warnings:
115 Warning 1681 Integer display width is deprecated and will be removed in a future release.
116 Warning 1681 Integer display width is deprecated and will be removed in a future release.
117 #TRX2 (session A, independent)
118 BEGIN;
119 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
120 #TRX1 (session B, independent)
121 BEGIN;
122 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
123 COMMIT;
124 finish TRX2 after TRX1
125 COMMIT;
126 #TRX3 (session B, no data dependency, depends on TRX1 (session))
127 BEGIN;
128 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
129 COMMIT;
130 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
131 BEGIN;
132 INSERT INTO t1(id, val) VALUES (8, 1);
133 UPDATE t1 SET val=val+1 WHERE id=1;
134 UPDATE t1 SET val=val+1 WHERE id=4;
135 Inserted a DDL after TRX5 and check that they run in parallel due to commit_order
136 CREATE TABLE `t2` (`id` int(11) NOT NULL, `val` int(11) NOT NULL) ENGINE=InnoDB;
137 Warnings:
138 Warning 1681 Integer display width is deprecated and will be removed in a future release.
139 Warning 1681 Integer display width is deprecated and will be removed in a future release.
140 ALTER TABLE t2 ADD COLUMN b INT;
141 DROP TABLE `t2`;
142 #TRX4 (session C, depends on TRX2 (data))
143 BEGIN;
144 UPDATE t1 SET val=val+1 WHERE id=3;
145 INSERT INTO t1(id, val) VALUES (9, 1);
146 COMMIT;
147 finish TRX5 after TRX4
148 COMMIT;
149 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
150 BEGIN;
151 DELETE FROM t1 WHERE id=6;
152 COMMIT;
153 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
154 BEGIN;
155 UPDATE t1 SET val=val+1 WHERE id=4;
156 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
157 BEGIN;
158 UPDATE t1 SET val=val+1 WHERE id=5;
159 INSERT INTO t1(id, val) VALUES (6, 0);
160 COMMIT;
161 finish TRX8 after TRX7
162 COMMIT;
163 Drop table and flush logs to force binlog to rotate
164 DROP TABLE t1;
165 Processing binlog master-bin.000003
166 FLUSH LOGS;
167 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;1 4;4 5;5 6;6 7;7 8;4 9;7 10;10 11;9 12;12 13]
168 #### STEP 1.3 TEST Writeset+rotation ####
169 SET GLOBAL binlog_transaction_dependency_history_size=25000;
170 SELECT @@binlog_transaction_dependency_tracking,
171 @@binlog_transaction_dependency_history_size;
172 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
173 WRITESET 25000
174 Warnings:
175 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
176 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
177 PRIMARY KEY (`id`)) ENGINE=InnoDB;
178 Warnings:
179 Warning 1681 Integer display width is deprecated and will be removed in a future release.
180 Warning 1681 Integer display width is deprecated and will be removed in a future release.
181 #TRX2 (session A, independent)
182 BEGIN;
183 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
184 #TRX1 (session B, independent)
185 BEGIN;
186 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
187 COMMIT;
188 finish TRX2 after TRX1
189 COMMIT;
190 #TRX3 (session B, no data dependency, depends on TRX1 (session))
191 BEGIN;
192 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
193 COMMIT;
194 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
195 BEGIN;
196 INSERT INTO t1(id, val) VALUES (8, 1);
197 UPDATE t1 SET val=val+1 WHERE id=1;
198 UPDATE t1 SET val=val+1 WHERE id=4;
199 Flushing logs in the middle of the set
200 FLUSH LOGS;
201 #TRX4 (session C, depends on TRX2 (data))
202 BEGIN;
203 UPDATE t1 SET val=val+1 WHERE id=3;
204 INSERT INTO t1(id, val) VALUES (9, 1);
205 COMMIT;
206 finish TRX5 after TRX4
207 COMMIT;
208 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
209 BEGIN;
210 DELETE FROM t1 WHERE id=6;
211 COMMIT;
212 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
213 BEGIN;
214 UPDATE t1 SET val=val+1 WHERE id=4;
215 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
216 BEGIN;
217 UPDATE t1 SET val=val+1 WHERE id=5;
218 INSERT INTO t1(id, val) VALUES (6, 0);
219 COMMIT;
220 finish TRX8 after TRX7
221 COMMIT;
222 Drop table and flush logs to force binlog to rotate
223 DROP TABLE t1;
224 Processing binlog master-bin.000005
225 FLUSH LOGS;
226 include/include/assert_logical_timestamps.inc [0 1;0 2;1 3;3 4;2 5;5 6]
227 #### STEP 1.4 TEST Writeset+history ####
228 SET GLOBAL binlog_transaction_dependency_history_size=25000;
229 History size reduced to 5 to test when it becomes full
230 SET GLOBAL binlog_transaction_dependency_history_size=5;
231 SELECT @@binlog_transaction_dependency_tracking,
232 @@binlog_transaction_dependency_history_size;
233 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
234 WRITESET 5
235 Warnings:
236 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
237 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
238 PRIMARY KEY (`id`)) ENGINE=InnoDB;
239 Warnings:
240 Warning 1681 Integer display width is deprecated and will be removed in a future release.
241 Warning 1681 Integer display width is deprecated and will be removed in a future release.
242 #TRX2 (session A, independent)
243 BEGIN;
244 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
245 #TRX1 (session B, independent)
246 BEGIN;
247 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
248 COMMIT;
249 finish TRX2 after TRX1
250 COMMIT;
251 #TRX3 (session B, no data dependency, depends on TRX1 (session))
252 BEGIN;
253 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
254 COMMIT;
255 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
256 BEGIN;
257 INSERT INTO t1(id, val) VALUES (8, 1);
258 UPDATE t1 SET val=val+1 WHERE id=1;
259 UPDATE t1 SET val=val+1 WHERE id=4;
260 #TRX4 (session C, depends on TRX2 (data))
261 BEGIN;
262 UPDATE t1 SET val=val+1 WHERE id=3;
263 INSERT INTO t1(id, val) VALUES (9, 1);
264 COMMIT;
265 finish TRX5 after TRX4
266 COMMIT;
267 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
268 BEGIN;
269 DELETE FROM t1 WHERE id=6;
270 COMMIT;
271 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
272 BEGIN;
273 UPDATE t1 SET val=val+1 WHERE id=4;
274 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
275 BEGIN;
276 UPDATE t1 SET val=val+1 WHERE id=5;
277 INSERT INTO t1(id, val) VALUES (6, 0);
278 COMMIT;
279 finish TRX8 after TRX7
280 COMMIT;
281 Drop table and flush logs to force binlog to rotate
282 DROP TABLE t1;
283 Processing binlog master-bin.000006
284 FLUSH LOGS;
285 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;1 4;4 5;4 6;6 7;7 8;6 9;9 10]
286 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET_SESSION;
287 Warnings:
288 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
289 ######## 2. WRITESET_SESSION ########
290 #### STEP 2.1 TEST Writeset_session ####
291 SET GLOBAL binlog_transaction_dependency_history_size=25000;
292 SELECT @@binlog_transaction_dependency_tracking,
293 @@binlog_transaction_dependency_history_size;
294 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
295 WRITESET_SESSION 25000
296 Warnings:
297 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
298 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
299 PRIMARY KEY (`id`)) ENGINE=InnoDB;
300 Warnings:
301 Warning 1681 Integer display width is deprecated and will be removed in a future release.
302 Warning 1681 Integer display width is deprecated and will be removed in a future release.
303 #TRX2 (session A, independent)
304 BEGIN;
305 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
306 #TRX1 (session B, independent)
307 BEGIN;
308 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
309 COMMIT;
310 finish TRX2 after TRX1
311 COMMIT;
312 #TRX3 (session B, no data dependency, depends on TRX1 (session))
313 BEGIN;
314 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
315 COMMIT;
316 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
317 BEGIN;
318 INSERT INTO t1(id, val) VALUES (8, 1);
319 UPDATE t1 SET val=val+1 WHERE id=1;
320 UPDATE t1 SET val=val+1 WHERE id=4;
321 #TRX4 (session C, depends on TRX2 (data))
322 BEGIN;
323 UPDATE t1 SET val=val+1 WHERE id=3;
324 INSERT INTO t1(id, val) VALUES (9, 1);
325 COMMIT;
326 finish TRX5 after TRX4
327 COMMIT;
328 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
329 BEGIN;
330 DELETE FROM t1 WHERE id=6;
331 COMMIT;
332 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
333 BEGIN;
334 UPDATE t1 SET val=val+1 WHERE id=4;
335 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
336 BEGIN;
337 UPDATE t1 SET val=val+1 WHERE id=5;
338 INSERT INTO t1(id, val) VALUES (6, 0);
339 COMMIT;
340 finish TRX8 after TRX7
341 COMMIT;
342 Drop table and flush logs to force binlog to rotate
343 DROP TABLE t1;
344 Processing binlog master-bin.000007
345 FLUSH LOGS;
346 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;3 5;3 6;5 7;7 8;7 9;9 10]
347 #### STEP 2.2 TEST Writeset_session+DDL ####
348 SET GLOBAL binlog_transaction_dependency_history_size=25000;
349 SELECT @@binlog_transaction_dependency_tracking,
350 @@binlog_transaction_dependency_history_size;
351 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
352 WRITESET_SESSION 25000
353 Warnings:
354 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
355 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
356 PRIMARY KEY (`id`)) ENGINE=InnoDB;
357 Warnings:
358 Warning 1681 Integer display width is deprecated and will be removed in a future release.
359 Warning 1681 Integer display width is deprecated and will be removed in a future release.
360 #TRX2 (session A, independent)
361 BEGIN;
362 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
363 #TRX1 (session B, independent)
364 BEGIN;
365 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
366 COMMIT;
367 finish TRX2 after TRX1
368 COMMIT;
369 #TRX3 (session B, no data dependency, depends on TRX1 (session))
370 BEGIN;
371 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
372 COMMIT;
373 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
374 BEGIN;
375 INSERT INTO t1(id, val) VALUES (8, 1);
376 UPDATE t1 SET val=val+1 WHERE id=1;
377 UPDATE t1 SET val=val+1 WHERE id=4;
378 Inserted a DDL after TRX5 and check that they run in parallel due to commit_order
379 CREATE TABLE `t2` (`id` int(11) NOT NULL, `val` int(11) NOT NULL) ENGINE=InnoDB;
380 Warnings:
381 Warning 1681 Integer display width is deprecated and will be removed in a future release.
382 Warning 1681 Integer display width is deprecated and will be removed in a future release.
383 ALTER TABLE t2 ADD COLUMN b INT;
384 DROP TABLE `t2`;
385 #TRX4 (session C, depends on TRX2 (data))
386 BEGIN;
387 UPDATE t1 SET val=val+1 WHERE id=3;
388 INSERT INTO t1(id, val) VALUES (9, 1);
389 COMMIT;
390 finish TRX5 after TRX4
391 COMMIT;
392 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
393 BEGIN;
394 DELETE FROM t1 WHERE id=6;
395 COMMIT;
396 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
397 BEGIN;
398 UPDATE t1 SET val=val+1 WHERE id=4;
399 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
400 BEGIN;
401 UPDATE t1 SET val=val+1 WHERE id=5;
402 INSERT INTO t1(id, val) VALUES (6, 0);
403 COMMIT;
404 finish TRX8 after TRX7
405 COMMIT;
406 Drop table and flush logs to force binlog to rotate
407 DROP TABLE t1;
408 Processing binlog master-bin.000008
409 FLUSH LOGS;
410 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;4 5;5 6;6 7;7 8;4 9;8 10;10 11;10 12;12 13]
411 #### STEP 2.3 TEST Writeset_session+rotation ####
412 SET GLOBAL binlog_transaction_dependency_history_size=25000;
413 SELECT @@binlog_transaction_dependency_tracking,
414 @@binlog_transaction_dependency_history_size;
415 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
416 WRITESET_SESSION 25000
417 Warnings:
418 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
419 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
420 PRIMARY KEY (`id`)) ENGINE=InnoDB;
421 Warnings:
422 Warning 1681 Integer display width is deprecated and will be removed in a future release.
423 Warning 1681 Integer display width is deprecated and will be removed in a future release.
424 #TRX2 (session A, independent)
425 BEGIN;
426 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
427 #TRX1 (session B, independent)
428 BEGIN;
429 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
430 COMMIT;
431 finish TRX2 after TRX1
432 COMMIT;
433 #TRX3 (session B, no data dependency, depends on TRX1 (session))
434 BEGIN;
435 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
436 COMMIT;
437 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
438 BEGIN;
439 INSERT INTO t1(id, val) VALUES (8, 1);
440 UPDATE t1 SET val=val+1 WHERE id=1;
441 UPDATE t1 SET val=val+1 WHERE id=4;
442 Flushing logs in the middle of the set
443 FLUSH LOGS;
444 #TRX4 (session C, depends on TRX2 (data))
445 BEGIN;
446 UPDATE t1 SET val=val+1 WHERE id=3;
447 INSERT INTO t1(id, val) VALUES (9, 1);
448 COMMIT;
449 finish TRX5 after TRX4
450 COMMIT;
451 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
452 BEGIN;
453 DELETE FROM t1 WHERE id=6;
454 COMMIT;
455 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
456 BEGIN;
457 UPDATE t1 SET val=val+1 WHERE id=4;
458 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
459 BEGIN;
460 UPDATE t1 SET val=val+1 WHERE id=5;
461 INSERT INTO t1(id, val) VALUES (6, 0);
462 COMMIT;
463 finish TRX8 after TRX7
464 COMMIT;
465 Drop table and flush logs to force binlog to rotate
466 DROP TABLE t1;
467 Processing binlog master-bin.000010
468 FLUSH LOGS;
469 include/include/assert_logical_timestamps.inc [0 1;0 2;1 3;3 4;3 5;5 6]
470 #### STEP 2.4 TEST Writeset_session+history ####
471 SET GLOBAL binlog_transaction_dependency_history_size=25000;
472 History size reduced to 5 to test when it becomes full
473 SET GLOBAL binlog_transaction_dependency_history_size=5;
474 SELECT @@binlog_transaction_dependency_tracking,
475 @@binlog_transaction_dependency_history_size;
476 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
477 WRITESET_SESSION 5
478 Warnings:
479 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
480 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
481 PRIMARY KEY (`id`)) ENGINE=InnoDB;
482 Warnings:
483 Warning 1681 Integer display width is deprecated and will be removed in a future release.
484 Warning 1681 Integer display width is deprecated and will be removed in a future release.
485 #TRX2 (session A, independent)
486 BEGIN;
487 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
488 #TRX1 (session B, independent)
489 BEGIN;
490 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
491 COMMIT;
492 finish TRX2 after TRX1
493 COMMIT;
494 #TRX3 (session B, no data dependency, depends on TRX1 (session))
495 BEGIN;
496 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
497 COMMIT;
498 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
499 BEGIN;
500 INSERT INTO t1(id, val) VALUES (8, 1);
501 UPDATE t1 SET val=val+1 WHERE id=1;
502 UPDATE t1 SET val=val+1 WHERE id=4;
503 #TRX4 (session C, depends on TRX2 (data))
504 BEGIN;
505 UPDATE t1 SET val=val+1 WHERE id=3;
506 INSERT INTO t1(id, val) VALUES (9, 1);
507 COMMIT;
508 finish TRX5 after TRX4
509 COMMIT;
510 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
511 BEGIN;
512 DELETE FROM t1 WHERE id=6;
513 COMMIT;
514 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
515 BEGIN;
516 UPDATE t1 SET val=val+1 WHERE id=4;
517 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
518 BEGIN;
519 UPDATE t1 SET val=val+1 WHERE id=5;
520 INSERT INTO t1(id, val) VALUES (6, 0);
521 COMMIT;
522 finish TRX8 after TRX7
523 COMMIT;
524 Drop table and flush logs to force binlog to rotate
525 DROP TABLE t1;
526 Processing binlog master-bin.000011
527 FLUSH LOGS;
528 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;2 4;4 5;4 6;6 7;7 8;7 9;9 10]
529 SET GLOBAL binlog_transaction_dependency_tracking = COMMIT_ORDER;
530 Warnings:
531 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
532 ######## 3. COMMIT_ORDER ########
533 #### STEP 3.1 TEST Commit_order ####
534 SET GLOBAL binlog_transaction_dependency_history_size=25000;
535 SELECT @@binlog_transaction_dependency_tracking,
536 @@binlog_transaction_dependency_history_size;
537 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
538 COMMIT_ORDER 25000
539 Warnings:
540 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
541 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
542 PRIMARY KEY (`id`)) ENGINE=InnoDB;
543 Warnings:
544 Warning 1681 Integer display width is deprecated and will be removed in a future release.
545 Warning 1681 Integer display width is deprecated and will be removed in a future release.
546 #TRX2 (session A, independent)
547 BEGIN;
548 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
549 #TRX1 (session B, independent)
550 BEGIN;
551 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
552 COMMIT;
553 finish TRX2 after TRX1
554 COMMIT;
555 #TRX3 (session B, no data dependency, depends on TRX1 (session))
556 BEGIN;
557 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
558 COMMIT;
559 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
560 BEGIN;
561 INSERT INTO t1(id, val) VALUES (8, 1);
562 UPDATE t1 SET val=val+1 WHERE id=1;
563 UPDATE t1 SET val=val+1 WHERE id=4;
564 #TRX4 (session C, depends on TRX2 (data))
565 BEGIN;
566 UPDATE t1 SET val=val+1 WHERE id=3;
567 INSERT INTO t1(id, val) VALUES (9, 1);
568 COMMIT;
569 finish TRX5 after TRX4
570 COMMIT;
571 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
572 BEGIN;
573 DELETE FROM t1 WHERE id=6;
574 COMMIT;
575 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
576 BEGIN;
577 UPDATE t1 SET val=val+1 WHERE id=4;
578 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
579 BEGIN;
580 UPDATE t1 SET val=val+1 WHERE id=5;
581 INSERT INTO t1(id, val) VALUES (6, 0);
582 COMMIT;
583 finish TRX8 after TRX7
584 COMMIT;
585 Drop table and flush logs to force binlog to rotate
586 DROP TABLE t1;
587 Processing binlog master-bin.000012
588 FLUSH LOGS;
589 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;3 4;4 5;4 6;6 7;7 8;7 9;9 10]
590 #### STEP 3.2 TEST Commit_order+DDL ####
591 SET GLOBAL binlog_transaction_dependency_history_size=25000;
592 SELECT @@binlog_transaction_dependency_tracking,
593 @@binlog_transaction_dependency_history_size;
594 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
595 COMMIT_ORDER 25000
596 Warnings:
597 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
598 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
599 PRIMARY KEY (`id`)) ENGINE=InnoDB;
600 Warnings:
601 Warning 1681 Integer display width is deprecated and will be removed in a future release.
602 Warning 1681 Integer display width is deprecated and will be removed in a future release.
603 #TRX2 (session A, independent)
604 BEGIN;
605 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
606 #TRX1 (session B, independent)
607 BEGIN;
608 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
609 COMMIT;
610 finish TRX2 after TRX1
611 COMMIT;
612 #TRX3 (session B, no data dependency, depends on TRX1 (session))
613 BEGIN;
614 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
615 COMMIT;
616 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
617 BEGIN;
618 INSERT INTO t1(id, val) VALUES (8, 1);
619 UPDATE t1 SET val=val+1 WHERE id=1;
620 UPDATE t1 SET val=val+1 WHERE id=4;
621 Inserted a DDL after TRX5 and check that they run in parallel due to commit_order
622 CREATE TABLE `t2` (`id` int(11) NOT NULL, `val` int(11) NOT NULL) ENGINE=InnoDB;
623 Warnings:
624 Warning 1681 Integer display width is deprecated and will be removed in a future release.
625 Warning 1681 Integer display width is deprecated and will be removed in a future release.
626 ALTER TABLE t2 ADD COLUMN b INT;
627 DROP TABLE `t2`;
628 #TRX4 (session C, depends on TRX2 (data))
629 BEGIN;
630 UPDATE t1 SET val=val+1 WHERE id=3;
631 INSERT INTO t1(id, val) VALUES (9, 1);
632 COMMIT;
633 finish TRX5 after TRX4
634 COMMIT;
635 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
636 BEGIN;
637 DELETE FROM t1 WHERE id=6;
638 COMMIT;
639 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
640 BEGIN;
641 UPDATE t1 SET val=val+1 WHERE id=4;
642 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
643 BEGIN;
644 UPDATE t1 SET val=val+1 WHERE id=5;
645 INSERT INTO t1(id, val) VALUES (6, 0);
646 COMMIT;
647 finish TRX8 after TRX7
648 COMMIT;
649 Drop table and flush logs to force binlog to rotate
650 DROP TABLE t1;
651 Processing binlog master-bin.000013
652 FLUSH LOGS;
653 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;3 4;4 5;5 6;6 7;7 8;4 9;9 10;10 11;10 12;12 13]
654 #### STEP 3.3 TEST Commit_order+rotation ####
655 SET GLOBAL binlog_transaction_dependency_history_size=25000;
656 SELECT @@binlog_transaction_dependency_tracking,
657 @@binlog_transaction_dependency_history_size;
658 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
659 COMMIT_ORDER 25000
660 Warnings:
661 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
662 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
663 PRIMARY KEY (`id`)) ENGINE=InnoDB;
664 Warnings:
665 Warning 1681 Integer display width is deprecated and will be removed in a future release.
666 Warning 1681 Integer display width is deprecated and will be removed in a future release.
667 #TRX2 (session A, independent)
668 BEGIN;
669 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
670 #TRX1 (session B, independent)
671 BEGIN;
672 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
673 COMMIT;
674 finish TRX2 after TRX1
675 COMMIT;
676 #TRX3 (session B, no data dependency, depends on TRX1 (session))
677 BEGIN;
678 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
679 COMMIT;
680 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
681 BEGIN;
682 INSERT INTO t1(id, val) VALUES (8, 1);
683 UPDATE t1 SET val=val+1 WHERE id=1;
684 UPDATE t1 SET val=val+1 WHERE id=4;
685 Flushing logs in the middle of the set
686 FLUSH LOGS;
687 #TRX4 (session C, depends on TRX2 (data))
688 BEGIN;
689 UPDATE t1 SET val=val+1 WHERE id=3;
690 INSERT INTO t1(id, val) VALUES (9, 1);
691 COMMIT;
692 finish TRX5 after TRX4
693 COMMIT;
694 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
695 BEGIN;
696 DELETE FROM t1 WHERE id=6;
697 COMMIT;
698 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
699 BEGIN;
700 UPDATE t1 SET val=val+1 WHERE id=4;
701 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
702 BEGIN;
703 UPDATE t1 SET val=val+1 WHERE id=5;
704 INSERT INTO t1(id, val) VALUES (6, 0);
705 COMMIT;
706 finish TRX8 after TRX7
707 COMMIT;
708 Drop table and flush logs to force binlog to rotate
709 DROP TABLE t1;
710 Processing binlog master-bin.000015
711 FLUSH LOGS;
712 include/include/assert_logical_timestamps.inc [0 1;0 2;2 3;3 4;3 5;5 6]
713 #### STEP 3.4 TEST Commit_order+history ####
714 SET GLOBAL binlog_transaction_dependency_history_size=25000;
715 History size reduced to 5 to test when it becomes full
716 SET GLOBAL binlog_transaction_dependency_history_size=5;
717 SELECT @@binlog_transaction_dependency_tracking,
718 @@binlog_transaction_dependency_history_size;
719 @@binlog_transaction_dependency_tracking @@binlog_transaction_dependency_history_size
720 COMMIT_ORDER 5
721 Warnings:
722 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
723 CREATE TABLE `t1` (`id` int(11) NOT NULL, `val` int(11) NOT NULL,
724 PRIMARY KEY (`id`)) ENGINE=InnoDB;
725 Warnings:
726 Warning 1681 Integer display width is deprecated and will be removed in a future release.
727 Warning 1681 Integer display width is deprecated and will be removed in a future release.
728 #TRX2 (session A, independent)
729 BEGIN;
730 INSERT INTO t1(id, val) VALUES (1, 0),(2, 0),(3, 0);
731 #TRX1 (session B, independent)
732 BEGIN;
733 INSERT INTO t1(id, val) VALUES (4, 0),(5, 0);
734 COMMIT;
735 finish TRX2 after TRX1
736 COMMIT;
737 #TRX3 (session B, no data dependency, depends on TRX1 (session))
738 BEGIN;
739 INSERT INTO t1(id, val) VALUES (6, 0),(7, 0);
740 COMMIT;
741 #TRX5 (session A, depends on TRX2 (session and data) and TRX1(data))
742 BEGIN;
743 INSERT INTO t1(id, val) VALUES (8, 1);
744 UPDATE t1 SET val=val+1 WHERE id=1;
745 UPDATE t1 SET val=val+1 WHERE id=4;
746 #TRX4 (session C, depends on TRX2 (data))
747 BEGIN;
748 UPDATE t1 SET val=val+1 WHERE id=3;
749 INSERT INTO t1(id, val) VALUES (9, 1);
750 COMMIT;
751 finish TRX5 after TRX4
752 COMMIT;
753 #TRX6 (session C, depends on TRX4 (session) and TRX3(data))
754 BEGIN;
755 DELETE FROM t1 WHERE id=6;
756 COMMIT;
757 #TRX8 (session C, depends on TRX5 (data) and TRX6 (session))
758 BEGIN;
759 UPDATE t1 SET val=val+1 WHERE id=4;
760 #TRX7 (session B, depends on TRX1 and TRX6 (data) and TRX3 (session))
761 BEGIN;
762 UPDATE t1 SET val=val+1 WHERE id=5;
763 INSERT INTO t1(id, val) VALUES (6, 0);
764 COMMIT;
765 finish TRX8 after TRX7
766 COMMIT;
767 Drop table and flush logs to force binlog to rotate
768 DROP TABLE t1;
769 Processing binlog master-bin.000016
770 FLUSH LOGS;
771 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;3 4;4 5;4 6;6 7;7 8;7 9;9 10]
772
773 #### Verify that replication was correct ####
774 include/start_slave.inc
775 include/sync_slave_sql_with_master.inc
776 include/diff_tables.inc [master:test.tests, slave:test.tests]
777 DROP TABLE `tests`;
778 include/sync_slave_sql_with_master.inc
779 SET GLOBAL binlog_transaction_dependency_tracking= WRITESET;
780 Warnings:
781 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
782 SET GLOBAL binlog_transaction_dependency_history_size= DEFAULT;
783 FLUSH LOGS;
784
785 #### Bug#25616372, PART1 ####
786 CREATE TABLE t1 (a INT PRIMARY KEY NOT NULL AUTO_INCREMENT);
787 INSERT INTO t1 VALUES (null);
788 INSERT INTO t1 VALUES (null);
789 set global binlog_transaction_dependency_tracking=WRITESET;
790 Warnings:
791 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
792 INSERT INTO t1 VALUES (null);
793 INSERT INTO t1 VALUES (null);
794 Processing binlog master-bin.000018
795 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;3 4;3 5]
796 FLUSH LOGS;
797
798 #### Bug#25616372, PART2 ####
799 INSERT INTO t1 VALUES (null);
800 INSERT INTO t1 VALUES (null);
801 set global binlog_transaction_dependency_tracking=WRITESET;
802 Warnings:
803 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
804 INSERT INTO t1 VALUES (null);
805 INSERT INTO t1 VALUES (null);
806 INSERT INTO t1 VALUES (null);
807 Processing binlog master-bin.000019
808 include/include/assert_logical_timestamps.inc [0 1;1 2;2 3;2 4;2 5]
809 DROP TABLE t1;
810 FLUSH LOGS;
811
812 #### Bug#26277771, PART1 ####
813 CREATE TABLE t1 (c1 int(10) NOT NULL, c2 varchar(20) NOT NULL, PRIMARY KEY (c1),
814 UNIQUE KEY (c1, c2)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
815 Warnings:
816 Warning 1681 Integer display width is deprecated and will be removed in a future release.
817 INSERT INTO t1 VALUES (1, 'a');
818 DELETE FROM t1 WHERE c1=1 AND c2='a';
819 INSERT INTO t1 VALUES (1, 'A');
820 Processing binlog master-bin.000020
821 include/include/assert_logical_timestamps.inc [0 1;1 2;2 3;3 4]
822 DROP TABLE t1;
823 FLUSH LOGS;
824
825 #### Bug#26277771, PART2 ####
826 CREATE TABLE t1 (c1 VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL PRIMARY KEY);
827 Warnings:
828 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
829 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
830 INSERT INTO t1 VALUES ('a');
831 INSERT INTO t1 VALUES ('A');
832 INSERT INTO t1 VALUES ('b');
833 INSERT INTO t1 VALUES ('B');
834 Processing binlog master-bin.000021
835 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;1 4;1 5]
836 DROP TABLE t1;
837 FLUSH LOGS;
838
839 #### Bug#26277771, PART3 ####
840 CREATE TABLE t1 (c1 VARCHAR(20) NOT NULL PRIMARY KEY);
841 INSERT INTO t1 VALUES ('a');
842 INSERT INTO t1 VALUES ('b');
843 CREATE TABLE t2 (c1 BINARY(3) NOT NULL PRIMARY KEY);
844 INSERT INTO t2 VALUES ('a');
845 INSERT INTO t2 VALUES ('\0a');
846 INSERT INTO t2 VALUES ('\0');
847 INSERT INTO t2 VALUES ('a ');
848 Processing binlog master-bin.000022
849 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3;3 4;4 5;4 6;4 7;4 8]
850 DROP TABLE t1;
851 DROP TABLE t2;
852 FLUSH LOGS;
853
854 #### Bug#26277771, PART4 ####
855 CREATE TABLE t1 (c1 varchar(20) NOT NULL PRIMARY KEY)
856 ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
857 Warnings:
858 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
859 Warning 3778 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
860 INSERT INTO t1 VALUES ('a');
861 INSERT INTO t1 VALUES ('รก');
862 Processing binlog master-bin.000023
863 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3]
864 DROP TABLE t1;
865 FLUSH LOGS;
866
867 #### Test ROLLBACK TO SAVEPOINT ####
868 CREATE TABLE t1 (a INT PRIMARY KEY);
869 CREATE TABLE nopk (a INT);
870 CREATE TABLE parent (a INT PRIMARY KEY);
871 CREATE TABLE child (a INT PRIMARY KEY, FOREIGN KEY (a) REFERENCES parent(a));
872 # 1. Hashes of rolled-back rows are removed from writeset
873 FLUSH LOGS;
874 INSERT INTO t1 VALUES (1);
875 BEGIN;
876 SAVEPOINT sp;
877 UPDATE t1 SET a = 2;
878 ROLLBACK TO sp;
879 INSERT INTO t1 VALUES (2);
880 COMMIT;
881 INSERT INTO t1 VALUES (3);
882 Processing binlog master-bin.000025
883 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3]
884 # 2. If transaction is flagged as updating a non-index table, the flag is not rolled-back
885 FLUSH LOGS;
886 INSERT INTO t1 VALUES (4);
887 BEGIN;
888 SAVEPOINT sp;
889 INSERT INTO nopk VALUES (1);
890 ROLLBACK TO sp;
891 INSERT INTO t1 VALUES (5);
892 COMMIT;
893 INSERT INTO t1 VALUES (6);
894 Processing binlog master-bin.000026
895 include/include/assert_logical_timestamps.inc [0 1;1 2;1 3]
896 # 3. If transaction is flagged as updating a foreign key parent table, the flag is not rolled-back
897 FLUSH LOGS;
898 INSERT INTO t1 VALUES (7);
899 BEGIN;
900 SAVEPOINT sp;
901 INSERT INTO parent VALUES (1);
902 ROLLBACK TO sp;
903 INSERT INTO t1 VALUES (8);
904 COMMIT;
905 INSERT INTO t1 VALUES (9);
906 Processing binlog master-bin.000027
907 include/include/assert_logical_timestamps.inc [0 1;1 2;2 3]
908 # Clean up SAVEPOINT tests
909 DROP TABLE t1;
910 DROP TABLE nopk;
911 DROP TABLE child;
912 DROP TABLE parent;
913
914 #### CLEANUP ####
915 include/sync_slave_sql_with_master.inc
916 include/stop_slave.inc
917 SET @@GLOBAL.replica_parallel_type= @save_replica_parallel_type;
918 Warnings:
919 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
920 SET @@GLOBAL.replica_parallel_workers= @save_replica_parallel_workers;
921 SET @@GLOBAL.replica_transaction_retries= @save_replica_transaction_retries;
922 include/start_slave.inc
923 SET GLOBAL binlog_transaction_dependency_tracking = COMMIT_ORDER;
924 Warnings:
925 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
926 SET @@GLOBAL.binlog_transaction_dependency_tracking= @save_binlog_transaction_dependency_tracking;
927 Warnings:
928 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
929 SET @@GLOBAL.binlog_transaction_dependency_history_size= @save_binlog_transaction_dependency_history_size;
930 include/rpl_end.inc