1include/master-slave.inc
2[connection master]
3*** MDEV-9383: Server fails to read master.info after upgrade 10.0 -> 10.1 ***
4connection slave;
5include/stop_slave.inc
6CHANGE MASTER TO master_use_gtid=CURRENT_POS;
7include/rpl_stop_server.inc [server_number=2]
8include/rpl_start_server.inc [server_number=2]
9connection master;
10CREATE TABLE t1 (a INT PRIMARY KEY);
11INSERT INTO t1 VALUES (1);
12include/save_master_gtid.inc
13connection slave;
14CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
15include/start_slave.inc
16include/sync_with_master_gtid.inc
17FLUSH NO_WRITE_TO_BINLOG TABLES;
18SELECT * FROM t1;
19a
201
21include/stop_slave.inc
22include/rpl_stop_server.inc [server_number=2]
23include/rpl_start_server.inc [server_number=2]
24connection master;
25INSERT INTO t1 VALUES (2);
26include/save_master_gtid.inc
27connection slave;
28CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
29include/start_slave.inc
30include/sync_with_master_gtid.inc
31FLUSH NO_WRITE_TO_BINLOG TABLES;
32SELECT * FROM t1 ORDER BY a;
33a
341
352
36include/stop_slave.inc
37include/rpl_stop_server.inc [server_number=2]
38include/rpl_start_server.inc [server_number=2]
39connection master;
40INSERT INTO t1 VALUES (3);
41include/save_master_gtid.inc
42connection slave;
43CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
44include/start_slave.inc
45include/sync_with_master_gtid.inc
46FLUSH NO_WRITE_TO_BINLOG TABLES;
47SELECT * FROM t1 ORDER BY a;
48a
491
502
513
52include/stop_slave.inc
53include/rpl_stop_server.inc [server_number=2]
54include/rpl_start_server.inc [server_number=2]
55connection master;
56INSERT INTO t1 VALUES (4);
57include/save_master_gtid.inc
58connection slave;
59CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
60include/start_slave.inc
61include/sync_with_master_gtid.inc
62FLUSH NO_WRITE_TO_BINLOG TABLES;
63SELECT * FROM t1 ORDER BY a;
64a
651
662
673
684
69include/stop_slave.inc
70include/rpl_stop_server.inc [server_number=2]
71include/rpl_start_server.inc [server_number=2]
72connection master;
73INSERT INTO t1 VALUES (5);
74include/save_master_gtid.inc
75connection slave;
76CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
77include/start_slave.inc
78include/sync_with_master_gtid.inc
79FLUSH NO_WRITE_TO_BINLOG TABLES;
80SELECT * FROM t1 ORDER BY a;
81a
821
832
843
854
865
87include/stop_slave.inc
88include/rpl_stop_server.inc [server_number=2]
89include/rpl_start_server.inc [server_number=2]
90connection master;
91INSERT INTO t1 VALUES (6);
92include/save_master_gtid.inc
93connection slave;
94CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
95include/start_slave.inc
96include/sync_with_master_gtid.inc
97SELECT * FROM t1 ORDER BY a;
98a
991
1002
1013
1024
1035
1046
105connection master;
106DROP TABLE t1;
107include/rpl_end.inc
108