Debian Codegraph @

mysql-test/suite/x/t/notices_gr_single_primary.test

raw
1 ################################################################################
2 #
3 # WL#10655: Global notification for GR membership changes
4 #
5 # This test case checks that enabled notices are triggered and delivered to
6 # client.
7 #
8 # This file covers a few scenarios specific to Single Primary mode.
9 #
10 #
11 # +----+---------------------------------------------+------------+---------|
12 # | Lp | Scenario\Where | | |
13 # | | | Server1 | Server2 |
14 # | | | triggering | |
15 # | | | event | |
16 # +----+---------------------------------------------+------------+---------|
17 # | 1 | SERVER BOOTSTRAPS+RECOVERS+PRIMARY ELECTION | VC,RC,2xSC | |
18 # | 2 | PRIMARY LEAVES | VC,SC,RC | VC,RC |
19 # +----+---------------------------------------------+------------+---------|
20 #
21 # Scenarios described inside the table will be repeated two times:
22 #
23 # * X Protocol GR notices enabled - verify delivery of the notices
24 # * X Protocol GR notices disabled - verify that X Plugin doesn't send the notices
25 #
26
27 --source include/count_sessions.inc
28 --source include/force_restart.inc
29 --source include/big_test.inc
30 --source include/have_mysqlx_plugin.inc
31 --source include/have_group_replication_plugin.inc
32
33 ## Test starts here
34 --let $xtest=$MYSQL_TMP_DIR/group_replication_setup_and_xnotices_test.tmp
35 --write_file $xtest
36 -->import group_replication.macro
37 -->import assert_notices.macro
38
39 -->echo
40 -->echo ###
41 -->echo ### Sets up the group with two servers: server1 and server2
42 -->echo ###
43
44 callmacro Connect_to_all_mysqld_instances verify %SERVER_NUMBER%;
45 callmacro %ENABLE_NOTICES% %SERVER_NUMBER%
46 {"notice":["group_replication/membership/quorum_loss",
47 "group_replication/membership/view",
48 "group_replication/status/role_change",
49 "group_replication/status/state_change"]};
50
51 callmacro Connect_to_all_mysqld_instances server %SERVER_NUMBER%;
52
53
54 repeat %SERVER_NUMBER% %ITERATION%;
55 varlet %SESSION_ITERATION% %ITERATION%;
56 varinc %SESSION_ITERATION% 1;
57 callmacro Setsession server_%SESSION_ITERATION%;
58 noquery_result;
59 SET GLOBAL group_replication_enforce_update_everywhere_checks= OFF;
60 SET GLOBAL group_replication_single_primary_mode= ON;
61 SET GLOBAL group_replication_force_members='';
62 query_result;
63 endrepeat;
64
65 callmacro GR_clear_bootstrap_group %SERVER_NUMBER%;
66
67
68 -->echo
69 -->echo ### Scenario 1: SERVER BOOTSTRAPS+RECOVERS+PRIMARY ELECTION
70 -->echo ### Expected:
71 -->echo ### - Myself: 1 VIEW CHANGE, 2 STATE CHANGED, 1 ROLE CHANGED
72 -->echo ### - Others: N/A
73 -->echo ##########################################################################
74 callmacro GR_start_and_bootstrap %SERVER_NUMBER% %GR_NAME% ONLINE;
75 callmacro GR_clear_bootstrap_group %SERVER_NUMBER%;
76
77 callmacro %ASSERT_NOTICES% view_changed verify_1;
78 callmacro %ASSERT_NOTICES% state_changed verify_1;
79 callmacro %ASSERT_NOTICES% state_changed verify_1;
80 callmacro %ASSERT_NOTICES% role_changed verify_1;
81 callmacro %ASSERT_NOTICES% none verify_1;
82 callmacro %ASSERT_NOTICES% none verify_2;
83 callmacro %ASSERT_NOTICES% none verify_3;
84
85
86 -->echo
87 -->echo ### Scenario 2: PRIMARY LEAVES the GROUP
88 -->echo ### Expected:
89 -->echo ### - Myself (old primary): 1 VIEW CHANGED, 1 STATE CHANGED, 1 ROLE CHANGED
90 -->echo ### - Others (new primary): 1 VIEW CHANGED, 1 ROLE CHANGED
91 -->echo ### - Others (secondary): 1 VIEW CHANGED, 1 ROLE CHANGED
92 -->echo ##########################################################################
93
94 callmacro Setsession server_2;
95 callmacro GR_start %GR_NAME% ONLINE;
96
97 callmacro %ASSERT_NOTICES% view_changed verify_1;
98 callmacro %ASSERT_NOTICES% state_changed verify_1;
99 callmacro %ASSERT_NOTICES% state_changed verify_1;
100 callmacro %ASSERT_NOTICES% none verify_1;
101
102 callmacro %ASSERT_NOTICES% view_changed verify_2;
103 callmacro %ASSERT_NOTICES% state_changed verify_2;
104 callmacro %ASSERT_NOTICES% state_changed verify_2;
105 callmacro %ASSERT_NOTICES% none verify_2;
106
107 callmacro %ASSERT_NOTICES% none verify_3;
108
109
110 callmacro Setsession server_3;
111 callmacro GR_start %GR_NAME% ONLINE;
112
113 callmacro %ASSERT_NOTICES% view_changed verify_1;
114 callmacro %ASSERT_NOTICES% state_changed verify_1;
115 callmacro %ASSERT_NOTICES% state_changed verify_1;
116 callmacro %ASSERT_NOTICES% none verify_1;
117
118 callmacro %ASSERT_NOTICES% view_changed verify_2;
119 callmacro %ASSERT_NOTICES% state_changed verify_2;
120 callmacro %ASSERT_NOTICES% state_changed verify_2;
121 callmacro %ASSERT_NOTICES% none verify_2;
122
123 callmacro %ASSERT_NOTICES% view_changed verify_3;
124 callmacro %ASSERT_NOTICES% state_changed verify_3;
125 callmacro %ASSERT_NOTICES% state_changed verify_3;
126 callmacro %ASSERT_NOTICES% none verify_3;
127
128 callmacro Setsession server_1;
129 callmacro GR_stop;
130
131 callmacro %ASSERT_NOTICES% view_changed verify_1;
132 callmacro %ASSERT_NOTICES% state_changed verify_1;
133 callmacro %ASSERT_NOTICES% role_changed verify_1;
134 callmacro %ASSERT_NOTICES% none verify_1;
135
136 callmacro Setsession server_2;
137 callmacro GR_wait_for_number_of_members 2;
138
139 callmacro %ASSERT_NOTICES% view_changed verify_2;
140 callmacro %ASSERT_NOTICES% role_changed verify_2;
141 callmacro %ASSERT_NOTICES% none verify_2;
142
143 callmacro Setsession server_3;
144 callmacro GR_wait_for_number_of_members 2;
145
146 callmacro %ASSERT_NOTICES% view_changed verify_3;
147 callmacro %ASSERT_NOTICES% role_changed verify_3;
148 callmacro %ASSERT_NOTICES% none verify_3;
149
150
151 -->echo
152 -->echo ###
153 -->echo ### In X test cleanup
154 -->echo ###
155 callmacro Setsession server_2;
156 callmacro GR_stop;
157
158 callmacro Setsession server_3;
159 callmacro GR_stop;
160
161 EOF
162
163 ## Setup X Plugin & GR
164 --let $dont_reset_global_status_variables=1
165 --source include/xplugin_preamble.inc
166
167 --let $rpl_server_count= 3
168 --let $rpl_skip_group_replication_start= 1
169 --source include/group_replication.inc
170
171 --let $ceiling= `SELECT $rpl_server_count + 1`
172 --let $i = 1
173
174 while ($i < $ceiling)
175 {
176 --let $rpl_connection_silent= 1
177 --let $rpl_connection_name= server$i
178 --echo [Setup XPlugin user on connection '$rpl_connection_name']
179 --source include/rpl_connection.inc
180 --let $create_user_disable_binlog=1
181 --source include/xplugin_create_user.inc
182 --inc $i
183 }
184
185 --let $rpl_connection_silent= 0
186
187 --echo
188 --echo ## Protocol GR notices enabled - verify delivery of the notices
189 --echo ##########################################################################
190
191 exec $MYSQLXTEST
192 -ux_root --ssl-mode=disabled --file=$xtest
193 -v %SERVER_NUMBER%=$rpl_server_count
194 -v %GR_NAME%=$group_replication_group_name
195 -v %ASSERT_NOTICES%=CHK_assert_notice
196 -v %ENABLE_NOTICES%=Enable_notice
197 -v %SERVER_XPORT_1%=$MASTER_X_MYPORT_1
198 -v %SERVER_XPORT_2%=$MASTER_X_MYPORT_2
199 -v %SERVER_XPORT_3%=$MASTER_X_MYPORT_3 2>&1;
200
201
202 --echo
203 --echo ## X Protocol GR notices disabled - verify that X Plugin doesn't send the notices
204 --echo ##########################################################################
205
206 exec $MYSQLXTEST
207 -ux_root --ssl-mode=disabled --file=$xtest
208 -v %SERVER_NUMBER%=$rpl_server_count
209 -v %GR_NAME%=$group_replication_group_name
210 -v %ASSERT_NOTICES%=CHK_assert_notice_none_ignore_args
211 -v %ENABLE_NOTICES%=Dont_enable_notice
212 -v %SERVER_XPORT_1%=$MASTER_X_MYPORT_1
213 -v %SERVER_XPORT_2%=$MASTER_X_MYPORT_2
214 -v %SERVER_XPORT_3%=$MASTER_X_MYPORT_3 2>&1;
215
216 ## Cleanup
217 --remove_file $xtest
218
219 --source include/group_replication_end.inc
220 --let $i = 1
221 --let $rpl_connection_silent=1
222 while ($i < $ceiling)
223 {
224 --let $rpl_connection_silent= 1
225 --let $rpl_connection_name= server$i
226 --source include/rpl_connection.inc
227 --source include/xplugin_drop_user.inc
228 --inc $i
229 }
230
231 # Following connections are established by group_replication.inc,
232 # still group_replication_end.inc doesn't disconnects them.
233 #
234 # Releasing the connections manually
235 #
236 --disconnect server1
237 --disconnect server2
238 --disconnect server3
239 --disconnect master1
240 --disconnect master
241 --disconnect slave1
242 --disconnect slave
243 --connection default
244 # Wait till all disconnects are completed
245 --source include/wait_until_count_sessions.inc