Debian Codegraph @

mysql-test/suite/group_replication/t/gr_force_peer_addresses_option.test

raw
1 ################################################################################
2 # Verify that group_replication_force_members does behave as expected
3 # when:
4 # 0) The test requires two servers: M1 and M2.
5 # 1) A empty value is set on a OFFLINE member. It should succeed.
6 # 2) A value is set on a OFFLINE member. It should fail.
7 # 3) A empty value is set on a ONLINE member. It should succeed.
8 # 4) An IP is set on group with majority reachable. It should fail.
9 # 5) A empty value is set on a RECOVERING member. It should succeed.
10 # 6) A value is set on a RECOVERING member. It should fail.
11 # 7) Restart member with group_replication_force_members set. Group
12 # Replication automatic start will error out.
13 # 8) Start Group Replication with group_replication_force_members set,
14 # start will error out.
15 # 9) Clear group_replication_force_members, start will work.
16 # 10) Kill and restart a member to group loose majority.
17 # 11) Invalid address is set on a ONLINE member with majority unreachable. It
18 # should fail.
19 # 12) Address of an UNREACHABLE member is set on a ONLINE member with majority
20 # unreachable. It should fail.
21 # 13) IP address is set on a ONLINE member with majority unreachable. It
22 # should succeed.
23 # 14) Clean up.
24 ################################################################################
25 --source include/big_test.inc
26 --source include/have_debug_sync.inc
27 --source include/have_group_replication_plugin.inc
28 --source include/force_restart.inc
29 --let $rpl_skip_group_replication_start= 1
30 --source include/group_replication.inc
31
32 --let $rpl_connection_name= server2
33 --source include/rpl_connection.inc
34 --let $uuid_server2= `SELECT @@GLOBAL.SERVER_UUID`
35 --let $member2_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
36 SET SESSION sql_log_bin= 0;
37 call mtr.add_suppression("Member is not ONLINE, it is not possible to force a new group membership.");
38 call mtr.add_suppression("group_replication_force_members must be empty on group start. Current value: '127.0.0.1:10000'");
39 call mtr.add_suppression("Unable to start Group Replication on boot");
40 call mtr.add_suppression("force_members can only be updated when Group Replication is running*");
41 call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
42 call mtr.add_suppression("\\[GCS\\] Peer address .* is not valid.");
43 call mtr.add_suppression("\\[GCS\\] The peers list contains invalid addresses.Please provide a list with only valid addresses.");
44 call mtr.add_suppression("Error setting group_replication_force_members value .* on group communication interfaces");
45 call mtr.add_suppression("The member resumed contact with a majority of the members in the group.*");
46 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped.*");
47 call mtr.add_suppression(".*Only alive members in the current configuration should be present in a forced configuration list.*");
48 call mtr.add_suppression("\\[GCS\\] Error reconfiguring group.");
49
50 SET SESSION sql_log_bin= 1;
51
52 --let $rpl_connection_name= server1
53 --source include/rpl_connection.inc
54
55 --let $member1_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
56 --let $group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
57 --let $member1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
58 --let $uuid_server1= `SELECT @@GLOBAL.SERVER_UUID`
59 SET SESSION sql_log_bin= 0;
60 call mtr.add_suppression("Member is OFFLINE, it is not possible to force a new group membership");
61 call mtr.add_suppression("force_members can only be updated when Group Replication is running*");
62 SET SESSION sql_log_bin= 1;
63
64
65 --echo
66 --echo ############################################################
67 --echo # 1. Set empty string value to
68 --echo # group_replication_force_members on a OFFLINE
69 --echo # member.
70 SET GLOBAL group_replication_force_members= "";
71
72 --let $assert_text= group_replication_force_members is empty
73 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
74 --source include/assert.inc
75
76
77 --echo
78 --echo ############################################################
79 --echo # 2. Set group_replication_force_members on a OFFLINE
80 --echo # member.
81 --error ER_GROUP_REPLICATION_FORCE_MEMBERS_COMMAND_FAILURE
82 SET GLOBAL group_replication_force_members= "127.0.0.1:10000";
83
84 --let $assert_text= group_replication_force_members is empty
85 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
86 --source include/assert.inc
87
88
89 --echo
90 --echo ############################################################
91 --echo # 3. Set empty string value to
92 --echo # group_replication_force_members on a ONLINE
93 --echo # member.
94 --source include/start_and_bootstrap_group_replication.inc
95 SET GLOBAL group_replication_force_members= "";
96
97 --let $assert_text= group_replication_force_members is empty
98 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
99 --source include/assert.inc
100
101 --echo
102 --echo ############################################################
103 --echo # 4. Set valid IP string value to
104 --echo # group_replication_force_members on a ONLINE member and
105 --echo # majority of group members are reachable
106 --error ER_GROUP_REPLICATION_FORCE_MEMBERS_COMMAND_FAILURE
107 SET GLOBAL group_replication_force_members= "127.0.0.1:10001";
108
109 --let $assert_text= group_replication_force_members is empty
110 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
111 --source include/assert.inc
112
113
114 --echo
115 --echo ############################################################
116 --echo # 5. Set empty string value to
117 --echo # group_replication_force_members on a RECOVERING
118 --echo # member.
119 --let $rpl_connection_name= server2
120 --source include/rpl_connection.inc
121 SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish';
122
123 --let $group_replication_start_member_state= RECOVERING
124 --source include/start_group_replication.inc
125
126 SET GLOBAL group_replication_force_members= "";
127
128 --let $assert_text= group_replication_force_members is empty
129 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
130 --source include/assert.inc
131
132
133 --echo
134 --echo ############################################################
135 --echo # 6. Set group_replication_force_members on a RECOVERING
136 --echo # member.
137 --let $group_replication_member_state= RECOVERING
138 --source include/gr_wait_for_member_state.inc
139
140 --error ER_GROUP_REPLICATION_FORCE_MEMBERS_COMMAND_FAILURE
141 SET GLOBAL group_replication_force_members= "127.0.0.1:10000";
142
143 SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached";
144 SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish';
145 SET DEBUG_SYNC= "now SIGNAL signal.recovery_end";
146
147 --let $rpl_connection_name= server2
148 --source include/rpl_connection.inc
149 --let $group_replication_member_state= ONLINE
150 --source include/gr_wait_for_member_state.inc
151
152 SET DEBUG_SYNC= 'RESET';
153
154
155 --echo
156 --echo ############################################################
157 --echo # 7. Restart member with group_replication_force_members
158 --echo # set. Group Replication start will error out.
159 --echo # 2 members.
160 --let $rpl_connection_name= server2
161 --source include/rpl_connection.inc
162
163 --let $allow_rpl_inited=1
164 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
165 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
166 --let $restart_parameters=restart:--group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group_replication_start_on_boot=1 --group-replication-group-name=$group_replication_group_name --group_replication_force_members="127.0.0.1:10000"
167 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
168 --source include/restart_mysqld.inc
169
170 --let $rpl_server_number= 2
171 --source include/rpl_reconnect.inc
172
173 --let $assert_text= Member 2 is OFFLINE
174 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_members WHERE member_state="OFFLINE"] = 1
175 --source include/assert.inc
176
177
178 --echo
179 --echo ############################################################
180 --echo # 8. Start Group Replication while
181 --echo # group_replication_force_members is set. Start
182 --echo # will error out.
183
184 --let $assert_text= group_replication_force_members must be 127.0.0.1:10000
185 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = "127.0.0.1:10000"
186 --source include/assert.inc
187
188 --error ER_GROUP_REPLICATION_CONFIGURATION
189 START GROUP_REPLICATION;
190
191 --let $assert_text= Member 2 is OFFLINE
192 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_members WHERE member_state="OFFLINE"] = 1
193 --source include/assert.inc
194
195
196 --echo
197 --echo ############################################################
198 --echo # 9. Clear group_replication_force_members and start
199 --echo # Group Replication. Group will have the 2 members.
200 SET GLOBAL group_replication_force_members= "";
201
202 --let $assert_text= group_replication_force_members is empty
203 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
204 --source include/assert.inc
205
206 --source include/start_group_replication.inc
207
208 # Server 1
209 --let $rpl_connection_name= server1
210 --source include/rpl_connection.inc
211 --let $group_replication_number_of_members= 2
212 --source include/gr_wait_for_number_of_members.inc
213
214 --let $assert_text= Server 1 must be present on group members
215 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_members WHERE member_id="$uuid_server1"] = 1
216 --source include/assert.inc
217 --let $assert_text= Server 2 must be present on group members
218 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_members WHERE member_id="$uuid_server2"] = 1
219 --source include/assert.inc
220
221 # Server 2
222 --let $rpl_connection_name= server2
223 --source include/rpl_connection.inc
224 --let $group_replication_number_of_members= 2
225 --source include/gr_wait_for_number_of_members.inc
226
227 --let $assert_text= Server 1 must be present on group members
228 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_members WHERE member_id="$uuid_server1"] = 1
229 --source include/assert.inc
230 --let $assert_text= Server 2 must be present on group members
231 --let $assert_cond= [SELECT COUNT(*) FROM performance_schema.replication_group_members WHERE member_id="$uuid_server2"] = 1
232 --source include/assert.inc
233
234 --let $assert_text= group_replication_force_members must be empty
235 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
236 --source include/assert.inc
237
238 --echo
239 --echo ############################################################
240 --echo # 10. Kill and restart a member to group loose majority.
241
242 --let $rpl_connection_name= server1
243 --source include/rpl_connection.inc
244
245 --let $restart_parameters=restart:--group_replication_local_address=$member1_group_replication_local_address --group_replication_group_seeds=$group_replication_group_seeds --group_replication_group_name=$group_replication_group_name
246 --replace_result $member1_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS1 $group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
247 --source include/kill_and_restart_mysqld.inc
248
249 --let $rpl_server_number= 1
250 --source include/rpl_reconnect.inc
251
252 --let $rpl_connection_name= server2
253 --source include/rpl_connection.inc
254
255 # confirm member is unreachable
256 --let $group_replication_member_state= UNREACHABLE
257 --let $group_replication_member_id= $member1_uuid
258 --source include/gr_wait_for_member_state.inc
259
260
261 --echo
262 --echo ############################################################
263 --echo # 11. Set invalid IP string value to
264 --echo # group_replication_force_members on a ONLINE member and
265 --echo # majority of group members are unreachable.
266
267 --error ER_GROUP_REPLICATION_FORCE_MEMBERS_COMMAND_FAILURE
268 SET GLOBAL group_replication_force_members= "256.256.256.777:1234";
269
270 --let $assert_text= group_replication_force_members is empty
271 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
272 --source include/assert.inc
273
274 --echo
275 --echo ############################################################
276 --echo # 12. Set IP of an UNREACHABLE member to
277 --echo # group_replication_force_members on a ONLINE member .
278
279 --replace_result $member1_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS1
280 --error ER_GROUP_REPLICATION_FORCE_MEMBERS_COMMAND_FAILURE
281 --eval SET GLOBAL group_replication_force_members= "$member1_group_replication_local_address";
282
283 --let $assert_text= group_replication_force_members is empty
284 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = ""
285 --source include/assert.inc
286
287
288 --echo
289 --echo ############################################################
290 --echo # 13. Set valid IP string value to
291 --echo # group_replication_force_members on a ONLINE member and
292 --echo # majority of group members are unreachable
293
294 # unblock group
295 --replace_result $member2_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS1
296 eval SET GLOBAL group_replication_force_members= "$member2_group_replication_local_address";
297
298 --let $assert_text= group_replication_force_members has member2 local address
299 --let $assert_cond= "[SELECT @@GLOBAL.group_replication_force_members]" = "$member2_group_replication_local_address"
300 --source include/assert.inc
301
302
303 --echo
304 --echo ############################################################
305 --echo # 14. Clean up.
306
307 # rejoin M1 to group
308 --let $rpl_connection_name= server1
309 --source include/rpl_connection.inc
310 --source include/start_group_replication.inc
311
312 --source include/group_replication_end.inc