Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 *** MDEV-9383: Server fails to read master.info after upgrade 10.0 -> 10.1 ***
4 connection slave;
5 include/stop_slave.inc
6 include/rpl_stop_server.inc [server_number=2]
7 include/rpl_start_server.inc [server_number=2]
8 connection master;
9 CREATE TABLE t1 (a INT PRIMARY KEY);
10 INSERT INTO t1 VALUES (1);
11 include/save_master_gtid.inc
12 connection slave;
13 CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
14 include/start_slave.inc
15 include/sync_with_master_gtid.inc
16 FLUSH NO_WRITE_TO_BINLOG TABLES;
17 SELECT * FROM t1;
18 a
19 1
20 include/stop_slave.inc
21 include/rpl_stop_server.inc [server_number=2]
22 include/rpl_start_server.inc [server_number=2]
23 connection master;
24 INSERT INTO t1 VALUES (2);
25 include/save_master_gtid.inc
26 connection slave;
27 CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
28 include/start_slave.inc
29 include/sync_with_master_gtid.inc
30 FLUSH NO_WRITE_TO_BINLOG TABLES;
31 SELECT * FROM t1 ORDER BY a;
32 a
33 1
34 2
35 include/stop_slave.inc
36 include/rpl_stop_server.inc [server_number=2]
37 include/rpl_start_server.inc [server_number=2]
38 connection master;
39 INSERT INTO t1 VALUES (3);
40 include/save_master_gtid.inc
41 connection slave;
42 CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
43 include/start_slave.inc
44 include/sync_with_master_gtid.inc
45 FLUSH NO_WRITE_TO_BINLOG TABLES;
46 SELECT * FROM t1 ORDER BY a;
47 a
48 1
49 2
50 3
51 include/stop_slave.inc
52 include/rpl_stop_server.inc [server_number=2]
53 include/rpl_start_server.inc [server_number=2]
54 connection master;
55 INSERT INTO t1 VALUES (4);
56 include/save_master_gtid.inc
57 connection slave;
58 CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
59 include/start_slave.inc
60 include/sync_with_master_gtid.inc
61 FLUSH NO_WRITE_TO_BINLOG TABLES;
62 SELECT * FROM t1 ORDER BY a;
63 a
64 1
65 2
66 3
67 4
68 include/stop_slave.inc
69 include/rpl_stop_server.inc [server_number=2]
70 include/rpl_start_server.inc [server_number=2]
71 connection master;
72 INSERT INTO t1 VALUES (5);
73 include/save_master_gtid.inc
74 connection slave;
75 CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1;
76 include/start_slave.inc
77 include/sync_with_master_gtid.inc
78 FLUSH NO_WRITE_TO_BINLOG TABLES;
79 SELECT * FROM t1 ORDER BY a;
80 a
81 1
82 2
83 3
84 4
85 5
86 include/stop_slave.inc
87 include/rpl_stop_server.inc [server_number=2]
88 include/rpl_start_server.inc [server_number=2]
89 connection master;
90 INSERT INTO t1 VALUES (6);
91 include/save_master_gtid.inc
92 connection slave;
93 CHANGE MASTER TO master_host='127.0.0.1', master_port=SERVER_MYPORT_1, MASTER_SSL=1;
94 include/start_slave.inc
95 include/sync_with_master_gtid.inc
96 SELECT * FROM t1 ORDER BY a;
97 a
98 1
99 2
100 3
101 4
102 5
103 6
104 connection master;
105 DROP TABLE t1;
106 include/rpl_end.inc