Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_begin_commit_rollback.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 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
8 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
9 SET @@session.binlog_direct_non_transactional_updates= FALSE;
10 CREATE DATABASE replicate_do_db;
11 CREATE DATABASE binlog_ignore_db;
12 USE replicate_do_db;
13 CREATE TABLE replicate_do_db.t1 (a INT) ENGINE=InnoDB;
14 CREATE TABLE replicate_do_db.t2 (s CHAR(255)) ENGINE=MyISAM;
15 include/sync_slave_sql_with_master.inc
16 include/stop_slave.inc
17 [connection master]
18 CREATE PROCEDURE replicate_do_db.p1 ()
19 BEGIN
20 INSERT INTO t1 VALUES (1);
21 INSERT INTO t1 VALUES (2);
22 INSERT INTO t1 VALUES (3);
23 INSERT INTO t1 VALUES (4);
24 INSERT INTO t1 VALUES (5);
25 END//
26 CREATE PROCEDURE replicate_do_db.p2 ()
27 BEGIN
28 INSERT INTO t1 VALUES (6);
29 INSERT INTO t1 VALUES (7);
30 INSERT INTO t1 VALUES (8);
31 INSERT INTO t1 VALUES (9);
32 INSERT INTO t1 VALUES (10);
33 INSERT INTO t2 VALUES ('executed replicate_do_db.p2()');
34 END//
35 INSERT INTO replicate_do_db.t2 VALUES ('before call replicate_do_db.p1()');
36 USE test;
37 BEGIN;
38 CALL replicate_do_db.p1();
39 COMMIT;
40 INSERT INTO replicate_do_db.t2 VALUES ('after call replicate_do_db.p1()');
41 SELECT * FROM replicate_do_db.t1;
42 a
43 1
44 2
45 3
46 4
47 5
48 SELECT * FROM replicate_do_db.t2;
49 s
50 before call replicate_do_db.p1()
51 after call replicate_do_db.p1()
52 [connection slave]
53 START SLAVE UNTIL SOURCE_LOG_FILE='master-bin.000001', SOURCE_LOG_POS=MASTER_POS;
54 Warnings:
55 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
56 include/wait_for_slave_sql_to_stop.inc
57 include/assert.inc [Slave should have stopped after executing the stored procedure transaction]
58 SELECT * from replicate_do_db.t1;
59 a
60 1
61 2
62 3
63 4
64 5
65 SELECT * from replicate_do_db.t2;
66 s
67 before call replicate_do_db.p1()
68 [connection master]
69 INSERT INTO replicate_do_db.t2 VALUES ('before call replicate_do_db.p2()');
70 BEGIN;
71 CALL replicate_do_db.p2();
72 Warnings:
73 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
74 ROLLBACK;
75 INSERT INTO replicate_do_db.t2 VALUES ('after call replicate_do_db.p2()');
76 SELECT * FROM replicate_do_db.t1;
77 a
78 1
79 2
80 3
81 4
82 5
83 SELECT * FROM replicate_do_db.t2;
84 s
85 before call replicate_do_db.p1()
86 after call replicate_do_db.p1()
87 before call replicate_do_db.p2()
88 executed replicate_do_db.p2()
89 after call replicate_do_db.p2()
90 [connection slave]
91 START SLAVE UNTIL SOURCE_LOG_FILE='master-bin.000001', SOURCE_LOG_POS=MASTER_POS;
92 Warnings:
93 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
94 include/wait_for_slave_sql_to_stop.inc
95 include/assert.inc [Slave should have stopped after executing the stored procedure transaction]
96 SELECT * from replicate_do_db.t1;
97 a
98 1
99 2
100 3
101 4
102 5
103 SELECT * from replicate_do_db.t2;
104 s
105 before call replicate_do_db.p1()
106 executed replicate_do_db.p2()
107 START SLAVE;
108 Warnings:
109 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
110 include/wait_for_slave_sql_to_start.inc
111 #
112 # SAVEPOINT and ROLLBACK TO have the same problem in BUG#43263
113 # This was reported by BUG#50407
114 [connection master]
115 BEGIN;
116 INSERT INTO replicate_do_db.t1 VALUES(20);
117 #
118 # Verify whether this statement is binlogged correctly
119 /*comment*/ SAVEPOINT has_comment;
120 USE replicate_do_db;
121 INSERT INTO replicate_do_db.t1 VALUES(30);
122 INSERT INTO replicate_do_db.t2 VALUES("in savepoint has_comment");
123 Warnings:
124 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
125 USE binlog_ignore_db;
126 SavePoint mixed_cases;
127 USE replicate_do_db;
128 INSERT INTO replicate_do_db.t2 VALUES("in savepoint mixed_cases");
129 Warnings:
130 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
131 INSERT INTO replicate_do_db.t1 VALUES(40);
132 USE binlog_ignore_db;
133 ROLLBACK TO mixed_cases;
134 Warnings:
135 Warning 1196 Some non-transactional changed tables couldn't be rolled back
136 ROLLBACK TO has_comment;
137 Warnings:
138 Warning 1196 Some non-transactional changed tables couldn't be rolled back
139 USE replicate_do_db;
140 INSERT INTO replicate_do_db.t2 VALUES("after rollback to");
141 Warnings:
142 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
143 INSERT INTO replicate_do_db.t1 VALUES(50);
144 USE binlog_ignore_db;
145 COMMIT;
146 include/show_binlog_events.inc
147 Log_name Pos Event_type Server_id End_log_pos Info
148 master-bin.000001 # Query # # BEGIN
149 master-bin.000001 # Query # # use `test`; INSERT INTO replicate_do_db.t1 VALUES(20)
150 master-bin.000001 # Query # # SAVEPOINT `has_comment`
151 master-bin.000001 # Query # # use `replicate_do_db`; INSERT INTO replicate_do_db.t1 VALUES(30)
152 master-bin.000001 # Query # # use `replicate_do_db`; INSERT INTO replicate_do_db.t2 VALUES("in savepoint has_comment")
153 master-bin.000001 # Query # # SAVEPOINT `mixed_cases`
154 master-bin.000001 # Query # # use `replicate_do_db`; INSERT INTO replicate_do_db.t2 VALUES("in savepoint mixed_cases")
155 master-bin.000001 # Query # # use `replicate_do_db`; INSERT INTO replicate_do_db.t1 VALUES(40)
156 master-bin.000001 # Query # # ROLLBACK TO `mixed_cases`
157 master-bin.000001 # Query # # ROLLBACK TO `has_comment`
158 master-bin.000001 # Query # # use `replicate_do_db`; INSERT INTO replicate_do_db.t2 VALUES("after rollback to")
159 master-bin.000001 # Query # # use `replicate_do_db`; INSERT INTO replicate_do_db.t1 VALUES(50)
160 master-bin.000001 # Xid # # COMMIT /* XID */
161 include/sync_slave_sql_with_master.inc
162 [on slave]
163 #
164 # Verify INSERT statements in savepoints are executed, for MyISAM table
165 # is not effected by ROLLBACK TO
166 SELECT * FROM replicate_do_db.t2 WHERE s LIKE '% savepoint %';
167 s
168 in savepoint has_comment
169 in savepoint mixed_cases
170 #
171 # Verify INSERT statements on the Innodb table are rolled back;
172 SELECT * FROM replicate_do_db.t1 WHERE a IN (30, 40);
173 a
174
175 # BUG#55798 Slave SQL retry on transaction inserts extra data into
176 # non-transaction table
177 # ----------------------------------------------------------------
178 # To verify that SQL thread does not retry a transaction which can
179 # not be rolled back safely, even though only a temporary error is
180 # encountered.
181
182 [connection master]
183 USE replicate_do_db;
184 DROP TABLE t1, t2;
185 CREATE TABLE t1(c1 INT KEY, c2 CHAR(100)) ENGINE=InnoDB;
186 CREATE TABLE t2(c1 INT) ENGINE=MyISAM;
187 CREATE TABLE t3(c1 INT) ENGINE=InnoDB;
188 INSERT INTO t1 VALUES(1, "master");
189 SET @@session.binlog_direct_non_transactional_updates= FALSE;
190 include/sync_slave_sql_with_master.inc
191 # [ on slave ]
192 USE replicate_do_db;
193 SET @timeout_old= @@GLOBAL.innodb_lock_wait_timeout;
194 SET GLOBAL innodb_lock_wait_timeout= 1;
195 STOP SLAVE SQL_THREAD;
196 Warnings:
197 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
198 include/wait_for_slave_sql_to_stop.inc
199 START SLAVE SQL_THREAD;
200 Warnings:
201 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
202 include/wait_for_slave_sql_to_start.inc
203 # Verify the SQL thread doesn't retry the transaction when one of
204 # its statements has modified a non-transactional table.
205 # ----------------------------------------------------------------
206
207 # INSERT statement inserts a row to a non-transactional table.
208 # [ on slave ]
209 BEGIN;
210 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
211 UPDATE t1 SET c2= "slave" WHERE c1= 1;
212 # [ on master ]
213 BEGIN;
214 INSERT INTO t3 VALUES(1);
215 INSERT INTO t2 VALUES(1);
216 Warnings:
217 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
218 UPDATE t1 SET c2='INSERT INTO t2 VALUES(1)' WHERE c1= 1;
219 COMMIT;
220 # [ on slave ]
221 include/wait_for_slave_sql_error.inc [errno=1205]
222 ROLLBACK;
223 START SLAVE SQL_THREAD;
224 Warnings:
225 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
226 include/wait_for_slave_sql_to_start.inc
227
228 # INSERT ... SELECT statement inserts a row to a non-transactional table.
229 # [ on slave ]
230 BEGIN;
231 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
232 UPDATE t1 SET c2= "slave" WHERE c1= 1;
233 # [ on master ]
234 BEGIN;
235 INSERT INTO t3 VALUES(1);
236 INSERT INTO t2 SELECT 2;
237 Warnings:
238 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
239 UPDATE t1 SET c2='INSERT INTO t2 SELECT 2' WHERE c1= 1;
240 COMMIT;
241 # [ on slave ]
242 include/wait_for_slave_sql_error.inc [errno=1205]
243 ROLLBACK;
244 START SLAVE SQL_THREAD;
245 Warnings:
246 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
247 include/wait_for_slave_sql_to_start.inc
248
249 # UPDATE statement updates a row to a non-transactional table.
250 # [ on slave ]
251 BEGIN;
252 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
253 UPDATE t1 SET c2= "slave" WHERE c1= 1;
254 # [ on master ]
255 BEGIN;
256 INSERT INTO t3 VALUES(1);
257 UPDATE t2 SET c1= 3;
258 Warnings:
259 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
260 UPDATE t1 SET c2='UPDATE t2 SET c1= 3' WHERE c1= 1;
261 COMMIT;
262 # [ on slave ]
263 include/wait_for_slave_sql_error.inc [errno=1205]
264 ROLLBACK;
265 START SLAVE SQL_THREAD;
266 Warnings:
267 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
268 include/wait_for_slave_sql_to_start.inc
269
270 # MULTI-UPDATE statement updates a row to a non-transactional table.
271 # [ on slave ]
272 BEGIN;
273 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
274 UPDATE t1 SET c2= "slave" WHERE c1= 1;
275 # [ on master ]
276 BEGIN;
277 INSERT INTO t3 VALUES(1);
278 UPDATE t2, t3 SET t2.c1=4, t3.c1= 4;
279 Warnings:
280 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
281 UPDATE t1 SET c2='UPDATE t2, t3 SET t2.c1=4, t3.c1= 4' WHERE c1= 1;
282 COMMIT;
283 # [ on slave ]
284 include/wait_for_slave_sql_error.inc [errno=1205]
285 ROLLBACK;
286 START SLAVE SQL_THREAD;
287 Warnings:
288 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
289 include/wait_for_slave_sql_to_start.inc
290
291 # DELETE statement deletes a row from a non-transactional table.
292 # [ on slave ]
293 BEGIN;
294 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
295 UPDATE t1 SET c2= "slave" WHERE c1= 1;
296 # [ on master ]
297 BEGIN;
298 INSERT INTO t3 VALUES(1);
299 DELETE FROM t2;
300 Warnings:
301 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction.
302 UPDATE t1 SET c2='DELETE FROM t2' WHERE c1= 1;
303 COMMIT;
304 # [ on slave ]
305 include/wait_for_slave_sql_error.inc [errno=1205]
306 ROLLBACK;
307 START SLAVE SQL_THREAD;
308 Warnings:
309 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
310 include/wait_for_slave_sql_to_start.inc
311
312 # CREATE TEMPORARY TABLE statement in the transaction
313 # [ on slave ]
314 BEGIN;
315 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
316 UPDATE t1 SET c2= "slave" WHERE c1= 1;
317 # [ on master ]
318 BEGIN;
319 INSERT INTO t3 VALUES(1);
320 CREATE TEMPORARY TABLE IF NOT EXISTS temp_t(c1 INT);
321 UPDATE t1 SET c2='CREATE TEMPORARY TABLE IF NOT EXISTS temp_t(c1 INT)' WHERE c1= 1;
322 COMMIT;
323 # [ on slave ]
324 include/wait_for_slave_sql_error.inc [errno=1205]
325 ROLLBACK;
326 START SLAVE SQL_THREAD;
327 Warnings:
328 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
329 include/wait_for_slave_sql_to_start.inc
330
331 # DROP TEMPORARY TABLE statement in the transaction
332 # [ on slave ]
333 BEGIN;
334 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
335 UPDATE t1 SET c2= "slave" WHERE c1= 1;
336 # [ on master ]
337 BEGIN;
338 INSERT INTO t3 VALUES(1);
339 DROP TEMPORARY TABLE IF EXISTS temp_t;
340 UPDATE t1 SET c2='DROP TEMPORARY TABLE IF EXISTS temp_t' WHERE c1= 1;
341 COMMIT;
342 # [ on slave ]
343 include/wait_for_slave_sql_error.inc [errno=1205]
344 ROLLBACK;
345 START SLAVE SQL_THREAD;
346 Warnings:
347 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
348 include/wait_for_slave_sql_to_start.inc
349
350 # Verify that the SQL thread doesn't retry the transaction if one
351 # of the sub-statements has modified a non-transactional table.
352 # ----------------------------------------------------------------
353 CREATE FUNCTION f_insert()
354 RETURNS INT
355 BEGIN
356 INSERT INTO t2 VALUES(1);
357 RETURN 2;
358 END|
359 CREATE FUNCTION f_insert_select()
360 RETURNS INT
361 BEGIN
362 INSERT INTO t2 SELECT 2;
363 RETURN 2;
364 END|
365 CREATE FUNCTION f_update()
366 RETURNS INT
367 BEGIN
368 UPDATE t2 SET c1=3;
369 RETURN 2;
370 END |
371 CREATE TABLE t4 (c1 INT) |
372 INSERT INTO t4 VAlUES(1),(2) |
373 CREATE FUNCTION f_multi_update()
374 RETURNS INT
375 BEGIN
376 UPDATE t2, t4 SET t2.c1=4, t4.c1= 4;
377 RETURN 2;
378 END |
379 CREATE FUNCTION f_delete()
380 RETURNS INT
381 BEGIN
382 DELETE FROM t2;
383 RETURN 2;
384 END |
385
386 # The INSERT statement in a function inserts a row into a
387 # non-transactional table.
388 # [ on slave ]
389 BEGIN;
390 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
391 UPDATE t1 SET c2= "slave" WHERE c1= 1;
392 # [ on master ]
393 BEGIN;
394 INSERT INTO t3 VALUES(1);
395 INSERT INTO t3 VALUES(f_insert());
396 Warnings:
397 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
398 UPDATE t1 SET c2='INSERT INTO t3 VALUES(f_insert())' WHERE c1= 1;
399 COMMIT;
400 # [ on slave ]
401 include/wait_for_slave_sql_error.inc [errno=1205]
402 ROLLBACK;
403 START SLAVE SQL_THREAD;
404 Warnings:
405 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
406 include/wait_for_slave_sql_to_start.inc
407
408 # The INSERT ... SELECT statement in a function inserts a row into a
409 # non-transactional table.
410 # [ on slave ]
411 BEGIN;
412 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
413 UPDATE t1 SET c2= "slave" WHERE c1= 1;
414 # [ on master ]
415 BEGIN;
416 INSERT INTO t3 VALUES(1);
417 INSERT INTO t3 VALUES(f_insert());
418 Warnings:
419 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
420 UPDATE t1 SET c2='INSERT INTO t3 VALUES(f_insert())' WHERE c1= 1;
421 COMMIT;
422 # [ on slave ]
423 include/wait_for_slave_sql_error.inc [errno=1205]
424 ROLLBACK;
425 START SLAVE SQL_THREAD;
426 Warnings:
427 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
428 include/wait_for_slave_sql_to_start.inc
429
430 # The UPDATE statement in a function updates a row of a
431 # non-transactional table.
432 # [ on slave ]
433 BEGIN;
434 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
435 UPDATE t1 SET c2= "slave" WHERE c1= 1;
436 # [ on master ]
437 BEGIN;
438 INSERT INTO t3 VALUES(1);
439 INSERT INTO t3 VALUES(f_update());
440 Warnings:
441 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
442 UPDATE t1 SET c2='INSERT INTO t3 VALUES(f_update())' WHERE c1= 1;
443 COMMIT;
444 # [ on slave ]
445 include/wait_for_slave_sql_error.inc [errno=1205]
446 ROLLBACK;
447 START SLAVE SQL_THREAD;
448 Warnings:
449 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
450 include/wait_for_slave_sql_to_start.inc
451
452 # The MULTI-UPDATE statement in a function updates a row of a
453 # non-transactional table.
454 # [ on slave ]
455 BEGIN;
456 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
457 UPDATE t1 SET c2= "slave" WHERE c1= 1;
458 # [ on master ]
459 BEGIN;
460 INSERT INTO t3 VALUES(1);
461 INSERT INTO t3 VALUES(f_multi_update());
462 Warnings:
463 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
464 UPDATE t1 SET c2='INSERT INTO t3 VALUES(f_multi_update())' WHERE c1= 1;
465 COMMIT;
466 # [ on slave ]
467 include/wait_for_slave_sql_error.inc [errno=1205]
468 ROLLBACK;
469 START SLAVE SQL_THREAD;
470 Warnings:
471 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
472 include/wait_for_slave_sql_to_start.inc
473
474 # The DELETE statement in a function deletes a row from a
475 # non-transactional table.
476 # [ on slave ]
477 BEGIN;
478 # It will lock table t1 on the row in which c1 is 1 until COMMIT or ROLLBACK
479 UPDATE t1 SET c2= "slave" WHERE c1= 1;
480 # [ on master ]
481 BEGIN;
482 INSERT INTO t3 VALUES(1);
483 INSERT INTO t3 VALUES(f_delete());
484 Warnings:
485 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
486 UPDATE t1 SET c2='INSERT INTO t3 VALUES(f_delete())' WHERE c1= 1;
487 COMMIT;
488 # [ on slave ]
489 include/wait_for_slave_sql_error.inc [errno=1205]
490 ROLLBACK;
491 START SLAVE SQL_THREAD;
492 Warnings:
493 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
494 include/wait_for_slave_sql_to_start.inc
495 SET @@global.innodb_lock_wait_timeout= @timeout_old;
496 #
497 # Clean up
498 #
499 DROP DATABASE replicate_do_db;
500 DROP DATABASE binlog_ignore_db;
501 include/rpl_end.inc