Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_gtid_mode.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("Replica I/O for channel '': The replication receiver thread cannot start");
8 call mtr.add_suppression("Replica I/O for channel '': The replica IO thread stops");
9 call mtr.add_suppression("Replica I/O for channel '': Got fatal error 1236 from source when reading data from binary log: 'Cannot replicate GTID-transaction when @@GLOBAL.GTID_MODE = OFF");
10 call mtr.add_suppression("Replica I/O for channel '': Cannot replicate GTID-transaction when @@GLOBAL.GTID_MODE = OFF");
11 call mtr.add_suppression("GTID_LOG_EVENT or ANONYMOUS_GTID_LOG_EVENT is not expected in an event stream after a GTID_LOG_EVENT or an ANONYMOUS_GTID_LOG_EVENT.");
12 call mtr.add_suppression("An unexpected event sequence was detected by the IO thread while queuing the event received from source");
13 call mtr.add_suppression("Detected misconfiguration: replication channel '' was configured with AUTO_POSITION = 1, but the server was started with --gtid-mode=off.");
14 call mtr.add_suppression("Replica I/O for channel '': Relay log write failure: could not queue event from source");
15 call mtr.add_suppression("Got fatal error 1236 from source when reading data from binary log: 'Cannot replicate anonymous transaction when @@GLOBAL.GTID_MODE = ON");
16 call mtr.add_suppression("Replica I/O for channel '': Cannot replicate anonymous transaction when @@GLOBAL.GTID_MODE = ON");
17 call mtr.add_suppression("Replica I/O for channel '': Cannot replicate anonymous transaction when AUTO_POSITION = 1");
18 call mtr.add_suppression("Got fatal error 1236 from source when reading data from binary log: 'Cannot replicate anonymous transaction when AUTO_POSITION = 1,");
19 call mtr.add_suppression("Replica I/O for channel '': The source uses an unknown GTID_MODE 'on_something'. Treating it as 'ON'.");
20 call mtr.add_suppression("Replica I/O for channel '': The source uses an unknown GTID_MODE 'off_something'. Treating it as 'OFF'.");
21 call mtr.add_suppression("Could not open .* for logging.*. Turning logging off for the whole duration of the MySQL server process.");
22 include/sync_slave_sql_with_master.inc
23 include/stop_slave.inc
24 ==== Checks performed at server start ====
25 ---- gtid-mode=ON requires enforce-gtid-consistency ----
26 include/rpl_stop_server.inc [server_number=2]
27 include/assert_command_output.inc
28 include/rpl_start_server.inc [server_number=2 gtids=off]
29 ==== Master-slave handshake checks ====
30 [connection master]
31 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
32 [connection slave]
33 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
34 include/rpl_set_gtid_mode.inc [0 on servers 1]
35 include/rpl_set_gtid_mode.inc [0 on servers 2]
36 START SLAVE IO_THREAD;
37 Warnings:
38 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
39 include/wait_for_slave_io_to_start.inc
40 include/stop_slave_io.inc
41 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
42 ERROR HY000: CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1 cannot be executed because @@GLOBAL.GTID_MODE = OFF.
43 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
44 include/rpl_set_gtid_mode.inc [1 on servers 2]
45 START SLAVE IO_THREAD;
46 Warnings:
47 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
48 include/wait_for_slave_io_to_start.inc
49 include/stop_slave_io.inc
50 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
51 START SLAVE IO_THREAD;
52 Warnings:
53 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
54 include/wait_for_slave_io_error.inc [errno=13117]
55 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
56 include/rpl_set_gtid_mode.inc [2 on servers 2]
57 START SLAVE IO_THREAD;
58 Warnings:
59 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
60 include/wait_for_slave_io_to_start.inc
61 include/stop_slave_io.inc
62 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
63 START SLAVE IO_THREAD;
64 Warnings:
65 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
66 include/wait_for_slave_io_error.inc [errno=13117]
67 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
68 include/rpl_set_gtid_mode.inc [3 on servers 2]
69 START SLAVE IO_THREAD;
70 Warnings:
71 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
72 include/wait_for_slave_io_error.inc [errno=13117]
73 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
74 START SLAVE IO_THREAD;
75 Warnings:
76 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
77 include/wait_for_slave_io_error.inc [errno=13117]
78 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
79 include/rpl_set_gtid_mode.inc [1 on servers 1]
80 include/rpl_set_gtid_mode.inc [0 on servers 2]
81 START SLAVE IO_THREAD;
82 Warnings:
83 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
84 include/wait_for_slave_io_to_start.inc
85 include/stop_slave_io.inc
86 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
87 ERROR HY000: CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1 cannot be executed because @@GLOBAL.GTID_MODE = OFF.
88 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
89 include/rpl_set_gtid_mode.inc [1 on servers 2]
90 START SLAVE IO_THREAD;
91 Warnings:
92 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
93 include/wait_for_slave_io_to_start.inc
94 include/stop_slave_io.inc
95 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
96 START SLAVE IO_THREAD;
97 Warnings:
98 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
99 include/wait_for_slave_io_error.inc [errno=13117]
100 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
101 include/rpl_set_gtid_mode.inc [2 on servers 2]
102 START SLAVE IO_THREAD;
103 Warnings:
104 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
105 include/wait_for_slave_io_to_start.inc
106 include/stop_slave_io.inc
107 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
108 START SLAVE IO_THREAD;
109 Warnings:
110 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
111 include/wait_for_slave_io_error.inc [errno=13117]
112 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
113 include/rpl_set_gtid_mode.inc [3 on servers 2]
114 START SLAVE IO_THREAD;
115 Warnings:
116 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
117 include/wait_for_slave_io_error.inc [errno=13117]
118 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
119 START SLAVE IO_THREAD;
120 Warnings:
121 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
122 include/wait_for_slave_io_error.inc [errno=13117]
123 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
124 include/rpl_set_gtid_mode.inc [2 on servers 1]
125 include/rpl_set_gtid_mode.inc [0 on servers 2]
126 START SLAVE IO_THREAD;
127 Warnings:
128 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
129 include/wait_for_slave_io_error.inc [errno=13117]
130 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
131 ERROR HY000: CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1 cannot be executed because @@GLOBAL.GTID_MODE = OFF.
132 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
133 include/rpl_set_gtid_mode.inc [1 on servers 2]
134 START SLAVE IO_THREAD;
135 Warnings:
136 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
137 include/wait_for_slave_io_to_start.inc
138 include/stop_slave_io.inc
139 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
140 START SLAVE IO_THREAD;
141 Warnings:
142 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
143 include/wait_for_slave_io_error.inc [errno=13117]
144 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
145 include/rpl_set_gtid_mode.inc [2 on servers 2]
146 START SLAVE IO_THREAD;
147 Warnings:
148 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
149 include/wait_for_slave_io_to_start.inc
150 include/stop_slave_io.inc
151 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
152 START SLAVE IO_THREAD;
153 Warnings:
154 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
155 include/wait_for_slave_io_error.inc [errno=13117]
156 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
157 include/rpl_set_gtid_mode.inc [3 on servers 2]
158 START SLAVE IO_THREAD;
159 Warnings:
160 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
161 include/wait_for_slave_io_to_start.inc
162 include/stop_slave_io.inc
163 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
164 START SLAVE IO_THREAD;
165 Warnings:
166 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
167 include/wait_for_slave_io_error.inc [errno=13117]
168 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
169 include/rpl_set_gtid_mode.inc [3 on servers 1]
170 include/rpl_set_gtid_mode.inc [0 on servers 2]
171 START SLAVE IO_THREAD;
172 Warnings:
173 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
174 include/wait_for_slave_io_error.inc [errno=13117]
175 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
176 ERROR HY000: CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1 cannot be executed because @@GLOBAL.GTID_MODE = OFF.
177 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
178 include/rpl_set_gtid_mode.inc [1 on servers 2]
179 START SLAVE IO_THREAD;
180 Warnings:
181 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
182 include/wait_for_slave_io_to_start.inc
183 include/stop_slave_io.inc
184 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
185 START SLAVE IO_THREAD;
186 Warnings:
187 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
188 include/wait_for_slave_io_to_start.inc
189 include/stop_slave_io.inc
190 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
191 include/rpl_set_gtid_mode.inc [2 on servers 2]
192 START SLAVE IO_THREAD;
193 Warnings:
194 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
195 include/wait_for_slave_io_to_start.inc
196 include/stop_slave_io.inc
197 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
198 START SLAVE IO_THREAD;
199 Warnings:
200 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
201 include/wait_for_slave_io_to_start.inc
202 include/stop_slave_io.inc
203 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
204 include/rpl_set_gtid_mode.inc [3 on servers 2]
205 START SLAVE IO_THREAD;
206 Warnings:
207 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
208 include/wait_for_slave_io_to_start.inc
209 include/stop_slave_io.inc
210 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
211 START SLAVE IO_THREAD;
212 Warnings:
213 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
214 include/wait_for_slave_io_to_start.inc
215 include/stop_slave_io.inc
216 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
217 #
218 # Test for ER_CANT_REPLICATE_GTID_WITH_GTID_MODE_OFF
219 # eng "Cannot replicate GTID-transaction when GTID_MODE = OFF, at file %.512s, position %lld. Found a Gtid_log_event when @@GLOBAL.GTID_MODE = OFF.
220 #
221 #
222 # Case 1: Error on Master(sender thread)
223 #
224 include/rpl_set_gtid_mode.inc [ON on servers 1]
225 [connection master]
226 CREATE TABLE t1 (a int);
227 include/rpl_set_gtid_mode.inc [OFF on servers 1,2]
228 [connection slave]
229 START SLAVE IO_THREAD;
230 Warnings:
231 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
232 include/wait_for_slave_io_error.inc [errno=13114 # ER_CANT_REPLICATE_GTID_WITH_GTID_MODE_OFF]
233 include/assert.inc [sender thread should report - Cannot replicate GTID-transaction when @@GLOBAL.GTID_MODE = OFF.]
234 include/assert_grep.inc [Receiver thread should report - Cannot replicate GTID-transaction when @@GLOBAL.GTID_MODE = OFF.]
235 [connection master]
236 DROP TABLE t1;
237 RESET MASTER;
238 [connection slave]
239 RESET SLAVE;
240 Warnings:
241 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
242 #
243 # Case 2: Error on Slave(receiver thread)
244 #
245 include/rpl_set_gtid_mode.inc [ON on servers 1,2]
246 [connection slave]
247 include/start_slave.inc
248 include/rpl_set_gtid_mode.inc [OFF on servers 2]
249 [connection master]
250 CREATE TABLE t2(a int);
251 [connection slave]
252 include/wait_for_slave_io_error.inc [errno=13122 # ER_REPLICA_RELAY_LOG_WRITE_FAILURE]
253 include/assert_grep.inc [Receiver thread should report - Cannot replicate GTID-transaction when @@GLOBAL.GTID_MODE = OFF.]
254 [connection master]
255 DROP TABLE t2;
256 [connection slave]
257 include/rpl_set_gtid_mode.inc [ON on servers 2]
258 include/start_slave.inc
259 #
260 # Warning: "Detected misconfiguration: replication channel '%.192s' was configured with AUTO_POSITION = 1, but the server was started with --gtid-mode=off. Either reconfigure replication using CHANGE MASTER TO MASTER_AUTO_POSITION = 0 FOR CHANNEL '%.192s', or change GTID_MODE to some value other than OFF, before starting the slave receiver thread."
261 #
262 include/rpl_set_gtid_mode.inc [ON on servers 1,2]
263 [connection slave]
264 include/stop_slave.inc
265 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
266 include/rpl_restart_server.inc [server_number=2 gtids=off]
267 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
268 include/assert_grep.inc [While AUTO_POSITION is set, attempt to restart the slave with gtid-mode= off to get ER_STARTING_WITH_GTID_MODE_OFF_AND_AUTO_POSITION.]
269 #
270 # ER_CANT_USE_AUTO_POSITION_WITH_GTID_MODE_OFF
271 # eng "The replication receiver thread for channel '%s' cannot start in AUTO_POSITION mode: this server uses GTID_MODE = OFF."
272 #
273 START SLAVE IO_THREAD;
274 ERROR HY000: The replication receiver thread for channel '' cannot start in AUTO_POSITION mode: this server uses @@GLOBAL.GTID_MODE = OFF.
275 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
276 #
277 # ER_CANT_REPLICATE_ANONYMOUS_WITH_GTID_MODE_ON
278 # eng "Cannot replicate anonymous transaction when GTID_MODE = ON, at file %.512s, position %lld."
279 #
280 # Case 1: Error on master(sender thread)
281 #
282 include/rpl_set_gtid_mode.inc [OFF on servers 1]
283 [connection master]
284 CREATE TABLE t3(a int);
285 include/rpl_set_gtid_mode.inc [ON on servers 1,2]
286 [connection slave]
287 START SLAVE IO_THREAD;
288 Warnings:
289 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
290 include/wait_for_slave_io_error.inc [errno=13114 # ER_CANT_REPLICATE_ANONYMOUS_WITH_GTID_MODE_ON]
291 include/assert.inc [sender thread should report - Cannot replicate anonymous transaction when @@GLOBAL.GTID_MODE = ON.]
292 include/assert_grep.inc [While gtid-mode=on, slave expects an anonymous event to get ER_CANT_REPLICATE_ANONYMOUS_WITH_GTID_MODE_ON.]
293 [connection master]
294 DROP TABLE t3;
295 include/rpl_reset.inc
296 Warnings:
297 Note 3084 Replication thread(s) for channel '' are already stopped.
298 #
299 # Case 2: Error on slave(receiver thread)
300 #
301 include/rpl_set_gtid_mode.inc [OFF on servers 1]
302 [connection master]
303 CREATE TABLE t4(a int);
304 [connection slave]
305 include/wait_for_slave_io_error.inc [errno=13122 # ER_REPLICA_RELAY_LOG_WRITE_FAILURE]
306 include/assert_grep.inc [While gtid-mode=on, slave expects an anonymous event to get ER_CANT_REPLICATE_ANONYMOUS_WITH_GTID_MODE_ON.]
307 include/stop_slave_sql.inc
308 include/rpl_set_gtid_mode.inc [OFF on servers 2]
309 [connection master]
310 DROP TABLE t4;
311 RESET MASTER;
312 [connection slave]
313 RESET SLAVE;
314 Warnings:
315 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
316 include/start_slave.inc
317 [connection master]
318 include/sync_slave_sql_with_master.inc
319 #
320 # ER_CANT_REPLICATE_ANONYMOUS_WITH_AUTO_POSITION
321 # eng "Cannot replicate anonymous transaction when AUTO_POSITION = 1, at file %.512s, position %lld."
322 #
323 #
324 # Case 1: Error on master(sender thread).
325 #
326 include/rpl_set_gtid_mode.inc [ON on servers 1,2]
327 [connection master]
328 CREATE TABLE t5(a int);
329 include/sync_slave_sql_with_master.inc
330 include/stop_slave.inc
331 [connection master]
332 INSERT INTO t5 VALUES(2);
333 include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
334 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
335 INSERT INTO t5 VALUES(1);
336 include/rpl_set_gtid_mode.inc [ON on servers 1]
337 include/rpl_set_gtid_mode.inc [ON on servers 2]
338 [connection slave]
339 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
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 include/wait_for_slave_io_error.inc [errno=13114 # ER_CANT_REPLICATE_ANONYMOUS_WITH_AUTO_POSITION]
344 include/assert.inc [sender thread should report - Cannot replicate anonymous transaction when AUTO_POSITION = 1.]
345 include/assert_grep.inc [While AUTO_POSITION is enabled, Master sends an anonymous transaction resulting into ER_CANT_REPLICATE_ANONYMOUS_WITH_AUTO_POSITION.]
346 include/rpl_restart_server.inc [server_number=1 gtids=off]
347 [connection master]
348 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
349 [connection slave]
350 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
351 include/rpl_set_gtid_mode.inc [OFF on servers 2]
352 [connection master]
353 DROP TABLE t5;
354 RESET MASTER;
355 [connection slave]
356 DROP TABLE t5;
357 RESET SLAVE;
358 Warnings:
359 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
360 include/start_slave.inc
361 [connection master]
362 include/sync_slave_sql_with_master.inc
363 #
364 # Case 2: Error on Slave(receiver thread).
365 #
366 [connection master]
367 SET @debug_saved= @@GLOBAL.DEBUG;
368 SET GLOBAL DEBUG= "+d,skip_sender_anon_autoposition_error";
369 include/rpl_set_gtid_mode.inc [ON on servers 1,2]
370 [connection master]
371 CREATE TABLE t6(a int);
372 include/sync_slave_sql_with_master.inc
373 include/stop_slave.inc
374 [connection master]
375 INSERT INTO t6 VALUES(2);
376 include/rpl_set_gtid_mode.inc [ON_PERMISSIVE on servers 1]
377 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
378 INSERT INTO t6 VALUES(1);
379 include/rpl_set_gtid_mode.inc [ON on servers 1]
380 include/rpl_set_gtid_mode.inc [ON on servers 2]
381 [connection slave]
382 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1;
383 START SLAVE IO_THREAD;
384 Warnings:
385 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
386 include/wait_for_slave_io_error.inc [errno=13122 # ER_REPLICA_RELAY_LOG_WRITE_FAILURE]
387 include/assert_grep.inc [While AUTO_POSITION is enabled, Master sends an anonymous transaction resulting into ER_CANT_REPLICATE_ANONYMOUS_WITH_AUTO_POSITION.]
388 [connection slave]
389 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
390 include/rpl_set_gtid_mode.inc [OFF on servers 1,2]
391 [connection master]
392 SET @@GLOBAL.DEBUG= @debug_saved;
393 SET DEBUG_SYNC= 'RESET';
394 DROP TABLE t6;
395 RESET MASTER;
396 [connection slave]
397 RESET SLAVE;
398 Warnings:
399 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
400 include/start_slave.inc
401 [connection master]
402 include/sync_slave_sql_with_master.inc
403 #
404 # Verify the behaviour when rotate fails while setting gtid_mode.
405 #
406 [connection slave]
407 include/start_slave.inc
408 Warnings:
409 Note 3083 Replication thread(s) for channel '' are already runnning.
410 [connection master]
411 call mtr.add_suppression("Could not open * for logging");
412 include/sync_slave_sql_with_master.inc
413 include/stop_slave.inc
414 SET @debug_saved= @@GLOBAL.DEBUG;
415 SET GLOBAL DEBUG= "+d,fault_injection_new_file_rotate_event";
416 SET GLOBAL binlog_error_action= IGNORE_ERROR;
417 SET @@GLOBAL.GTID_MODE= OFF_PERMISSIVE;
418 ERROR HY000: Error writing file 'slave-bin' (errno: 2 - No such file or directory)
419 SET @@GLOBAL.GTID_MODE= OFF;
420 SET @@GLOBAL.DEBUG= @debug_saved;
421 SET GLOBAL binlog_error_action= ABORT_SERVER;
422 include/rpl_restart_server.inc [server_number=1 gtids=off]
423 [connection master]
424 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
425 #
426 # ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON
427 # generated when re-acquiring anonymous ownership
428 #
429 [connection master]
430 SET GTID_NEXT='ANONYMOUS';
431 CREATE TABLE t7(a int);
432 include/rpl_set_gtid_mode.inc [ON on servers 1]
433 INSERT INTO t7 values (1);
434 ERROR HY000: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.
435 SET GTID_NEXT='AUTOMATIC';
436 DROP TABLE t7;
437 RESET MASTER;
438 include/rpl_set_gtid_mode.inc [OFF on servers 1]
439 #
440 # Error generated if master has an unknown gtid_mode
441 #
442 include/stop_slave.inc
443 Warnings:
444 Note 3084 Replication thread(s) for channel '' are already stopped.
445 RESET SLAVE;
446 Warnings:
447 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
448 SET @@GLOBAL.DEBUG= '+d,simulate_source_has_unknown_gtid_mode';
449 START SLAVE IO_THREAD;
450 Warnings:
451 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
452 include/wait_for_slave_io_error.inc [errno=13117]
453 Last_IO_Error = 'The replica IO thread stops because the source has an unknown @@GLOBAL.GTID_MODE 'Krakel Spektakel'.'
454 SET @@GLOBAL.DEBUG= @debug_saved;
455 SET @@GLOBAL.GTID_MODE = OFF_PERMISSIVE;
456 RESET SLAVE;
457 Warnings:
458 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
459 #
460 # ER_CANT_SET_GTID_MODE generated because AUTO_POSITION = 1.
461 #
462 include/rpl_set_gtid_mode.inc [ON on servers 1]
463 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1;
464 SET @@GLOBAL.GTID_MODE = OFF;
465 ERROR HY000: SET @@GLOBAL.GTID_MODE = OFF is not allowed because replication channel '' is configured in AUTO_POSITION mode. Execute CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0 FOR CHANNEL '' before you set @@GLOBAL.GTID_MODE = OFF..
466 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0;
467 SET @@GLOBAL.GTID_MODE = OFF;
468 include/rpl_set_gtid_mode.inc [OFF on servers 1]
469 [connection master]
470 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
471 [connection slave]
472 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
473 include/rpl_end.inc