Debian Codegraph @

mysql-test/suite/x/r/notices_gr_quorum.result

raw
1 include/group_replication.inc [rpl_server_count=3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 [Setup XPlugin user on connection 'server1']
7 [Setup XPlugin user on connection 'server2']
8 [Setup XPlugin user on connection 'server3']
9
10 ## Protocol GR notices enabled - verify delivery of the notices
11 ##########################################################################
12
13 ###
14 ### Sets up the group with three servers
15 ###
16 connecting...
17 active session is now 'verify_1'
18 connecting...
19 active session is now 'server_1'
20 connecting...
21 active session is now 'server_2'
22 connecting...
23 active session is now 'server_3'
24 [connection server_1]
25 RUN SELECT @@SERVER_UUID
26 RUN SELECT @@GLOBAL.group_replication_local_address
27 RUN SELECT @@GLOBAL.group_replication_group_seeds
28 [connection server_2]
29 RUN SELECT @@SERVER_UUID
30 RUN SELECT @@GLOBAL.group_replication_local_address
31 RUN SELECT @@GLOBAL.group_replication_group_seeds
32 [connection server_3]
33 RUN SELECT @@SERVER_UUID
34 RUN SELECT @@GLOBAL.group_replication_local_address
35 RUN SELECT @@GLOBAL.group_replication_group_seeds
36 [connection server_3]
37 RUN SET GLOBAL group_replication_bootstrap_group= 0
38 [connection server_2]
39 RUN SET GLOBAL group_replication_bootstrap_group= 0
40 [connection server_1]
41 RUN SET GLOBAL group_replication_bootstrap_group= 0
42 [connection server_1]
43 [connection server_1]
44 RUN SET GLOBAL group_replication_bootstrap_group= 1
45 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
46 RUN START GROUP_REPLICATION
47 [waiting for member_state to be equal 'ONLINE']
48 [connection server_3]
49 RUN SET GLOBAL group_replication_bootstrap_group= 0
50 [connection server_2]
51 RUN SET GLOBAL group_replication_bootstrap_group= 0
52 [connection server_1]
53 RUN SET GLOBAL group_replication_bootstrap_group= 0
54 [connection server_2]
55 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
56 RUN START GROUP_REPLICATION
57 [waiting for member_state to be equal 'ONLINE']
58 [connection server_3]
59 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
60 RUN START GROUP_REPLICATION
61 [waiting for member_state to be equal 'ONLINE']
62 [waiting for '3' members]
63 [connection verify_1]
64 [Enabling GR notifications]
65
66 ### Scenario 1: SERVER UNREACHABLE
67 ### Expected:
68 ### - Correct Servers: 1 STATE CHANGED (and eventually a VIEW CHANGED)
69 ### - Failed server: N/A
70 ##########################################################
71 [Killing and restarting server associated with server_3]
72 [connection server_1]
73 [waiting for '2' members]
74 [ASSERT state_change on 'verify_1' connection]
75 [ASSERT view_change on 'verify_1' connection]
76 [ASSERT no notices on 'verify_1' connection]
77
78 ### Scenario 2: MAJORITY UNREACHABLE
79 ### Expected:
80 ### - Correct Servers: 1 QUORUM LOST, 1 STATE CHANGED
81 ### - Failed Servers: N/A
82 ##########################################################
83 [Killing and restarting server associated with server_2]
84 [connection server_1]
85 [waiting for concrete member with member_state to be equal 'UNREACHABLE']
86 [ASSERT quorum_lost on 'verify_1' connection]
87 [ASSERT state_change on 'verify_1' connection]
88 [ASSERT no notices on 'verify_1' connection]
89
90 ### Scenario 3: MAJORITY UNREACHABLE + FORCE MEMBERS
91 ### Expected:
92 ### - Correct Servers: 1 VIEW CHANGED
93 ### - Failed Servers: N/A
94 ##########################################################
95 [connection server_1]
96 RUN SET GLOBAL group_replication_force_members= "%LOCAL_ADDRESS_SERVER_1%"
97 [waiting for '1' members]
98 RUN SET GLOBAL group_replication_force_members= ""
99 [ASSERT view_change on 'verify_1' connection]
100 [ASSERT no notices on 'verify_1' connection]
101 RUN STOP GROUP_REPLICATION
102 RUN SET GLOBAL read_only= FALSE
103
104 ### Scenario 4: MAJORITY UNREACHABLE + STOP
105 ### Expected:
106 ### - Correct Servers: 1 VIEW CHANGED, 1 STATE CHANGED
107 ### - Failed Servers: N/A
108 ##########################################################
109 [connection server_1]
110 RUN RESET MASTER
111 RUN SET @@global.group_replication_group_seeds="%GROUP_SEEDS_SERVER_1%"
112 RUN SET @@global.group_replication_local_address="%LOCAL_ADDRESS_SERVER_1%"
113 [connection server_1]
114 RUN SET GLOBAL group_replication_bootstrap_group= 1
115 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
116 RUN START GROUP_REPLICATION
117 [waiting for member_state to be equal 'ONLINE']
118 [connection server_3]
119 RUN SET GLOBAL group_replication_bootstrap_group= 0
120 [connection server_2]
121 RUN SET GLOBAL group_replication_bootstrap_group= 0
122 [connection server_1]
123 RUN SET GLOBAL group_replication_bootstrap_group= 0
124 [ASSERT view_change on 'verify_1' connection]
125 [ASSERT state_change on 'verify_1' connection]
126 [ASSERT state_change on 'verify_1' connection]
127 [ASSERT no notices on 'verify_1' connection]
128 [connection server_2]
129 RUN RESET MASTER
130 RUN SET @@global.group_replication_group_seeds="%GROUP_SEEDS_SERVER_2%"
131 RUN SET @@global.group_replication_local_address="%LOCAL_ADDRESS_SERVER_2%"
132 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
133 RUN START GROUP_REPLICATION
134 [waiting for member_state to be equal 'ONLINE']
135 [ASSERT view_change on 'verify_1' connection]
136 [ASSERT state_change on 'verify_1' connection]
137 [ASSERT state_change on 'verify_1' connection]
138 [ASSERT no notices on 'verify_1' connection]
139 [Killing and restarting server associated with server_2]
140 [connection server_1]
141 [waiting for concrete member with member_state to be equal 'UNREACHABLE']
142 [ASSERT quorum_lost on 'verify_1' connection]
143 [ASSERT state_change on 'verify_1' connection]
144 [ASSERT no notices on 'verify_1' connection]
145 RUN STOP GROUP_REPLICATION
146 RUN SET GLOBAL read_only= FALSE
147 [ASSERT no notices on 'verify_1' connection]
148
149 ### Cleanup: in xtest
150 ##########################################################################
151 [connection server_1]
152 [connection server_2]
153 [connection server_3]
154 closing session server_3
155 Mysqlx.Ok {
156 msg: "bye!"
157 }
158 ok
159 [connection server_2]
160 [connection server2]
161 [connection server_3]
162 [connection server3]
163
164 ## X Protocol GR notices disabled - verify that X Plugin doesn't send the notices
165 ##########################################################################
166
167 ###
168 ### Sets up the group with three servers
169 ###
170 connecting...
171 active session is now 'verify_1'
172 connecting...
173 active session is now 'server_1'
174 connecting...
175 active session is now 'server_2'
176 connecting...
177 active session is now 'server_3'
178 [connection server_1]
179 RUN SELECT @@SERVER_UUID
180 RUN SELECT @@GLOBAL.group_replication_local_address
181 RUN SELECT @@GLOBAL.group_replication_group_seeds
182 [connection server_2]
183 RUN SELECT @@SERVER_UUID
184 RUN SELECT @@GLOBAL.group_replication_local_address
185 RUN SELECT @@GLOBAL.group_replication_group_seeds
186 [connection server_3]
187 RUN SELECT @@SERVER_UUID
188 RUN SELECT @@GLOBAL.group_replication_local_address
189 RUN SELECT @@GLOBAL.group_replication_group_seeds
190 [connection server_3]
191 RUN SET GLOBAL group_replication_bootstrap_group= 0
192 [connection server_2]
193 RUN SET GLOBAL group_replication_bootstrap_group= 0
194 [connection server_1]
195 RUN SET GLOBAL group_replication_bootstrap_group= 0
196 [connection server_1]
197 [connection server_1]
198 RUN SET GLOBAL group_replication_bootstrap_group= 1
199 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
200 RUN START GROUP_REPLICATION
201 [waiting for member_state to be equal 'ONLINE']
202 [connection server_3]
203 RUN SET GLOBAL group_replication_bootstrap_group= 0
204 [connection server_2]
205 RUN SET GLOBAL group_replication_bootstrap_group= 0
206 [connection server_1]
207 RUN SET GLOBAL group_replication_bootstrap_group= 0
208 [connection server_2]
209 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
210 RUN START GROUP_REPLICATION
211 [waiting for member_state to be equal 'ONLINE']
212 [connection server_3]
213 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
214 RUN START GROUP_REPLICATION
215 [waiting for member_state to be equal 'ONLINE']
216 [waiting for '3' members]
217
218 ### Scenario 1: SERVER UNREACHABLE
219 ### Expected:
220 ### - Correct Servers: 1 STATE CHANGED (and eventually a VIEW CHANGED)
221 ### - Failed server: N/A
222 ##########################################################
223 [Killing and restarting server associated with server_3]
224 [connection server_1]
225 [waiting for '2' members]
226 [ASSERT no notices on 'verify_1' connection]
227 [ASSERT no notices on 'verify_1' connection]
228 [ASSERT no notices on 'verify_1' connection]
229
230 ### Scenario 2: MAJORITY UNREACHABLE
231 ### Expected:
232 ### - Correct Servers: 1 QUORUM LOST, 1 STATE CHANGED
233 ### - Failed Servers: N/A
234 ##########################################################
235 [Killing and restarting server associated with server_2]
236 [connection server_1]
237 [waiting for concrete member with member_state to be equal 'UNREACHABLE']
238 [ASSERT no notices on 'verify_1' connection]
239 [ASSERT no notices on 'verify_1' connection]
240 [ASSERT no notices on 'verify_1' connection]
241
242 ### Scenario 3: MAJORITY UNREACHABLE + FORCE MEMBERS
243 ### Expected:
244 ### - Correct Servers: 1 VIEW CHANGED
245 ### - Failed Servers: N/A
246 ##########################################################
247 [connection server_1]
248 RUN SET GLOBAL group_replication_force_members= "%LOCAL_ADDRESS_SERVER_1%"
249 [waiting for '1' members]
250 RUN SET GLOBAL group_replication_force_members= ""
251 [ASSERT no notices on 'verify_1' connection]
252 [ASSERT no notices on 'verify_1' connection]
253 RUN STOP GROUP_REPLICATION
254 RUN SET GLOBAL read_only= FALSE
255
256 ### Scenario 4: MAJORITY UNREACHABLE + STOP
257 ### Expected:
258 ### - Correct Servers: 1 VIEW CHANGED, 1 STATE CHANGED
259 ### - Failed Servers: N/A
260 ##########################################################
261 [connection server_1]
262 RUN RESET MASTER
263 RUN SET @@global.group_replication_group_seeds="%GROUP_SEEDS_SERVER_1%"
264 RUN SET @@global.group_replication_local_address="%LOCAL_ADDRESS_SERVER_1%"
265 [connection server_1]
266 RUN SET GLOBAL group_replication_bootstrap_group= 1
267 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
268 RUN START GROUP_REPLICATION
269 [waiting for member_state to be equal 'ONLINE']
270 [connection server_3]
271 RUN SET GLOBAL group_replication_bootstrap_group= 0
272 [connection server_2]
273 RUN SET GLOBAL group_replication_bootstrap_group= 0
274 [connection server_1]
275 RUN SET GLOBAL group_replication_bootstrap_group= 0
276 [ASSERT no notices on 'verify_1' connection]
277 [ASSERT no notices on 'verify_1' connection]
278 [ASSERT no notices on 'verify_1' connection]
279 [ASSERT no notices on 'verify_1' connection]
280 [connection server_2]
281 RUN RESET MASTER
282 RUN SET @@global.group_replication_group_seeds="%GROUP_SEEDS_SERVER_2%"
283 RUN SET @@global.group_replication_local_address="%LOCAL_ADDRESS_SERVER_2%"
284 RUN SET GLOBAL group_replication_group_name='%GR_NAME%'
285 RUN START GROUP_REPLICATION
286 [waiting for member_state to be equal 'ONLINE']
287 [ASSERT no notices on 'verify_1' connection]
288 [ASSERT no notices on 'verify_1' connection]
289 [ASSERT no notices on 'verify_1' connection]
290 [ASSERT no notices on 'verify_1' connection]
291 [Killing and restarting server associated with server_2]
292 [connection server_1]
293 [waiting for concrete member with member_state to be equal 'UNREACHABLE']
294 [ASSERT no notices on 'verify_1' connection]
295 [ASSERT no notices on 'verify_1' connection]
296 [ASSERT no notices on 'verify_1' connection]
297 RUN STOP GROUP_REPLICATION
298 RUN SET GLOBAL read_only= FALSE
299 [ASSERT no notices on 'verify_1' connection]
300
301 ### Cleanup: in xtest
302 ##########################################################################
303 [connection server_1]
304 [connection server_2]
305 [connection server_3]
306 closing session server_3
307 Mysqlx.Ok {
308 msg: "bye!"
309 }
310 ok
311 [connection server_2]
312 [connection server2]
313 [connection server_3]
314 [connection server3]
315 include/group_replication_end.inc