Debian Codegraph @

mysql-test/suite/rpl/t/rpl_upgrade_master_info.test

raw
1 --source include/master-slave.inc
2
3 --echo *** MDEV-9383: Server fails to read master.info after upgrade 10.0 -> 10.1 ***
4
5 --connection slave
6 --source include/stop_slave.inc
7 --let $datadir= `SELECT @@datadir`
8
9 --let $rpl_server_number= 2
10 --source include/rpl_stop_server.inc
11
12 --remove_file $datadir/master.info
13 --copy_file $MYSQL_TEST_DIR/std_data/bad_master.info $datadir/master.info
14
15 --let $rpl_server_number= 2
16 --source include/rpl_start_server.inc
17
18 --source include/wait_until_connected_again.inc
19
20 --connection master
21 CREATE TABLE t1 (a INT PRIMARY KEY);
22 INSERT INTO t1 VALUES (1);
23 --source include/save_master_gtid.inc
24
25 --connection slave
26 # Fix the port after we replaced master.info.
27 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
28 eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$SERVER_MYPORT_1;
29 --source include/start_slave.inc
30 --source include/sync_with_master_gtid.inc
31 FLUSH NO_WRITE_TO_BINLOG TABLES;
32 SELECT * FROM t1;
33
34 --source include/stop_slave.inc
35
36 --let $rpl_server_number= 2
37 --source include/rpl_stop_server.inc
38
39 --remove_file $datadir/master.info
40 --copy_file $MYSQL_TEST_DIR/std_data/bad2_master.info $datadir/master.info
41
42 --let $rpl_server_number= 2
43 --source include/rpl_start_server.inc
44
45 --source include/wait_until_connected_again.inc
46
47 --connection master
48 INSERT INTO t1 VALUES (2);
49 --source include/save_master_gtid.inc
50
51 --connection slave
52 # Fix the port after we replaced master.info.
53 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
54 eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$SERVER_MYPORT_1;
55 --source include/start_slave.inc
56 --source include/sync_with_master_gtid.inc
57 FLUSH NO_WRITE_TO_BINLOG TABLES;
58 SELECT * FROM t1 ORDER BY a;
59
60 --source include/stop_slave.inc
61
62 --let $rpl_server_number= 2
63 --source include/rpl_stop_server.inc
64
65 --remove_file $datadir/master.info
66 --copy_file $MYSQL_TEST_DIR/std_data/bad3_master.info $datadir/master.info
67
68 --let $rpl_server_number= 2
69 --source include/rpl_start_server.inc
70
71 --source include/wait_until_connected_again.inc
72
73 --connection master
74 INSERT INTO t1 VALUES (3);
75 --source include/save_master_gtid.inc
76
77 --connection slave
78 # Fix the port after we replaced master.info.
79 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
80 eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$SERVER_MYPORT_1;
81 --source include/start_slave.inc
82 --source include/sync_with_master_gtid.inc
83 FLUSH NO_WRITE_TO_BINLOG TABLES;
84 SELECT * FROM t1 ORDER BY a;
85
86 --source include/stop_slave.inc
87
88 --let $rpl_server_number= 2
89 --source include/rpl_stop_server.inc
90
91 --remove_file $datadir/master.info
92 --copy_file $MYSQL_TEST_DIR/std_data/bad4_master.info $datadir/master.info
93
94 --let $rpl_server_number= 2
95 --source include/rpl_start_server.inc
96
97 --source include/wait_until_connected_again.inc
98
99 --connection master
100 INSERT INTO t1 VALUES (4);
101 --source include/save_master_gtid.inc
102
103 --connection slave
104 # Fix the port after we replaced master.info.
105 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
106 eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$SERVER_MYPORT_1;
107 --source include/start_slave.inc
108 --source include/sync_with_master_gtid.inc
109 FLUSH NO_WRITE_TO_BINLOG TABLES;
110 SELECT * FROM t1 ORDER BY a;
111
112 --source include/stop_slave.inc
113
114 --let $rpl_server_number= 2
115 --source include/rpl_stop_server.inc
116
117 --remove_file $datadir/master.info
118 --copy_file $MYSQL_TEST_DIR/std_data/bad5_master.info $datadir/master.info
119
120 --let $rpl_server_number= 2
121 --source include/rpl_start_server.inc
122
123 --source include/wait_until_connected_again.inc
124
125 --connection master
126 INSERT INTO t1 VALUES (5);
127 --source include/save_master_gtid.inc
128
129 --connection slave
130 # Fix the port after we replaced master.info.
131 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
132 eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$SERVER_MYPORT_1;
133 --source include/start_slave.inc
134 --source include/sync_with_master_gtid.inc
135 FLUSH NO_WRITE_TO_BINLOG TABLES;
136 SELECT * FROM t1 ORDER BY a;
137
138 --source include/stop_slave.inc
139
140 --let $rpl_server_number= 2
141 --source include/rpl_stop_server.inc
142
143 --remove_file $datadir/master.info
144 --copy_file $MYSQL_TEST_DIR/std_data/bad6_master.info $datadir/master.info
145
146 --let $rpl_server_number= 2
147 --source include/rpl_start_server.inc
148
149 --source include/wait_until_connected_again.inc
150
151 --connection master
152 INSERT INTO t1 VALUES (6);
153 --source include/save_master_gtid.inc
154
155 --connection slave
156 # Fix the port after we replaced master.info.
157 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1
158 eval CHANGE MASTER TO master_host='127.0.0.1', master_port=$SERVER_MYPORT_1, MASTER_SSL=1;
159 --source include/start_slave.inc
160 --source include/sync_with_master_gtid.inc
161 SELECT * FROM t1 ORDER BY a;
162
163
164 # Cleanup
165 --connection master
166 DROP TABLE t1;
167 --source include/rpl_end.inc