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