Debian Codegraph @

mysql-test/suite/group_replication/r/gr_set_option_during_stop.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 ############################################################
7 # 1. Bootstrap a group on server1.
8 # Setup a debug point that will block a future
9 # STOP GROUP_REPLICATION command
10 # after the plugin_running_lock is acquired.
11 [connection server1]
12 include/start_and_bootstrap_group_replication.inc
13 SET @@GLOBAL.DEBUG='+d,gr_plugin_gr_stop_after_holding_plugin_running_lock';
14 ############################################################
15 # 2. Asynchronously execute STOP GROUP_REPLICATION command.
16 [connection server_1]
17 STOP GROUP_REPLICATION;
18 [connection server1]
19 SET DEBUG_SYNC= "now WAIT_FOR signal.reached_plugin_gr_stop_after_holding_plugin_running_lock";
20 SET @@GLOBAL.DEBUG='-d,gr_plugin_gr_stop_after_holding_plugin_running_lock';
21 ############################################################
22 # 3. Try to change Group Replication options that cannot be
23 # change while a STOP GROUP_REPLICATION is ongoing, they
24 # must fail.
25 [connection server1]
26 SET SESSION sql_log_bin = 0;
27 CREATE TABLE gr_options_that_cannot_be_change (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(64) UNIQUE KEY);
28 INSERT INTO gr_options_that_cannot_be_change (name)
29 SELECT VARIABLE_NAME FROM performance_schema.global_variables
30 WHERE VARIABLE_NAME LIKE 'group_replication_%'
31 AND VARIABLE_NAME != 'group_replication_allow_local_lower_version_join'
32 AND VARIABLE_NAME != 'group_replication_bootstrap_group'
33 AND VARIABLE_NAME != 'group_replication_communication_stack'
34 AND VARIABLE_NAME != 'group_replication_consistency'
35 AND VARIABLE_NAME != 'group_replication_exit_state_action'
36 AND VARIABLE_NAME NOT LIKE 'group_replication_flow_control_%'
37 AND VARIABLE_NAME != 'group_replication_group_seeds'
38 AND VARIABLE_NAME != 'group_replication_local_address'
39 AND VARIABLE_NAME != 'group_replication_poll_spin_loops'
40 AND VARIABLE_NAME != 'group_replication_ssl_mode'
41 AND VARIABLE_NAME != 'group_replication_start_on_boot'
42 AND VARIABLE_NAME != 'group_replication_tls_source'
43 AND VARIABLE_NAME != 'group_replication_transaction_size_limit'
44 ORDER BY VARIABLE_NAME;
45 SET SESSION sql_log_bin = 1;
46 SET @value= @@GLOBAL.group_replication_advertise_recovery_endpoints;
47 SET @@GLOBAL.group_replication_advertise_recovery_endpoints= @value;
48 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
49 SET @value= @@GLOBAL.group_replication_auto_increment_increment;
50 SET @@GLOBAL.group_replication_auto_increment_increment= @value;
51 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
52 SET @value= @@GLOBAL.group_replication_autorejoin_tries;
53 SET @@GLOBAL.group_replication_autorejoin_tries= @value;
54 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
55 SET @value= @@GLOBAL.group_replication_clone_threshold;
56 SET @@GLOBAL.group_replication_clone_threshold= @value;
57 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
58 SET @value= @@GLOBAL.group_replication_communication_debug_options;
59 SET @@GLOBAL.group_replication_communication_debug_options= @value;
60 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
61 SET @value= @@GLOBAL.group_replication_communication_max_message_size;
62 SET @@GLOBAL.group_replication_communication_max_message_size= @value;
63 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
64 SET @value= @@GLOBAL.group_replication_components_stop_timeout;
65 SET @@GLOBAL.group_replication_components_stop_timeout= @value;
66 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
67 SET @value= @@GLOBAL.group_replication_compression_threshold;
68 SET @@GLOBAL.group_replication_compression_threshold= @value;
69 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
70 SET @value= @@GLOBAL.group_replication_enforce_update_everywhere_checks;
71 SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= @value;
72 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
73 SET @value= @@GLOBAL.group_replication_force_members;
74 SET @@GLOBAL.group_replication_force_members= @value;
75 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
76 SET @value= @@GLOBAL.group_replication_group_name;
77 SET @@GLOBAL.group_replication_group_name= @value;
78 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
79 SET @value= @@GLOBAL.group_replication_gtid_assignment_block_size;
80 SET @@GLOBAL.group_replication_gtid_assignment_block_size= @value;
81 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
82 SET @value= @@GLOBAL.group_replication_ip_allowlist;
83 SET @@GLOBAL.group_replication_ip_allowlist= @value;
84 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
85 SET @value= @@GLOBAL.group_replication_ip_whitelist;
86 SET @@GLOBAL.group_replication_ip_whitelist= @value;
87 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
88 SET @value= @@GLOBAL.group_replication_member_expel_timeout;
89 SET @@GLOBAL.group_replication_member_expel_timeout= @value;
90 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
91 SET @value= @@GLOBAL.group_replication_member_weight;
92 SET @@GLOBAL.group_replication_member_weight= @value;
93 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
94 SET @value= @@GLOBAL.group_replication_message_cache_size;
95 SET @@GLOBAL.group_replication_message_cache_size= @value;
96 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
97 SET @value= @@GLOBAL.group_replication_paxos_single_leader;
98 SET @@GLOBAL.group_replication_paxos_single_leader= @value;
99 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
100 SET @value= @@GLOBAL.group_replication_recovery_complete_at;
101 SET @@GLOBAL.group_replication_recovery_complete_at= @value;
102 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
103 SET @value= @@GLOBAL.group_replication_recovery_compression_algorithms;
104 SET @@GLOBAL.group_replication_recovery_compression_algorithms= @value;
105 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
106 SET @value= @@GLOBAL.group_replication_recovery_get_public_key;
107 SET @@GLOBAL.group_replication_recovery_get_public_key= @value;
108 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
109 SET @value= @@GLOBAL.group_replication_recovery_public_key_path;
110 SET @@GLOBAL.group_replication_recovery_public_key_path= @value;
111 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
112 SET @value= @@GLOBAL.group_replication_recovery_reconnect_interval;
113 SET @@GLOBAL.group_replication_recovery_reconnect_interval= @value;
114 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
115 SET @value= @@GLOBAL.group_replication_recovery_retry_count;
116 SET @@GLOBAL.group_replication_recovery_retry_count= @value;
117 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
118 SET @value= @@GLOBAL.group_replication_recovery_ssl_ca;
119 SET @@GLOBAL.group_replication_recovery_ssl_ca= @value;
120 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
121 SET @value= @@GLOBAL.group_replication_recovery_ssl_capath;
122 SET @@GLOBAL.group_replication_recovery_ssl_capath= @value;
123 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
124 SET @value= @@GLOBAL.group_replication_recovery_ssl_cert;
125 SET @@GLOBAL.group_replication_recovery_ssl_cert= @value;
126 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
127 SET @value= @@GLOBAL.group_replication_recovery_ssl_cipher;
128 SET @@GLOBAL.group_replication_recovery_ssl_cipher= @value;
129 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
130 SET @value= @@GLOBAL.group_replication_recovery_ssl_crl;
131 SET @@GLOBAL.group_replication_recovery_ssl_crl= @value;
132 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
133 SET @value= @@GLOBAL.group_replication_recovery_ssl_crlpath;
134 SET @@GLOBAL.group_replication_recovery_ssl_crlpath= @value;
135 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
136 SET @value= @@GLOBAL.group_replication_recovery_ssl_key;
137 SET @@GLOBAL.group_replication_recovery_ssl_key= @value;
138 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
139 SET @value= @@GLOBAL.group_replication_recovery_ssl_verify_server_cert;
140 SET @@GLOBAL.group_replication_recovery_ssl_verify_server_cert= @value;
141 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
142 SET @value= @@GLOBAL.group_replication_recovery_tls_ciphersuites;
143 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= @value;
144 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
145 SET @value= @@GLOBAL.group_replication_recovery_tls_version;
146 SET @@GLOBAL.group_replication_recovery_tls_version= @value;
147 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
148 SET @value= @@GLOBAL.group_replication_recovery_use_ssl;
149 SET @@GLOBAL.group_replication_recovery_use_ssl= @value;
150 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
151 SET @value= @@GLOBAL.group_replication_recovery_zstd_compression_level;
152 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= @value;
153 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
154 SET @value= @@GLOBAL.group_replication_single_primary_mode;
155 SET @@GLOBAL.group_replication_single_primary_mode= @value;
156 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
157 SET @value= @@GLOBAL.group_replication_unreachable_majority_timeout;
158 SET @@GLOBAL.group_replication_unreachable_majority_timeout= @value;
159 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
160 SET @value= @@GLOBAL.group_replication_view_change_uuid;
161 SET @@GLOBAL.group_replication_view_change_uuid= @value;
162 ERROR HY000: This option cannot be set while START or STOP GROUP_REPLICATION is ongoing.
163 ############################################################
164 # 4. Change Group Replication options that can be
165 # change while a STOP GROUP_REPLICATION is ongoing.
166 [connection server1]
167 SET SESSION sql_log_bin = 0;
168 CREATE TABLE gr_options_that_can_be_change (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(64) UNIQUE KEY);
169 INSERT INTO gr_options_that_can_be_change (name)
170 SELECT gb.VARIABLE_NAME FROM performance_schema.global_variables gb
171 WHERE gb.VARIABLE_NAME LIKE 'group_replication_%'
172 AND gb.VARIABLE_NAME NOT IN (SELECT name FROM gr_options_that_cannot_be_change)
173 ORDER BY gb.VARIABLE_NAME;
174 SET SESSION sql_log_bin = 1;
175 SET @value= @@GLOBAL.group_replication_allow_local_lower_version_join;
176 SET @@GLOBAL.group_replication_allow_local_lower_version_join= @value;
177 SET @value= @@GLOBAL.group_replication_bootstrap_group;
178 SET @@GLOBAL.group_replication_bootstrap_group= @value;
179 SET @value= @@GLOBAL.group_replication_communication_stack;
180 SET @@GLOBAL.group_replication_communication_stack= @value;
181 SET @value= @@GLOBAL.group_replication_consistency;
182 SET @@GLOBAL.group_replication_consistency= @value;
183 SET @value= @@GLOBAL.group_replication_exit_state_action;
184 SET @@GLOBAL.group_replication_exit_state_action= @value;
185 SET @value= @@GLOBAL.group_replication_flow_control_applier_threshold;
186 SET @@GLOBAL.group_replication_flow_control_applier_threshold= @value;
187 SET @value= @@GLOBAL.group_replication_flow_control_certifier_threshold;
188 SET @@GLOBAL.group_replication_flow_control_certifier_threshold= @value;
189 SET @value= @@GLOBAL.group_replication_flow_control_hold_percent;
190 SET @@GLOBAL.group_replication_flow_control_hold_percent= @value;
191 SET @value= @@GLOBAL.group_replication_flow_control_max_quota;
192 SET @@GLOBAL.group_replication_flow_control_max_quota= @value;
193 SET @value= @@GLOBAL.group_replication_flow_control_member_quota_percent;
194 SET @@GLOBAL.group_replication_flow_control_member_quota_percent= @value;
195 SET @value= @@GLOBAL.group_replication_flow_control_min_quota;
196 SET @@GLOBAL.group_replication_flow_control_min_quota= @value;
197 SET @value= @@GLOBAL.group_replication_flow_control_min_recovery_quota;
198 SET @@GLOBAL.group_replication_flow_control_min_recovery_quota= @value;
199 SET @value= @@GLOBAL.group_replication_flow_control_mode;
200 SET @@GLOBAL.group_replication_flow_control_mode= @value;
201 SET @value= @@GLOBAL.group_replication_flow_control_period;
202 SET @@GLOBAL.group_replication_flow_control_period= @value;
203 SET @value= @@GLOBAL.group_replication_flow_control_release_percent;
204 SET @@GLOBAL.group_replication_flow_control_release_percent= @value;
205 SET @value= @@GLOBAL.group_replication_group_seeds;
206 SET @@GLOBAL.group_replication_group_seeds= @value;
207 SET @value= @@GLOBAL.group_replication_local_address;
208 SET @@GLOBAL.group_replication_local_address= @value;
209 SET @value= @@GLOBAL.group_replication_poll_spin_loops;
210 SET @@GLOBAL.group_replication_poll_spin_loops= @value;
211 SET @value= @@GLOBAL.group_replication_ssl_mode;
212 SET @@GLOBAL.group_replication_ssl_mode= @value;
213 SET @value= @@GLOBAL.group_replication_start_on_boot;
214 SET @@GLOBAL.group_replication_start_on_boot= @value;
215 SET @value= @@GLOBAL.group_replication_tls_source;
216 SET @@GLOBAL.group_replication_tls_source= @value;
217 SET @value= @@GLOBAL.group_replication_transaction_size_limit;
218 SET @@GLOBAL.group_replication_transaction_size_limit= @value;
219 ############################################################
220 # 5. Validate that we did test all Group Replication options.
221 [connection server1]
222 include/assert.inc [Validate that we did test all Group Replication options]
223 ############################################################
224 # 6. Resume the STOP GROUP_REPLICATION command.
225 [connection server1]
226 SET DEBUG_SYNC= "now SIGNAL signal.resume_plugin_gr_stop_after_holding_plugin_running_lock";
227 [connection server_1]
228 include/gr_wait_for_member_state.inc
229 ############################################################
230 # 7. Clean up.
231 [connection server1]
232 SET DEBUG_SYNC= 'RESET';
233 SET @@GLOBAL.read_only= 0;
234 SET SESSION sql_log_bin = 0;
235 DROP TABLE gr_options_that_cannot_be_change;
236 DROP TABLE gr_options_that_can_be_change;
237 SET SESSION sql_log_bin = 1;
238 include/group_replication_end.inc