1include/master-slave.inc 2[connection master] 3connection master; 4SET @@SESSION.gtid_domain_id=0; 5CREATE TABLE t (a INT); 6connection slave; 7connection slave; 8call mtr.add_suppression("connecting slave requested to start from.*which is not in the master's binlog"); 9include/stop_slave.inc 10CHANGE MASTER TO master_use_gtid=slave_pos; 11connection master; 12SET @@SESSION.gtid_domain_id=11; 13SET @@SESSION.server_id=111; 14SET @@SESSION.gtid_seq_no=1; 15INSERT INTO t SET a=1; 16connection slave; 17SET @save.gtid_slave_pos=@@global.gtid_slave_pos; 18SET @@global.gtid_slave_pos=concat(@@global.gtid_slave_pos, ",", 11, "-", 111, "-", 1 + 1); 19Warnings: 20Warning 1947 Specified GTID 0-1-1 conflicts with the binary log which contains a more recent GTID 0-2-2. If MASTER_GTID_POS=CURRENT_POS is used, the binlog position will override the new value of @@gtid_slave_pos 21START SLAVE IO_THREAD; 22include/wait_for_slave_io_error.inc [errno=1236] 23connection master; 24FLUSH BINARY LOGS; 25include/wait_for_purge.inc "master-bin.000002" 26FLUSH BINARY LOGS DELETE_DOMAIN_ID=(11); 27SELECT @@global.gtid_binlog_pos, @@global.gtid_binlog_state; 28@@global.gtid_binlog_pos @@global.gtid_binlog_state 290-1-1 0-1-1 30connection slave; 31SELECT @@global.gtid_slave_pos; 32@@global.gtid_slave_pos 330-1-1,11-111-2 34include/start_slave.inc 35==== BEGIN include/start_slave.inc ==== 36 con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 37START SLAVE; 38.==== BEGIN include/wait_for_slave_to_start.inc ==== 39. con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 40..==== BEGIN include/wait_for_slave_io_to_start.inc ==== 41.. con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 42...==== BEGIN include/wait_for_slave_param.inc [Slave_IO_Running] ==== 43... con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 44Waiting until 'Slave_IO_Running' = 'Yes' [$slave_error_param='Last_IO_Errno'] 45[connection slave] 46...==== END include/wait_for_slave_param.inc [Slave_IO_Running] ==== 47... con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 48[connection slave] 49..==== END include/wait_for_slave_io_to_start.inc ==== 50.. con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 51..==== BEGIN include/wait_for_slave_sql_to_start.inc ==== 52.. con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 53...==== BEGIN include/wait_for_slave_param.inc [Slave_SQL_Running] ==== 54... con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 55Waiting until 'Slave_SQL_Running' = 'Yes' [$slave_error_param='1'] 56[connection slave] 57...==== END include/wait_for_slave_param.inc [Slave_SQL_Running] ==== 58... con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 59[connection slave] 60..==== END include/wait_for_slave_sql_to_start.inc ==== 61.. con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 62[connection slave] 63.==== END include/wait_for_slave_to_start.inc ==== 64. con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 65[connection slave] 66==== END include/start_slave.inc ==== 67 con='slave' warn='1' qlog='1' rlog='1' aborterr='1' 68connection master; 69INSERT INTO t SET a=1; 70connection slave; 71include/wait_for_slave_io_error.inc [errno=1236] 72connection master; 73FLUSH BINARY LOGS; 74PURGE BINARY LOGS TO 'master-bin.000004';; 75FLUSH BINARY LOGS DELETE_DOMAIN_ID=(11); 76connection slave; 77include/start_slave.inc 78connection master; 79SET @@SESSION.gtid_domain_id=0; 80DROP TABLE t; 81connection slave; 82include/rpl_end.inc 83