Debian Codegraph @

mysql-test/suite/group_replication/r/gr_flow_control_options.result

raw
1 include/group_replication.inc
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 SET @group_replication_flow_control_mode_save= @@GLOBAL.group_replication_flow_control_mode;
7 SET @group_replication_flow_control_certifier_threshold_save= @@GLOBAL.group_replication_flow_control_certifier_threshold;
8 SET @group_replication_flow_control_applier_threshold_save= @@GLOBAL.group_replication_flow_control_applier_threshold;
9 SET @group_replication_flow_control_min_quota_save= @@GLOBAL.group_replication_flow_control_min_quota;
10 SET @group_replication_flow_control_min_recovery_quota_save= @@GLOBAL.group_replication_flow_control_min_recovery_quota;
11 SET @group_replication_flow_control_max_quota_save= @@GLOBAL.group_replication_flow_control_max_quota;
12 SET @group_replication_flow_control_member_quota_percent_save= @@GLOBAL.group_replication_flow_control_member_quota_percent;
13 SET @group_replication_flow_control_period_save= @@GLOBAL.group_replication_flow_control_period;
14 SET @group_replication_flow_control_hold_percent_save= @@GLOBAL.group_replication_flow_control_hold_percent;
15 SET @group_replication_flow_control_release_percent_save= @@GLOBAL.group_replication_flow_control_release_percent;
16 SET @debug_saved= @@GLOBAL.DEBUG;
17 SET @@GLOBAL.DEBUG= 'd,flow_control_simulate_delayed_members';
18 set session sql_log_bin=0;
19 CALL mtr.add_suppression("group_replication_flow_control_min_quota cannot be larger than group_replication_flow_control_max_quota");
20 CALL mtr.add_suppression("group_replication_flow_control_min_recovery_quota cannot be larger than group_replication_flow_control_max_quota");
21 CALL mtr.add_suppression("group_replication_flow_control_max_quota cannot be smaller than group_replication_flow_control_min_quota or group_replication_flow_control_min_recovery_quota");
22 set session sql_log_bin=1;
23
24 ############################################################
25 # 1. Test group_replication_flow_control_mode option.
26 SET GLOBAL group_replication_flow_control_mode= "";
27 ERROR 42000: Variable 'group_replication_flow_control_mode' can't be set to the value of ''
28 SET GLOBAL group_replication_flow_control_mode= "XXX";
29 ERROR 42000: Variable 'group_replication_flow_control_mode' can't be set to the value of 'XXX'
30 SET GLOBAL group_replication_flow_control_mode= -1;
31 ERROR 42000: Variable 'group_replication_flow_control_mode' can't be set to the value of '-1'
32 SET GLOBAL group_replication_flow_control_mode= 2;
33 ERROR 42000: Variable 'group_replication_flow_control_mode' can't be set to the value of '2'
34 SET GLOBAL group_replication_flow_control_mode= DISABLED;
35 include/assert.inc [group_replication_flow_control_mode is correct]
36 SET GLOBAL group_replication_flow_control_mode= QUOTA;
37 include/assert.inc [group_replication_flow_control_mode is correct]
38 SET GLOBAL group_replication_flow_control_mode= 0;
39 include/assert.inc [group_replication_flow_control_mode is correct]
40 SET GLOBAL group_replication_flow_control_mode= 1;
41 include/assert.inc [group_replication_flow_control_mode is correct]
42
43 ############################################################
44 # 2. Test group_replication_flow_control_certifier_threshold
45 # option.
46 SET GLOBAL group_replication_flow_control_certifier_threshold= "";
47 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_certifier_threshold'
48 SET GLOBAL group_replication_flow_control_certifier_threshold= -1;
49 Warnings:
50 Warning 1292 Truncated incorrect group_replication_flow_control_certifier_threshold value: '-1'
51 include/assert.inc [group_replication_flow_control_certifier_threshold is truncated]
52 SET GLOBAL group_replication_flow_control_certifier_threshold= 2147483648;
53 Warnings:
54 Warning 1292 Truncated incorrect group_replication_flow_control_certifier_threshold value: '2147483648'
55 include/assert.inc [group_replication_flow_control_certifier_threshold is truncated]
56 SET GLOBAL group_replication_flow_control_certifier_threshold= 1;
57 include/assert.inc [group_replication_flow_control_certifier_threshold is correct]
58 SET GLOBAL group_replication_flow_control_certifier_threshold= 2147483647;
59 include/assert.inc [group_replication_flow_control_certifier_threshold is correct]
60
61 ############################################################
62 # 3. Test group_replication_flow_control_applier_threshold
63 # option.
64 SET GLOBAL group_replication_flow_control_applier_threshold= "";
65 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_applier_threshold'
66 SET GLOBAL group_replication_flow_control_applier_threshold= -1;
67 Warnings:
68 Warning 1292 Truncated incorrect group_replication_flow_control_applier_threshold value: '-1'
69 include/assert.inc [group_replication_flow_control_applier_threshold is truncated]
70 SET GLOBAL group_replication_flow_control_applier_threshold= 2147483648;
71 Warnings:
72 Warning 1292 Truncated incorrect group_replication_flow_control_applier_threshold value: '2147483648'
73 include/assert.inc [group_replication_flow_control_applier_threshold is truncated]
74 SET GLOBAL group_replication_flow_control_applier_threshold= 1;
75 include/assert.inc [group_replication_flow_control_applier_threshold is correct]
76 SET GLOBAL group_replication_flow_control_applier_threshold= 2147483647;
77 include/assert.inc [group_replication_flow_control_applier_threshold is correct]
78
79 ############################################################
80 # 4. Test group_replication_flow_control_min_quota
81 # option.
82 SET GLOBAL group_replication_flow_control_min_quota= "";
83 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_min_quota'
84 SET GLOBAL group_replication_flow_control_min_quota= -1;
85 include/assert.inc [group_replication_flow_control_min_quota is truncated]
86 SET GLOBAL group_replication_flow_control_min_quota= 2147483648;
87 include/assert.inc [group_replication_flow_control_min_quota is truncated]
88 SET GLOBAL group_replication_flow_control_min_quota= 1;
89 include/assert.inc [group_replication_flow_control_min_quota is correct]
90 SET GLOBAL group_replication_flow_control_min_quota= 2147483647;
91 include/assert.inc [group_replication_flow_control_min_quota is correct]
92 SET GLOBAL group_replication_flow_control_min_quota= 0;
93
94 ############################################################
95 # 5. Test group_replication_flow_control_min_recovery_quota
96 # option.
97 SET GLOBAL group_replication_flow_control_min_recovery_quota= "";
98 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_min_recovery_quota'
99 SET GLOBAL group_replication_flow_control_min_recovery_quota= -1;
100 include/assert.inc [group_replication_flow_control_min_recovery_quota is truncated]
101 SET GLOBAL group_replication_flow_control_min_recovery_quota= 2147483648;
102 include/assert.inc [group_replication_flow_control_min_recovery_quota is truncated]
103 SET GLOBAL group_replication_flow_control_min_recovery_quota= 1;
104 include/assert.inc [group_replication_flow_control_min_recovery_quota is correct]
105 SET GLOBAL group_replication_flow_control_min_recovery_quota= 2147483647;
106 include/assert.inc [group_replication_flow_control_min_recovery_quota is correct]
107 SET GLOBAL group_replication_flow_control_min_recovery_quota= 0;
108
109 ############################################################
110 # 6. Test group_replication_flow_control_max_quota
111 # option.
112 SET GLOBAL group_replication_flow_control_max_quota= "";
113 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_max_quota'
114 SET GLOBAL group_replication_flow_control_max_quota= -1;
115 include/assert.inc [group_replication_flow_control_max_quota is truncated]
116 SET GLOBAL group_replication_flow_control_max_quota= 2147483648;
117 include/assert.inc [group_replication_flow_control_max_quota is truncated]
118 SET GLOBAL group_replication_flow_control_max_quota= 1;
119 include/assert.inc [group_replication_flow_control_max_quota is correct]
120 SET GLOBAL group_replication_flow_control_max_quota= 2147483647;
121 include/assert.inc [group_replication_flow_control_max_quota is correct]
122 SET GLOBAL group_replication_flow_control_max_quota= 0;
123
124 ############################################################
125 # 7. Test group_replication_flow_control_member_quota_percent
126 # option.
127 SET GLOBAL group_replication_flow_control_member_quota_percent= "";
128 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_member_quota_percent'
129 SET GLOBAL group_replication_flow_control_member_quota_percent= -1;
130 Warnings:
131 Warning 1292 Truncated incorrect group_replication_flow_control_member_quota_percent value: '-1'
132 include/assert.inc [group_replication_flow_control_member_quota_percent is truncated]
133 SET GLOBAL group_replication_flow_control_member_quota_percent= 101;
134 Warnings:
135 Warning 1292 Truncated incorrect group_replication_flow_control_member_quota_percent value: '101'
136 include/assert.inc [group_replication_flow_control_member_quota_percent is truncated]
137 SET GLOBAL group_replication_flow_control_member_quota_percent= 1;
138 include/assert.inc [group_replication_flow_control_member_quota_percent is correct]
139 SET GLOBAL group_replication_flow_control_member_quota_percent= 100;
140 include/assert.inc [group_replication_flow_control_member_quota_percent is correct]
141
142 ############################################################
143 # 8. Test group_replication_flow_control_period option.
144 SET GLOBAL group_replication_flow_control_period= "";
145 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_period'
146 SET GLOBAL group_replication_flow_control_period= 0;
147 Warnings:
148 Warning 1292 Truncated incorrect group_replication_flow_control_period value: '0'
149 include/assert.inc [group_replication_flow_control_period is truncated]
150 SET GLOBAL group_replication_flow_control_period= 61;
151 Warnings:
152 Warning 1292 Truncated incorrect group_replication_flow_control_period value: '61'
153 include/assert.inc [group_replication_flow_control_period is truncated]
154 SET GLOBAL group_replication_flow_control_period= 1;
155 include/assert.inc [group_replication_flow_control_period is correct]
156 SET GLOBAL group_replication_flow_control_period= 60;
157 include/assert.inc [group_replication_flow_control_period is correct]
158
159 ############################################################
160 # 9. Test group_replication_flow_control_hold_percent
161 # option.
162
163 SET GLOBAL group_replication_flow_control_hold_percent= "";
164 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_hold_percent'
165 SET GLOBAL group_replication_flow_control_hold_percent= -1;
166 Warnings:
167 Warning 1292 Truncated incorrect group_replication_flow_control_hold_percent value: '-1'
168 include/assert.inc [group_replication_flow_control_hold_percent is truncated]
169 SET GLOBAL group_replication_flow_control_hold_percent= 101;
170 Warnings:
171 Warning 1292 Truncated incorrect group_replication_flow_control_hold_percent value: '101'
172 include/assert.inc [group_replication_flow_control_hold_percent is truncated]
173 SET GLOBAL group_replication_flow_control_hold_percent= 1;
174 include/assert.inc [group_replication_flow_control_hold_percent is correct]
175 SET GLOBAL group_replication_flow_control_hold_percent= 100;
176 include/assert.inc [group_replication_flow_control_hold_percent is correct]
177 ############################################################
178 # 10. Test group_replication_flow_control_release_percent
179 # option.
180 SET GLOBAL group_replication_flow_control_release_percent= "";
181 ERROR 42000: Incorrect argument type to variable 'group_replication_flow_control_release_percent'
182 SET GLOBAL group_replication_flow_control_release_percent= -1;
183 Warnings:
184 Warning 1292 Truncated incorrect group_replication_flow_control_release_percent value: '-1'
185 include/assert.inc [group_replication_flow_control_release_percent is truncated]
186 SET GLOBAL group_replication_flow_control_release_percent= 1001;
187 Warnings:
188 Warning 1292 Truncated incorrect group_replication_flow_control_release_percent value: '1001'
189 include/assert.inc [group_replication_flow_control_release_percent is truncated]
190 SET GLOBAL group_replication_flow_control_release_percent= 1;
191 include/assert.inc [group_replication_flow_control_release_percent is correct]
192 SET GLOBAL group_replication_flow_control_release_percent= 1000;
193 include/assert.inc [group_replication_flow_control_release_percent is correct]
194
195 ############################################################
196 # 11. Test group_replication_flow_control_max_quota
197 # option.
198 SET GLOBAL group_replication_flow_control_min_recovery_quota= 10;
199 SET GLOBAL group_replication_flow_control_min_quota= 10;
200 SET GLOBAL group_replication_flow_control_max_quota= 100;
201 SET GLOBAL group_replication_flow_control_min_quota= 1000;
202 ERROR 42000: group_replication_flow_control_min_quota cannot be larger than group_replication_flow_control_max_quota
203 include/assert.inc [group_replication_flow_control_min_quota cannot be larger than max_quota]
204 SET GLOBAL group_replication_flow_control_min_recovery_quota= 1000;
205 ERROR 42000: group_replication_flow_control_min_recovery_quota cannot be larger than group_replication_flow_control_max_quota
206 include/assert.inc [group_replication_flow_control_min_recovery_quota cannot be larger than max_quota]
207 SET GLOBAL group_replication_flow_control_max_quota= 1;
208 ERROR 42000: group_replication_flow_control_max_quota cannot be smaller than group_replication_flow_control_min_quota or group_replication_flow_control_min_recovery_quota
209 include/assert.inc [group_replication_flow_control_max_quota cannot be lower than min_quota or min_recovery_quota]
210 SET GLOBAL group_replication_flow_control_min_recovery_quota= 0;
211 SET GLOBAL group_replication_flow_control_min_quota= 0;
212 SET GLOBAL group_replication_flow_control_max_quota= 0;
213
214 ############################################################
215 # 12. Change all group_replication_flow_control options while
216 # Group Replication is running.
217 include/start_and_bootstrap_group_replication.inc
218 SET GLOBAL group_replication_flow_control_mode= DISABLED;
219 include/assert.inc [group_replication_flow_control_mode is correct]
220 SET GLOBAL group_replication_flow_control_mode= QUOTA;
221 include/assert.inc [group_replication_flow_control_mode is correct]
222 SET GLOBAL group_replication_flow_control_certifier_threshold= 1000;
223 include/assert.inc [group_replication_flow_control_certifier_threshold is correct]
224 SET GLOBAL group_replication_flow_control_applier_threshold= 1000;
225 include/assert.inc [group_replication_flow_control_applier_threshold is correct]
226 SET GLOBAL group_replication_flow_control_min_quota= 1000;
227 include/assert.inc [group_replication_flow_control_min_quota is correct]
228 SET GLOBAL group_replication_flow_control_min_recovery_quota= 1000;
229 include/assert.inc [group_replication_flow_control_min_recovery_quota is correct]
230 SET GLOBAL group_replication_flow_control_max_quota= 2000;
231 include/assert.inc [group_replication_flow_control_max_quota is correct]
232 SET GLOBAL group_replication_flow_control_member_quota_percent= 50;
233 include/assert.inc [group_replication_flow_control_member_quota_percent is correct]
234 SET GLOBAL group_replication_flow_control_period= 10;
235 include/assert.inc [group_replication_flow_control_period is correct]
236 SET GLOBAL group_replication_flow_control_hold_percent= 15;
237 include/assert.inc [group_replication_flow_control_hold_percent is correct]
238 SET GLOBAL group_replication_flow_control_release_percent= 150;
239 include/assert.inc [group_replication_flow_control_release_percent is correct]
240
241 ############################################################
242 # 13. Set group_replication_flow_control options on command
243 # line during server start and then start Group
244 # Replication.
245 [connection server2]
246 include/start_group_replication.inc
247 set session sql_log_bin=0;
248 CALL mtr.add_suppression("group_replication_flow_control_min_quota cannot be larger than group_replication_flow_control_max_quota");
249 CALL mtr.add_suppression("group_replication_flow_control_min_recovery_quota cannot be larger than group_replication_flow_control_max_quota");
250 CALL mtr.add_suppression("group_replication_flow_control_max_quota cannot be smaller than group_replication_flow_control_min_quota or group_replication_flow_control_min_recovery_quota");
251 set session sql_log_bin=1;
252 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_flow_control_max_quota=10 --group_replication_flow_control_min_quota=20
253 START GROUP_REPLICATION;
254 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
255 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_flow_control_min_quota=20 --group_replication_flow_control_max_quota=10
256 START GROUP_REPLICATION;
257 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
258 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_flow_control_min_recovery_quota=20 --group_replication_flow_control_max_quota=10
259 START GROUP_REPLICATION;
260 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
261
262 ############################################################
263 # Clean up.
264 # restart:--group_replication_group_name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS
265 include/rpl_reconnect.inc
266 [connection server1]
267 SET GLOBAL group_replication_flow_control_mode= @group_replication_flow_control_mode_save;
268 SET GLOBAL group_replication_flow_control_certifier_threshold= @group_replication_flow_control_certifier_threshold_save;
269 SET GLOBAL group_replication_flow_control_applier_threshold= @group_replication_flow_control_applier_threshold_save;
270 SET GLOBAL group_replication_flow_control_min_quota=@group_replication_flow_control_min_quota_save;
271 SET GLOBAL group_replication_flow_control_min_recovery_quota=@group_replication_flow_control_min_recovery_quota_save;
272 SET GLOBAL group_replication_flow_control_max_quota=@group_replication_flow_control_max_quota_save;
273 SET GLOBAL group_replication_flow_control_member_quota_percent=@group_replication_flow_control_member_quota_percent_save;
274 SET GLOBAL group_replication_flow_control_period=@group_replication_flow_control_period_save;
275 SET GLOBAL group_replication_flow_control_hold_percent=@group_replication_flow_control_hold_percent_save;
276 SET GLOBAL group_replication_flow_control_release_percent=@group_replication_flow_control_release_percent_save;
277 SET @@GLOBAL.DEBUG= @debug_saved;
278 include/group_replication_end.inc