Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=2]
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 [connection server1]
7 Starting GR on server 1
8 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-eeee-aaaa-aaaa-aaaaaaaaaaaa'
9
10 0 rows affected
11 RUN SET @@GLOBAL.group_replication_ip_allowlist= "AUTOMATIC"
12
13 0 rows affected
14 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=1
15
16 0 rows affected
17 RUN START GROUP_REPLICATION
18
19 0 rows affected
20 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=0
21
22 0 rows affected
23 Mysqlx.Ok {
24 msg: "bye!"
25 }
26 ok
27 include/gr_wait_for_member_state.inc
28 include/assert.inc [group_replication_allow_local_lower_version_join is OFF]
29 include/assert.inc [group_replication_auto_increment_increment is 7]
30 include/assert.inc [group_replication_components_stop_timeout is 300]
31 include/assert.inc [group_replication_compression_threshold is 1000000]
32 include/assert.inc [group_replication_enforce_update_everywhere_checks is ON]
33 include/assert.inc [group_replication_flow_control_applier_threshold is 25000]
34 include/assert.inc [group_replication_flow_control_certifier_threshold is 25000]
35 include/assert.inc [group_replication_flow_control_mode is QUOTA]
36 include/assert.inc [group_replication_ip_allowlist is AUTOMATIC]
37 include/assert.inc [group_replication_poll_spin_loops is 0]
38 include/assert.inc [group_replication_recovery_complete_at is TRANSACTIONS_APPLIED]
39 include/assert.inc [group_replication_recovery_reconnect_interval is 60]
40 include/assert.inc [group_replication_recovery_retry_count is 10]
41 include/assert.inc [group_replication_start_on_boot is OFF]
42 include/assert.inc [group_replication_single_primary_mode is OFF]
43 include/stop_group_replication.inc
44 SET @group_replication_allow_local_lower_version_join_save= @@GLOBAL.group_replication_allow_local_lower_version_join;
45 SET @group_replication_auto_increment_increment_save= @@GLOBAL.group_replication_auto_increment_increment;
46 SET @group_replication_components_stop_timeout_save= @@GLOBAL.group_replication_components_stop_timeout;
47 SET @group_replication_compression_threshold_save= @@GLOBAL.group_replication_compression_threshold;
48 SET @group_replication_enforce_update_everywhere_checks_save= @@GLOBAL.group_replication_enforce_update_everywhere_checks;
49 SET @group_replication_flow_control_applier_threshold_save= @@GLOBAL.group_replication_flow_control_applier_threshold;
50 SET @group_replication_flow_control_certifier_threshold_save= @@GLOBAL.group_replication_flow_control_certifier_threshold;
51 SET @group_replication_flow_control_mode_save= @@GLOBAL.group_replication_flow_control_mode;
52 SET @group_replication_group_name_save= @@GLOBAL.group_replication_group_name;
53 SET @group_replication_gtid_assignment_block_size_save= @@GLOBAL.group_replication_gtid_assignment_block_size;
54 SET @group_replication_group_seeds_save= @@GLOBAL.group_replication_group_seeds;
55 SET @group_replication_local_address_save= @@GLOBAL.group_replication_local_address;
56 SET @group_replication_poll_spin_loops_save= @@GLOBAL.group_replication_poll_spin_loops;
57 SET @group_replication_recovery_complete_at_save= @@GLOBAL.group_replication_recovery_complete_at;
58 SET @group_replication_recovery_reconnect_interval_save= @@GLOBAL.group_replication_recovery_reconnect_interval;
59 SET @group_replication_recovery_retry_count_save= @@GLOBAL.group_replication_recovery_retry_count;
60 SET @group_replication_recovery_ssl_ca_save= @@GLOBAL.group_replication_recovery_ssl_ca;
61 SET @group_replication_recovery_ssl_capath_save= @@GLOBAL.group_replication_recovery_ssl_capath;
62 SET @group_replication_recovery_ssl_cert_save= @@GLOBAL.group_replication_recovery_ssl_cert;
63 SET @group_replication_recovery_ssl_cipher_save= @@GLOBAL.group_replication_recovery_ssl_cipher;
64 SET @group_replication_recovery_ssl_crl_save= @@GLOBAL.group_replication_recovery_ssl_crl;
65 SET @group_replication_recovery_ssl_crlpath_save= @@GLOBAL.group_replication_recovery_ssl_crlpath;
66 SET @group_replication_recovery_ssl_key_save= @@GLOBAL.group_replication_recovery_ssl_key;
67 SET @group_replication_recovery_ssl_verify_server_cert_save= @@GLOBAL.group_replication_recovery_ssl_verify_server_cert;
68 SET @group_replication_recovery_use_ssl_save= @@GLOBAL.group_replication_recovery_use_ssl;
69 SET @group_replication_single_primary_mode_save= @@GLOBAL.group_replication_single_primary_mode;
70 SET @group_replication_ssl_mode_save= @@GLOBAL.group_replication_ssl_mode;
71 SET @group_replication_start_on_boot_save= @@GLOBAL.group_replication_start_on_boot;
72 SET @group_replication_recovery_public_key_path_save= @@GLOBAL.group_replication_recovery_public_key_path;
73 SET @group_replication_recovery_get_public_key_save= @@GLOBAL.group_replication_recovery_get_public_key;
74 RUN SET GLOBAL group_replication_allow_local_lower_version_join= ON
75
76 0 rows affected
77 RUN SET GLOBAL group_replication_auto_increment_increment= 5
78
79 0 rows affected
80 RUN SET GLOBAL group_replication_bootstrap_group= 1
81
82 0 rows affected
83 RUN SET GLOBAL group_replication_components_stop_timeout= 10
84
85 0 rows affected
86 RUN SET GLOBAL group_replication_compression_threshold= 10
87
88 0 rows affected
89 RUN SET GLOBAL group_replication_enforce_update_everywhere_checks= OFF
90
91 0 rows affected
92 RUN SET GLOBAL group_replication_flow_control_applier_threshold= 50000
93
94 0 rows affected
95 RUN SET GLOBAL group_replication_flow_control_certifier_threshold= 50000
96
97 0 rows affected
98 RUN SET GLOBAL group_replication_flow_control_mode= "DISABLED"
99
100 0 rows affected
101 RUN SET GLOBAL group_replication_force_members= ""
102
103 0 rows affected
104 RUN SET GLOBAL group_replication_group_name= "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab"
105
106 0 rows affected
107 RUN SET GLOBAL group_replication_group_seeds= CONCAT("localhost:",xcom_port)
108
109 0 rows affected
110 RUN SET GLOBAL group_replication_gtid_assignment_block_size= 2
111
112 0 rows affected
113 RUN SET GLOBAL group_replication_ip_allowlist= "AUTOMATIC"
114
115 0 rows affected
116 RUN SET GLOBAL group_replication_local_address= CONCAT("localhost:",xcom_port)
117
118 0 rows affected
119 RUN SET GLOBAL group_replication_poll_spin_loops= 10
120
121 0 rows affected
122 RUN SET GLOBAL group_replication_recovery_complete_at= TRANSACTIONS_CERTIFIED
123
124 0 rows affected
125 RUN SET GLOBAL group_replication_recovery_reconnect_interval= 20
126
127 0 rows affected
128 RUN SET GLOBAL group_replication_recovery_retry_count= 5
129
130 0 rows affected
131 RUN SET GLOBAL group_replication_recovery_ssl_ca= 'MYSQL_TEST_DIR/std_data/cacert.pem'
132
133 0 rows affected
134 RUN SET GLOBAL group_replication_recovery_ssl_capath= 'MYSQL_TEST_DIR/std_data'
135
136 0 rows affected
137 RUN SET GLOBAL group_replication_recovery_ssl_cert= 'MYSQL_TEST_DIR/std_data/client-cert.pem'
138
139 0 rows affected
140 RUN SET GLOBAL group_replication_recovery_ssl_cipher= 'ECDHE-RSA-AES128-GCM-SHA256'
141
142 0 rows affected
143 RUN SET GLOBAL group_replication_recovery_ssl_crl= 'crl-client-revoked.crl'
144
145 0 rows affected
146 RUN SET GLOBAL group_replication_recovery_ssl_crlpath= 'MYSQL_TEST_DIR/std_data'
147
148 0 rows affected
149 RUN SET GLOBAL group_replication_recovery_ssl_key= 'MYSQL_TEST_DIR/std_data/client-key.pem'
150
151 0 rows affected
152 RUN SET GLOBAl group_replication_recovery_ssl_verify_server_cert= ON
153
154 0 rows affected
155 RUN SET GLOBAL group_replication_recovery_use_ssl= ON
156
157 0 rows affected
158 RUN SET GLOBAL group_replication_single_primary_mode= ON
159
160 0 rows affected
161 RUN SET GLOBAL group_replication_ssl_mode= "VERIFY_CA"
162
163 0 rows affected
164 RUN SET GLOBAL group_replication_start_on_boot= ON
165
166 0 rows affected
167 RUN SET GLOBAL group_replication_recovery_get_public_key= ON
168
169 0 rows affected
170 RUN SET GLOBAL group_replication_recovery_public_key_path= 'MYSQL_TEST_DIR/std_data/rsa_public_key.pem'
171
172 0 rows affected
173 Mysqlx.Ok {
174 msg: "bye!"
175 }
176 ok
177 START GROUP_REPLICATION;
178 Warnings:
179 Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
180 include/assert.inc [group_replication_allow_local_lower_version_join is ON]
181 include/assert.inc [group_replication_auto_increment_increment is 5]
182 include/assert.inc [group_replication_components_stop_timeout is 10]
183 include/assert.inc [group_replication_compression_threshold is 10]
184 include/assert.inc [group_replication_enforce_update_everywhere_checks is OFF]
185 include/assert.inc [group_replication_flow_control_applier_threshold is 50000]
186 include/assert.inc [group_replication_flow_control_certifier_threshold is 50000]
187 include/assert.inc [group_replication_flow_control_mode is DISABLED]
188 include/assert.inc [group_replication_force_members is ""]
189 include/assert.inc [group_replication_group_name is aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaab]
190 include/assert.inc [group_replication_group_seeds is 127.0.0.1:xcom_port]
191 include/assert.inc [group_replication_gtid_assignment_block_size is 2]
192 include/assert.inc [group_replication_ip_allowlist is AUTOMATIC]
193 include/assert.inc [group_replication_local_address is 127.0.0.1:xcom_port]
194 include/assert.inc [group_replication_recovery_complete_at is TRANSACTIONS_CERTIFIED]
195 include/assert.inc [group_replication_recovery_reconnect_interval is 20]
196 include/assert.inc [group_replication_recovery_retry_count is 5]
197 include/assert.inc [group_replication_recovery_ssl_ca is MYSQL_TEST_DIR/std_data/cacert.pem]
198 include/assert.inc [group_replication_recovery_ssl_capath is MYSQL_TEST_DIR/std_data]
199 include/assert.inc [group_replication_recovery_ssl_cert is MYSQL_TEST_DIR/std_data/client-cert.pem]
200 include/assert.inc [group_replication_recovery_ssl_cipher is ECDHE-RSA-AES128-GCM-SHA256]
201 include/assert.inc [group_replication_recovery_ssl_crl is crl-client-revoked.crl]
202 include/assert.inc [group_replication_recovery_ssl_crlpath is MYSQL_TEST_DIR/std_data]
203 include/assert.inc [group_replication_recovery_ssl_key is MYSQL_TEST_DIR/std_data/client-key.pem]
204 include/assert.inc [group_replication_recovery_ssl_verify_server_cert is ON]
205 include/assert.inc [group_replication_recovery_use_ssl is ON]
206 include/assert.inc [group_replication_single_primary_mode is ON]
207 include/assert.inc [group_replication_start_on_boot is ON]
208 include/assert.inc [group_replication_ssl_mode is VERIFY_CA]
209 include/assert.inc [group_replication_recovery_public_key_path is MYSQL_TEST_DIR/std_data/rsa_public_key.pem]
210 include/assert.inc [group_replication_recovery_get_public_key is ON]
211 Stopping GR on server 1
212 RUN STOP GROUP_REPLICATION;
213
214 0 rows affected
215 Mysqlx.Ok {
216 msg: "bye!"
217 }
218 ok
219 include/gr_wait_for_member_state.inc
220 include/assert_and_disable_read_only.inc
221 SET GLOBAL group_replication_allow_local_lower_version_join= @group_replication_allow_local_lower_version_join_save;
222 SET GLOBAL group_replication_auto_increment_increment= @group_replication_auto_increment_increment_save;
223 SET GLOBAL group_replication_components_stop_timeout= @group_replication_components_stop_timeout_save;
224 SET GLOBAL group_replication_compression_threshold= @group_replication_compression_threshold_save;
225 SET GLOBAL group_replication_flow_control_applier_threshold= @group_replication_flow_control_applier_threshold_save;
226 SET GLOBAL group_replication_flow_control_certifier_threshold= @group_replication_flow_control_certifier_threshold_save;
227 SET GLOBAL group_replication_flow_control_mode= @group_replication_flow_control_mode_save;
228 SET GLOBAL group_replication_group_name =@group_replication_group_name_save;
229 SET GLOBAL group_replication_group_seeds= @group_replication_group_seeds_save;
230 SET GLOBAL group_replication_gtid_assignment_block_size= @group_replication_gtid_assignment_block_size_save;
231 SET GLOBAL group_replication_local_address= @group_replication_local_address_save;
232 SET GLOBAL group_replication_group_seeds= @group_replication_group_seeds_save;
233 SET GLOBAL group_replication_recovery_complete_at= @group_replication_recovery_complete_at_save;
234 Warnings:
235 Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
236 SET GLOBAL group_replication_poll_spin_loops= @group_replication_poll_spin_loops_save;
237 SET GLOBAL group_replication_recovery_reconnect_interval= @group_replication_recovery_reconnect_interval_save;
238 SET GLOBAL group_replication_recovery_retry_count= @group_replication_recovery_retry_count_save;
239 SET GLOBAL group_replication_recovery_ssl_ca= @group_replication_recovery_ssl_ca_save;
240 SET GLOBAL group_replication_recovery_ssl_capath= @group_replication_recovery_ssl_capath_save;
241 SET GLOBAL group_replication_recovery_ssl_cert= @group_replication_recovery_ssl_cert_save;
242 SET GLOBAL group_replication_recovery_ssl_cipher= @group_replication_recovery_ssl_cipher_save;
243 SET GLOBAL group_replication_recovery_ssl_crl= @group_replication_recovery_ssl_crl_save;
244 SET GLOBAL group_replication_recovery_ssl_crlpath= @group_replication_recovery_ssl_crlpath_save;
245 SET GLOBAL group_replication_recovery_ssl_key= @group_replication_recovery_ssl_key_save;
246 SET GLOBAL group_replication_recovery_ssl_verify_server_cert= @group_replication_recovery_ssl_verify_server_cert_save;
247 SET GLOBAL group_replication_recovery_use_ssl= @group_replication_recovery_use_ssl_save;
248 SET GLOBAL group_replication_single_primary_mode= @group_replication_single_primary_mode_save;
249 SET GLOBAL group_replication_ssl_mode= @group_replication_ssl_mode_save;
250 SET GLOBAL group_replication_start_on_boot= @group_replication_start_on_boot_save;
251 SET GLOBAL group_replication_enforce_update_everywhere_checks= @group_replication_enforce_update_everywhere_checks_save;
252 SET GLOBAL group_replication_recovery_public_key_path= @group_replication_recovery_public_key_path_save;
253 SET GLOBAL group_replication_recovery_get_public_key= @group_replication_recovery_get_public_key_save;
254 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-eeee-aaaa-aaaa-aaaaaaaaaaaa'
255
256 0 rows affected
257 RUN SET @@GLOBAL.group_replication_ip_allowlist= "AUTOMATIC"
258
259 0 rows affected
260 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=1
261
262 0 rows affected
263 RUN START GROUP_REPLICATION
264
265 0 rows affected
266 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=0
267
268 0 rows affected
269 Mysqlx.Ok {
270 msg: "bye!"
271 }
272 ok
273 include/gr_wait_for_member_state.inc
274 RUN STOP GROUP_REPLICATION;
275
276 0 rows affected
277 Mysqlx.Ok {
278 msg: "bye!"
279 }
280 ok
281 [connection server1]
282 include/gr_wait_for_member_state.inc
283 include/assert_and_disable_read_only.inc
284 include/group_replication_end.inc