Debian Codegraph @

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