Debian Codegraph @

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

raw
1 # === Purpose ===
2 #
3 # This test ensures that replication is successful when slave server is
4 # initialized by providing server-id and started without providing server-id
5 # In this scenario, START SLAVE failed and fix of Bug#26730000 solved the issue
6 #
7 # The test also verifies the behaviour when server-id provided during
8 # server initialization is different from that given during starting server
9 #
10 # The test also verifies that proper error is thrown on attempting to configure
11 # replication on a server whose server-id is set to 0
12 #
13 # The test also verifies that attempting to configure replication between two
14 # servers having same server-id fails
15 #
16 # === Implementation ===
17 #
18 # 0. Start two servers server-1(master) and server-2(slave) in replication
19 # 1. Stop server-2 (slave)
20 # 2. Initialize server-2 by specifying server id to a new data directory
21 # 3. Start server-2 without specifying server id and enable replication between
22 # server-1 and server-2
23 # Verify that starting slave works and data is replicated from master to slave
24 # 4. Stop server-2 and initialize server-2 by specifying server-id=0 to a
25 # new data directory
26 # 5. Start server-2 by specifying a non-zero server-id, enable replication
27 # between server-1 and server-2 and verify replication works fine
28 # 6. Stop server-2 and initialize server-2 by specifying a non-zero server-id
29 # to a new data directory
30 # 7. Start server-2 by specifying server-id=0
31 # Try to enable replication between server-1 and server-2 and verify that
32 # proper error is thrown since server-id is set to 0
33 # 8. Stop server-2 and initialize server-2 by specifying server-id=1
34 # to a new data directory
35 # 9. Start server-2 by specifying server-id=1
36 # Try to enable replication between server-1 and server-2 and verify that
37 # proper error is thrown since master and slave have same server-id set
38 # 10. Restart server-2 with its original data directory
39 # 11. Clean up
40
41 # === References ===
42 #
43 # BUG#26730000 : SERVER_ID LOOKS SET TO VALID VALUE STILL START SLAVE FAILS WITH
44 # ER_BAD_REPLICA
45 # BUG#26862504 : ADD INITIALIZE, STARTUP RPL TEST FOR OPTION LOG-BIN & SERVER-ID
46 # COMBINATION
47
48 --source include/big_test.inc
49 --source include/master-slave.inc
50
51 --echo
52 --source include/rpl_connection_slave.inc
53 # Save original datadir and basedir path of server-2
54 --let ORIGINAL_MYSQLD_DATADIR= `select @@datadir`
55 --let ORIGINAL_MYSQLD_BASEDIR= `select @@basedir`
56
57 # Setup new datadir path
58 --let NEWDATADIR=$MYSQL_TMP_DIR/rpl_initialize_serverid
59 mkdir $NEWDATADIR;
60 --write_file $MYSQL_TMP_DIR/bootstrap_test.sql
61 CREATE DATABASE test;
62 USE test;
63 EOF
64
65 --let MYSQLD_LOG=$MYSQL_TMP_DIR/server.log
66 --let args=--no-defaults --innodb_dedicated_server=OFF --console --basedir=$ORIGINAL_MYSQLD_BASEDIR
67
68 # 1. Stop slave server so that it can be initialized by specifying server-id and
69 # started without specifying server-id
70 --let $rpl_server_number= 2
71 --source include/rpl_stop_server.inc
72
73 # 2. Since server-2 has previously been initialized to a data directory by MTR,
74 # it is required to initialize again by specifying the server-id to a new
75 # data directory path
76 --exec $MYSQLD $args --initialize-insecure --datadir=$NEWDATADIR --init-file=$MYSQL_TMP_DIR/bootstrap_test.sql --server-id=2 > $MYSQLD_LOG
77 # Execute DDL,DML on server-1 so as to ensure that this data will be replicated
78 # to server-2 once replication starts between server-1 and server-2
79 --echo
80 --source include/rpl_connection_master.inc
81 CREATE DATABASE db;
82 use db;
83 CREATE TABLE t1 (a int);
84 INSERT INTO t1 VALUES(1);
85 INSERT INTO t1 VALUES(2);
86 --echo
87 --source include/rpl_connection_slave.inc
88 # 3. Once server-2 has been initialized by specifying server-id to a new data
89 # directory, start server-2 without specifying the server-id using the new
90 # data directory path.
91 # Then start replication between server-1 (master) and server-2 (slave) and
92 # verify if data on master has been replicated to slave
93 --let $rpl_server_number= 2
94 --let $rpl_server_parameters= --log-bin=slave-bin --datadir=$NEWDATADIR --replica-load-tmpdir=$MYSQLTEST_VARDIR/tmp --skip-replica-start=1
95 --let $rpl_omit_print_server_parameters= 1
96 --source include/rpl_start_server.inc
97 --replace_result $MASTER_MYPORT MASTER_PORT
98 --eval CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_PORT=$MASTER_MYPORT, SOURCE_HOST='localhost'
99 --source include/start_slave.inc
100 --echo
101 --source include/rpl_connection_master.inc
102 --source include/sync_slave_sql_with_master.inc
103 --let $diff_tables= master:db.t1, slave:db.t1
104 --source include/diff_tables.inc
105
106
107 # 4. Stop server-2 and initialize server-2 by specifying server-id=0 to a
108 # new data directory
109 --let NEWDATADIR_2=$MYSQL_TMP_DIR/rpl_initialize_serverid_2
110 mkdir $NEWDATADIR_2;
111 --let $rpl_server_number= 2
112 --source include/rpl_stop_server.inc
113 --exec $MYSQLD $args --initialize-insecure --datadir=$NEWDATADIR_2 --init-file=$MYSQL_TMP_DIR/bootstrap_test.sql --server-id=0 > $MYSQLD_LOG
114 # 5. Start server-2 by specifying a non-zero server-id, enable replication
115 # between server-1 and server-2 and verify replication works fine
116 --echo
117 --source include/rpl_connection_slave.inc
118 --let $rpl_server_number= 2
119 --let $rpl_server_parameters= --server-id=2 --log-bin=slave-bin --datadir=$NEWDATADIR_2 --replica-load-tmpdir=$MYSQLTEST_VARDIR/tmp --skip-replica-start=1
120 --let $rpl_omit_print_server_parameters= 1
121 --source include/rpl_start_server.inc
122 --replace_result $MASTER_MYPORT MASTER_PORT
123 --eval CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_PORT=$MASTER_MYPORT, SOURCE_HOST='localhost'
124 --source include/start_slave.inc
125 --echo
126 --source include/rpl_connection_master.inc
127 --source include/sync_slave_sql_with_master.inc
128 --let $diff_tables= master:db.t1, slave:db.t1
129 --source include/diff_tables.inc
130
131 # 6. Stop server-2 and initialize server-2 by specifying a non-zero server-id
132 # to a new data directory
133 --let NEWDATADIR_3=$MYSQL_TMP_DIR/rpl_initialize_serverid_3
134 mkdir $NEWDATADIR_3;
135 --let $rpl_server_number= 2
136 --source include/rpl_stop_server.inc
137 --exec $MYSQLD $args --initialize-insecure --datadir=$NEWDATADIR_3 --init-file=$MYSQL_TMP_DIR/bootstrap_test.sql --server-id=2 > $MYSQLD_LOG
138 # 7. Start server-2 by specifying server-id=0
139 # Try to enable replication between server-1 and server-2 and verify that
140 # proper error is thrown since server-id is set to 0
141 --echo
142 --source include/rpl_connection_slave.inc
143 --let $rpl_server_number= 2
144 --let $rpl_server_parameters= --server-id=0 --log-bin=slave-bin --datadir=$NEWDATADIR_3 --replica-load-tmpdir=$MYSQLTEST_VARDIR/tmp --skip-replica-start=1
145 --let $rpl_omit_print_server_parameters= 1
146 --source include/rpl_start_server.inc
147 --replace_result $MASTER_MYPORT MASTER_PORT
148 --error ER_REPLICA_CONFIGURATION
149 --eval CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_PORT=$MASTER_MYPORT, SOURCE_HOST='localhost'
150
151 # 8. Stop server-2 and initialize server-2 by specifying server-id=1 to
152 # a new data directory
153 --let NEWDATADIR_4=$MYSQL_TMP_DIR/rpl_initialize_serverid_4
154 mkdir $NEWDATADIR_4;
155 --let $rpl_server_number= 2
156 --source include/rpl_stop_server.inc
157 --exec $MYSQLD $args --initialize-insecure --datadir=$NEWDATADIR_4 --init-file=$MYSQL_TMP_DIR/bootstrap_test.sql --server-id=1 > $MYSQLD_LOG
158 # 9. Start server-2 by specifying server-id=1
159 # Try to enable replication between server-1 and server-2 and verify that
160 # proper error is thrown since both master and slave have same server-id
161 --echo
162 --source include/rpl_connection_slave.inc
163 --let $rpl_server_number= 2
164 --let $rpl_server_parameters= --server-id=1 --log-bin=slave-bin --datadir=$NEWDATADIR_4 --replica-load-tmpdir=$MYSQLTEST_VARDIR/tmp --skip-replica-start=1
165 --let $rpl_omit_print_server_parameters= 1
166 --source include/rpl_start_server.inc
167 --replace_result $MASTER_MYPORT MASTER_PORT
168 --eval CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_PORT=$MASTER_MYPORT, SOURCE_HOST='localhost'
169 START SLAVE;
170 # Verify that slave IO error occurs on START SLAVE
171 # 13117 is the code for ER_REPLICA_FATAL_ERROR
172 --let $slave_io_errno= 13117
173 --source include/wait_for_slave_io_error.inc
174
175 # 10. Restart server-2 with the original datadir to bring it back to
176 # original state
177 --let $rpl_server_number= 2
178 --let $rpl_server_parameters= --datadir=$ORIGINAL_MYSQLD_DATADIR --basedir=$ORIGINAL_MYSQLD_BASEDIR --skip-replica-start=0
179 --let $rpl_omit_print_server_parameters= 1
180 --source include/rpl_restart_server.inc
181
182 # 11. Cleanup files and new data directories created during the test
183 remove_file $MYSQLD_LOG;
184 remove_file $MYSQL_TMP_DIR/bootstrap_test.sql;
185 --force-rmdir $NEWDATADIR
186 --force-rmdir $NEWDATADIR_2
187 --force-rmdir $NEWDATADIR_3
188 --force-rmdir $NEWDATADIR_4
189 --echo
190 --source include/rpl_connection_master.inc
191 DROP DATABASE db;
192 --source include/sync_slave_sql_with_master.inc
193
194 --echo
195 --source include/rpl_end.inc