Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 SET @@SESSION.gtid_domain_id=0;
5 CREATE TABLE t (a INT);
6 connection slave;
7 connection slave;
8 call mtr.add_suppression("connecting slave requested to start from.*which is not in the master's binlog");
9 include/stop_slave.inc
10 CHANGE MASTER TO master_use_gtid=slave_pos;
11 connection master;
12 SET @@SESSION.gtid_domain_id=11;
13 SET @@SESSION.server_id=111;
14 SET @@SESSION.gtid_seq_no=1;
15 INSERT INTO t SET a=1;
16 connection slave;
17 SET @save.gtid_slave_pos=@@global.gtid_slave_pos;
18 SET @@global.gtid_slave_pos=concat(@@global.gtid_slave_pos, ",", 11, "-", 111, "-", 1 + 1);
19 Warnings:
20 Warning 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
21 START SLAVE IO_THREAD;
22 include/wait_for_slave_io_error.inc [errno=1236]
23 connection master;
24 FLUSH BINARY LOGS;
25 include/wait_for_purge.inc "master-bin.000002"
26 FLUSH BINARY LOGS DELETE_DOMAIN_ID=(11);
27 SELECT @@global.gtid_binlog_pos, @@global.gtid_binlog_state;
28 @@global.gtid_binlog_pos @@global.gtid_binlog_state
29 0-1-1 0-1-1
30 connection slave;
31 SELECT @@global.gtid_slave_pos;
32 @@global.gtid_slave_pos
33 0-1-1,11-111-2
34 include/start_slave.inc
35 ==== BEGIN include/start_slave.inc ====
36 con='slave' warn='1' qlog='1' rlog='1' aborterr='1'
37 START 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'
44 Waiting 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'
55 Waiting until 'Slave_SQL_Running' = 'Yes' [$slave_error_param='']
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'
68 connection master;
69 INSERT INTO t SET a=1;
70 connection slave;
71 include/wait_for_slave_io_error.inc [errno=1236]
72 connection master;
73 FLUSH BINARY LOGS;
74 PURGE BINARY LOGS TO 'master-bin.000004';;
75 FLUSH BINARY LOGS DELETE_DOMAIN_ID=(11);
76 connection slave;
77 include/start_slave.inc
78 connection master;
79 SET @@SESSION.gtid_domain_id=0;
80 DROP TABLE t;
81 connection slave;
82 include/rpl_end.inc