Debian Codegraph @

mysql-test/suite/rpl/r/rpl_trx_boundary_parser_warning.result

raw
1 call mtr.add_suppression("Statement is unsafe because it is being used inside a XA transaction");
2 include/master-slave.inc
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection master]
7 [connection slave]
8 call mtr.add_suppression("An unexpected event sequence was detected by the IO thread");
9 call mtr.add_suppression("GTID_LOG_EVENT .* is not expected in an event stream");
10 call mtr.add_suppression("QUERY.* is not expected in an event stream");
11 CALL mtr.add_suppression("Unsafe statement written to the binary log using statement format since*");
12 include/stop_slave.inc
13 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
14 [connection master]
15 SET @var= 10;
16 CREATE EVENT ev1 ON SCHEDULE EVERY @var HOUR DO INSERT INTO t1 VALUES (0);
17 CREATE TABLE t1 (c1 INT) ENGINE= InnoDB;
18 INSERT INTO t1 VALUES (1);
19 CREATE TABLE t2 (c1 INT) ENGINE= MyISAM;
20 INSERT INTO t2 VALUES (1);
21 XA START 'xa_trx';
22 INSERT INTO t1 VALUES(2);
23 Warnings:
24 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it is being used inside a XA transaction. Concurrent XA transactions may deadlock on replicas when replicated using statements.
25 XA END 'xa_trx';
26 XA PREPARE 'xa_trx';
27 XA ROLLBACK 'xa_trx';
28 include/show_binlog_events.inc
29 Log_name Pos Event_type Server_id End_log_pos Info
30 master-bin.000001 # Previous_gtids # #
31 master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
32 master-bin.000001 # User var # # @`var`=10
33 master-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT ev1 ON SCHEDULE EVERY @var HOUR DO INSERT INTO t1 VALUES (0)
34 master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
35 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (c1 INT) ENGINE= InnoDB
36 master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
37 master-bin.000001 # Query # # BEGIN
38 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
39 master-bin.000001 # Xid # # COMMIT /* XID */
40 master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
41 master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (c1 INT) ENGINE= MyISAM
42 master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
43 master-bin.000001 # Query # # BEGIN
44 master-bin.000001 # Query # # use `test`; INSERT INTO t2 VALUES (1)
45 master-bin.000001 # Query # # COMMIT
46 master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
47 master-bin.000001 # Query # # XA START X'78615f747278',X'',1
48 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES(2)
49 master-bin.000001 # Query # # XA END X'78615f747278',X'',1
50 master-bin.000001 # XA_prepare # # XA PREPARE X'78615f747278',X'',1
51 master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
52 master-bin.000001 # Query # # XA ROLLBACK X'78615f747278',X'',1
53 [connection slave]
54 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
55 START SLAVE IO_THREAD;
56 Warnings:
57 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
58 # This is the event #3 of current slave relay log file
59 include/show_relaylog_events.inc
60 Log_name Pos Event_type Server_id End_log_pos Info
61 slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS
62 # This is the event #4 of current slave relay log file
63 include/show_relaylog_events.inc
64 Log_name Pos Event_type Server_id End_log_pos Info
65 slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
66 # This is the event #5 of current slave relay log file
67 include/show_relaylog_events.inc
68 Log_name Pos Event_type Server_id End_log_pos Info
69 slave-relay-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
70 # This is the event #6 of current slave relay log file
71 include/show_relaylog_events.inc
72 Log_name Pos Event_type Server_id End_log_pos Info
73 slave-relay-bin.000002 # User var # # @`var`=10
74 # This is the event #7 of current slave relay log file
75 include/show_relaylog_events.inc
76 Log_name Pos Event_type Server_id End_log_pos Info
77 slave-relay-bin.000002 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` EVENT ev1 ON SCHEDULE EVERY @var HOUR DO INSERT INTO t1 VALUES (0)
78 # This is the event #8 of current slave relay log file
79 include/show_relaylog_events.inc
80 Log_name Pos Event_type Server_id End_log_pos Info
81 slave-relay-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
82 # This is the event #9 of current slave relay log file
83 include/show_relaylog_events.inc
84 Log_name Pos Event_type Server_id End_log_pos Info
85 slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (c1 INT) ENGINE= InnoDB
86 # This is the event #10 of current slave relay log file
87 include/show_relaylog_events.inc
88 Log_name Pos Event_type Server_id End_log_pos Info
89 slave-relay-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
90 # This is the event #11 of current slave relay log file
91 include/show_relaylog_events.inc
92 Log_name Pos Event_type Server_id End_log_pos Info
93 slave-relay-bin.000002 # Query # # BEGIN
94 # This is the event #12 of current slave relay log file
95 include/show_relaylog_events.inc
96 Log_name Pos Event_type Server_id End_log_pos Info
97 slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (1)
98 # This is the event #13 of current slave relay log file
99 include/show_relaylog_events.inc
100 Log_name Pos Event_type Server_id End_log_pos Info
101 slave-relay-bin.000002 # Xid # # COMMIT /* XID */
102 # This is the event #14 of current slave relay log file
103 include/show_relaylog_events.inc
104 Log_name Pos Event_type Server_id End_log_pos Info
105 slave-relay-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
106 # This is the event #15 of current slave relay log file
107 include/show_relaylog_events.inc
108 Log_name Pos Event_type Server_id End_log_pos Info
109 slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t2 (c1 INT) ENGINE= MyISAM
110 # This is the event #16 of current slave relay log file
111 include/show_relaylog_events.inc
112 Log_name Pos Event_type Server_id End_log_pos Info
113 slave-relay-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
114 # This is the event #17 of current slave relay log file
115 include/show_relaylog_events.inc
116 Log_name Pos Event_type Server_id End_log_pos Info
117 slave-relay-bin.000002 # Query # # BEGIN
118 # This is the event #18 of current slave relay log file
119 include/show_relaylog_events.inc
120 Log_name Pos Event_type Server_id End_log_pos Info
121 slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t2 VALUES (1)
122 # This is the event #19 of current slave relay log file
123 include/show_relaylog_events.inc
124 Log_name Pos Event_type Server_id End_log_pos Info
125 slave-relay-bin.000002 # Query # # COMMIT
126 # This is the event #20 of current slave relay log file
127 include/show_relaylog_events.inc
128 Log_name Pos Event_type Server_id End_log_pos Info
129 slave-relay-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
130 # This is the event #21 of current slave relay log file
131 include/show_relaylog_events.inc
132 Log_name Pos Event_type Server_id End_log_pos Info
133 slave-relay-bin.000002 # Query # # XA START X'78615f747278',X'',1
134 # This is the event #22 of current slave relay log file
135 include/show_relaylog_events.inc
136 Log_name Pos Event_type Server_id End_log_pos Info
137 slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES(2)
138 # This is the event #23 of current slave relay log file
139 include/show_relaylog_events.inc
140 Log_name Pos Event_type Server_id End_log_pos Info
141 slave-relay-bin.000002 # Query # # XA END X'78615f747278',X'',1
142 # This is the event #24 of current slave relay log file
143 include/show_relaylog_events.inc
144 Log_name Pos Event_type Server_id End_log_pos Info
145 slave-relay-bin.000002 # XA_prepare # # XA PREPARE X'78615f747278',X'',1
146 # This is the event #25 of current slave relay log file
147 include/show_relaylog_events.inc
148 Log_name Pos Event_type Server_id End_log_pos Info
149 slave-relay-bin.000002 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
150 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
151 [connection master]
152 include/sync_slave_io_with_master.inc
153 # This is the event #26 of current slave relay log file
154 include/show_relaylog_events.inc
155 Log_name Pos Event_type Server_id End_log_pos Info
156 slave-relay-bin.000002 # Query # # XA ROLLBACK X'78615f747278',X'',1
157
158 #
159 # Case 1: GTID_LOG_EVENT is not expected in an event stream after a GTID_LOG_EVENT.
160 #
161 # Cleaning up and reseting the slave
162 include/stop_slave.inc
163 Warnings:
164 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
165 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
166 START SLAVE IO_THREAD;
167 Warnings:
168 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
169 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
170 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
171 include/wait_for_slave_io_to_stop.inc
172 # Stopped IO thread after queuing the following event (#8):
173 include/show_relaylog_events.inc
174 Log_name Pos Event_type Server_id End_log_pos Info
175 slave-relay-bin.000003 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
176 include/rpl_stop_server.inc [server_number=2]
177 # Restoring a master.info.backup to start asking events at event #8
178 include/rpl_start_server.inc [server_number=2]
179 include/start_slave_io.inc
180 include/sync_slave_io_with_master.inc
181 # Restarted queuing the following event (#8):
182 include/show_relaylog_events.inc
183 Log_name Pos Event_type Server_id End_log_pos Info
184 slave-relay-bin.000005 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
185 include/assert_grep.inc [Case 1 found the expected warning line in the error log.]
186
187 #
188 # Case 2: GTID_LOG_EVENT is not expected in an event stream in the middle of a DDL.
189 #
190 # Cleaning up and reseting the slave
191 include/stop_slave.inc
192 Warnings:
193 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
194 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
195 START SLAVE IO_THREAD;
196 Warnings:
197 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
198 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
199 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
200 include/wait_for_slave_io_to_stop.inc
201 # Stopped IO thread after queuing the following event (#6):
202 include/show_relaylog_events.inc
203 Log_name Pos Event_type Server_id End_log_pos Info
204 slave-relay-bin.000003 # User var # # @`var`=10
205 include/rpl_stop_server.inc [server_number=2]
206 # Restoring a master.info.backup to start asking events at event #8
207 include/rpl_start_server.inc [server_number=2]
208 include/start_slave_io.inc
209 include/sync_slave_io_with_master.inc
210 # Restarted queuing the following event (#8):
211 include/show_relaylog_events.inc
212 Log_name Pos Event_type Server_id End_log_pos Info
213 slave-relay-bin.000005 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
214 include/assert_grep.inc [Case 2 found the expected warning line in the error log.]
215
216 #
217 # Case 3: GTID_LOG_EVENT is not expected in an event stream in the middle of a DML.
218 #
219 # Cleaning up and reseting the slave
220 include/stop_slave.inc
221 Warnings:
222 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
223 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
224 START SLAVE IO_THREAD;
225 Warnings:
226 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
227 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
228 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
229 include/wait_for_slave_io_to_stop.inc
230 # Stopped IO thread after queuing the following event (#11):
231 include/show_relaylog_events.inc
232 Log_name Pos Event_type Server_id End_log_pos Info
233 slave-relay-bin.000003 # Query # # BEGIN
234 include/rpl_stop_server.inc [server_number=2]
235 # Restoring a master.info.backup to start asking events at event #10
236 include/rpl_start_server.inc [server_number=2]
237 include/start_slave_io.inc
238 include/sync_slave_io_with_master.inc
239 # Restarted queuing the following event (#10):
240 include/show_relaylog_events.inc
241 Log_name Pos Event_type Server_id End_log_pos Info
242 slave-relay-bin.000005 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
243 include/assert_grep.inc [Case 3 found the expected warning line in the error log.]
244
245 #
246 # Case 4: QUERY(BEGIN) is not expected in an event stream in the middle of a DDL.
247 #
248 # Cleaning up and reseting the slave
249 include/stop_slave.inc
250 Warnings:
251 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
252 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
253 START SLAVE IO_THREAD;
254 Warnings:
255 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
256 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
257 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
258 include/wait_for_slave_io_to_stop.inc
259 # Stopped IO thread after queuing the following event (#6):
260 include/show_relaylog_events.inc
261 Log_name Pos Event_type Server_id End_log_pos Info
262 slave-relay-bin.000003 # User var # # @`var`=10
263 include/rpl_stop_server.inc [server_number=2]
264 # Restoring a master.info.backup to start asking events at event #11
265 include/rpl_start_server.inc [server_number=2]
266 include/start_slave_io.inc
267 include/sync_slave_io_with_master.inc
268 # Restarted queuing the following event (#11):
269 include/show_relaylog_events.inc
270 Log_name Pos Event_type Server_id End_log_pos Info
271 slave-relay-bin.000005 # Query # # BEGIN
272 include/assert_grep.inc [Case 4 found the expected warning line in the error log.]
273
274 #
275 # Case 5: QUERY(BEGIN) is not expected in an event stream in the middle of a DML.
276 #
277 # Cleaning up and reseting the slave
278 include/stop_slave.inc
279 Warnings:
280 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
281 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
282 START SLAVE IO_THREAD;
283 Warnings:
284 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
285 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
286 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
287 include/wait_for_slave_io_to_stop.inc
288 # Stopped IO thread after queuing the following event (#11):
289 include/show_relaylog_events.inc
290 Log_name Pos Event_type Server_id End_log_pos Info
291 slave-relay-bin.000003 # Query # # BEGIN
292 include/rpl_stop_server.inc [server_number=2]
293 # Restoring a master.info.backup to start asking events at event #11
294 include/rpl_start_server.inc [server_number=2]
295 include/start_slave_io.inc
296 include/sync_slave_io_with_master.inc
297 # Restarted queuing the following event (#11):
298 include/show_relaylog_events.inc
299 Log_name Pos Event_type Server_id End_log_pos Info
300 slave-relay-bin.000005 # Query # # BEGIN
301 include/assert_grep.inc [Case 5 found the expected warning line in the error log.]
302
303 #
304 # Case 6.a: QUERY(COMMIT or ROLLBACK) or XID_LOG_EVENT is not expected in an event stream outside a transaction.
305 #
306 # Cleaning up and reseting the slave
307 include/stop_slave.inc
308 Warnings:
309 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
310 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
311 START SLAVE IO_THREAD;
312 Warnings:
313 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
314 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
315 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
316 include/wait_for_slave_io_to_stop.inc
317 # Stopped IO thread after queuing the following event (#9):
318 include/show_relaylog_events.inc
319 Log_name Pos Event_type Server_id End_log_pos Info
320 slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (c1 INT) ENGINE= InnoDB
321 include/rpl_stop_server.inc [server_number=2]
322 # Restoring a master.info.backup to start asking events at event #13
323 include/rpl_start_server.inc [server_number=2]
324 include/start_slave_io.inc
325 include/sync_slave_io_with_master.inc
326 # Restarted queuing the following event (#13):
327 include/show_relaylog_events.inc
328 Log_name Pos Event_type Server_id End_log_pos Info
329 slave-relay-bin.000005 # Xid # # COMMIT /* XID */
330 include/assert_grep.inc [Case 6.a found the expected warning line in the error log.]
331
332 #
333 # Case 6.b: QUERY(COMMIT or ROLLBACK) or XID_LOG_EVENT is not expected in an event stream outside a transaction.
334 #
335 # Cleaning up and reseting the slave
336 include/stop_slave.inc
337 Warnings:
338 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
339 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
340 START SLAVE IO_THREAD;
341 Warnings:
342 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
343 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
344 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
345 include/wait_for_slave_io_to_stop.inc
346 # Stopped IO thread after queuing the following event (#9):
347 include/show_relaylog_events.inc
348 Log_name Pos Event_type Server_id End_log_pos Info
349 slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (c1 INT) ENGINE= InnoDB
350 include/rpl_stop_server.inc [server_number=2]
351 # Restoring a master.info.backup to start asking events at event #19
352 include/rpl_start_server.inc [server_number=2]
353 include/start_slave_io.inc
354 include/sync_slave_io_with_master.inc
355 # Restarted queuing the following event (#19):
356 include/show_relaylog_events.inc
357 Log_name Pos Event_type Server_id End_log_pos Info
358 slave-relay-bin.000005 # Query # # COMMIT
359 include/assert_grep.inc [Case 6.b found the expected warning line in the error log.]
360
361 #
362 # Case 7.a: QUERY(COMMIT or ROLLBACK) or XID_LOG_EVENT is not expected in an event stream after a GTID_LOG_EVENT.
363 #
364 # Cleaning up and reseting the slave
365 include/stop_slave.inc
366 Warnings:
367 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
368 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
369 START SLAVE IO_THREAD;
370 Warnings:
371 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
372 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
373 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
374 include/wait_for_slave_io_to_stop.inc
375 # Stopped IO thread after queuing the following event (#8):
376 include/show_relaylog_events.inc
377 Log_name Pos Event_type Server_id End_log_pos Info
378 slave-relay-bin.000003 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
379 include/rpl_stop_server.inc [server_number=2]
380 # Restoring a master.info.backup to start asking events at event #13
381 include/rpl_start_server.inc [server_number=2]
382 include/start_slave_io.inc
383 include/sync_slave_io_with_master.inc
384 # Restarted queuing the following event (#13):
385 include/show_relaylog_events.inc
386 Log_name Pos Event_type Server_id End_log_pos Info
387 slave-relay-bin.000005 # Xid # # COMMIT /* XID */
388 include/assert_grep.inc [Case 7.a found the expected warning line in the error log.]
389
390 #
391 # Case 7.b: QUERY(COMMIT or ROLLBACK) or XID_LOG_EVENT is not expected in an event stream after a GTID_LOG_EVENT.
392 #
393 # Cleaning up and reseting the slave
394 include/stop_slave.inc
395 Warnings:
396 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
397 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
398 START SLAVE IO_THREAD;
399 Warnings:
400 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
401 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
402 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
403 include/wait_for_slave_io_to_stop.inc
404 # Stopped IO thread after queuing the following event (#8):
405 include/show_relaylog_events.inc
406 Log_name Pos Event_type Server_id End_log_pos Info
407 slave-relay-bin.000003 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
408 include/rpl_stop_server.inc [server_number=2]
409 # Restoring a master.info.backup to start asking events at event #19
410 include/rpl_start_server.inc [server_number=2]
411 include/start_slave_io.inc
412 include/sync_slave_io_with_master.inc
413 # Restarted queuing the following event (#19):
414 include/show_relaylog_events.inc
415 Log_name Pos Event_type Server_id End_log_pos Info
416 slave-relay-bin.000005 # Query # # COMMIT
417 include/assert_grep.inc [Case 7.b found the expected warning line in the error log.]
418
419 #
420 # Case 8.a: QUERY(COMMIT or ROLLBACK) or XID_LOG_EVENT is not expected in an event stream in the middle of a DDL.
421 #
422 # Cleaning up and reseting the slave
423 include/stop_slave.inc
424 Warnings:
425 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
426 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
427 START SLAVE IO_THREAD;
428 Warnings:
429 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
430 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
431 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
432 include/wait_for_slave_io_to_stop.inc
433 # Stopped IO thread after queuing the following event (#6):
434 include/show_relaylog_events.inc
435 Log_name Pos Event_type Server_id End_log_pos Info
436 slave-relay-bin.000003 # User var # # @`var`=10
437 include/rpl_stop_server.inc [server_number=2]
438 # Restoring a master.info.backup to start asking events at event #13
439 include/rpl_start_server.inc [server_number=2]
440 include/start_slave_io.inc
441 include/sync_slave_io_with_master.inc
442 # Restarted queuing the following event (#13):
443 include/show_relaylog_events.inc
444 Log_name Pos Event_type Server_id End_log_pos Info
445 slave-relay-bin.000005 # Xid # # COMMIT /* XID */
446 include/assert_grep.inc [Case 8.a found the expected warning line in the error log.]
447
448 #
449 # Case 8.b: QUERY(COMMIT or ROLLBACK) or XID_LOG_EVENT is not expected in an event stream in the middle of a DDL.
450 #
451 # Cleaning up and reseting the slave
452 include/stop_slave.inc
453 Warnings:
454 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
455 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
456 START SLAVE IO_THREAD;
457 Warnings:
458 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
459 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
460 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
461 include/wait_for_slave_io_to_stop.inc
462 # Stopped IO thread after queuing the following event (#6):
463 include/show_relaylog_events.inc
464 Log_name Pos Event_type Server_id End_log_pos Info
465 slave-relay-bin.000003 # User var # # @`var`=10
466 include/rpl_stop_server.inc [server_number=2]
467 # Restoring a master.info.backup to start asking events at event #19
468 include/rpl_start_server.inc [server_number=2]
469 include/start_slave_io.inc
470 include/sync_slave_io_with_master.inc
471 # Restarted queuing the following event (#19):
472 include/show_relaylog_events.inc
473 Log_name Pos Event_type Server_id End_log_pos Info
474 slave-relay-bin.000005 # Query # # COMMIT
475 include/assert_grep.inc [Case 8.b found the expected warning line in the error log.]
476
477 #
478 # Case 9.a: QUERY(XA ROLLBACK) is not expected in an event stream in the middle of a DDL.
479 #
480 # Cleaning up and reseting the slave
481 include/stop_slave.inc
482 Warnings:
483 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
484 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
485 START SLAVE IO_THREAD;
486 Warnings:
487 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
488 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
489 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
490 include/wait_for_slave_io_to_stop.inc
491 # Stopped IO thread after queuing the following event (#6):
492 include/show_relaylog_events.inc
493 Log_name Pos Event_type Server_id End_log_pos Info
494 slave-relay-bin.000003 # User var # # @`var`=10
495 include/rpl_stop_server.inc [server_number=2]
496 # Restoring a master.info.backup to start asking events at event #26
497 include/rpl_start_server.inc [server_number=2]
498 include/start_slave_io.inc
499 include/sync_slave_io_with_master.inc
500 # Restarted queuing the following event (#26):
501 include/show_relaylog_events.inc
502 Log_name Pos Event_type Server_id End_log_pos Info
503 slave-relay-bin.000005 # Query # # XA ROLLBACK X'78615f747278',X'',1
504 include/assert_grep.inc [Case 9.a found the expected warning line in the error log.]
505
506 #
507 # Case 9.b: QUERY(XA ROLLBACK) is not expected in an event stream outside a transaction.
508 #
509 # Cleaning up and reseting the slave
510 include/stop_slave.inc
511 Warnings:
512 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
513 # Adding debug point 'pause_on_queuing_event' to @@GLOBAL.debug
514 START SLAVE IO_THREAD;
515 Warnings:
516 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
517 # Removing debug point 'pause_on_queuing_event' from @@GLOBAL.debug
518 # Adding debug point 'stop_io_after_queuing_event' to @@GLOBAL.debug
519 include/wait_for_slave_io_to_stop.inc
520 # Stopped IO thread after queuing the following event (#9):
521 include/show_relaylog_events.inc
522 Log_name Pos Event_type Server_id End_log_pos Info
523 slave-relay-bin.000003 # Query # # use `test`; CREATE TABLE t1 (c1 INT) ENGINE= InnoDB
524 include/rpl_stop_server.inc [server_number=2]
525 # Restoring a master.info.backup to start asking events at event #26
526 include/rpl_start_server.inc [server_number=2]
527 include/start_slave_io.inc
528 include/sync_slave_io_with_master.inc
529 # Restarted queuing the following event (#26):
530 include/show_relaylog_events.inc
531 Log_name Pos Event_type Server_id End_log_pos Info
532 slave-relay-bin.000005 # Query # # XA ROLLBACK X'78615f747278',X'',1
533 include/assert_grep.inc [Case 9.b found the expected warning line in the error log.]
534
535 #
536 # Prepare the slave to correctly replicate again after the test case
537 #
538 include/rpl_stop_server.inc [server_number=2]
539 include/rpl_start_server.inc [server_number=2]
540 [connection slave]
541 include/stop_slave.inc
542 Warnings:
543 Note 3084 Replication thread(s) for channel '' are already stopped.
544 DROP TABLE IF EXISTS t1, t2;
545 RESET MASTER;
546 RESET SLAVE;
547 Warnings:
548 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
549 include/start_slave.inc
550 [connection master]
551 DROP TABLE t1, t2;
552 DROP EVENT ev1;
553 include/rpl_end.inc