Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_persist_variables.result

raw
1 ############################################################
2 # 0. Check that there are no persisted variable settings.
3 include/assert.inc [Expect 0 persisted variables.]
4
5 ############################################################
6 # 1. Initialization. Test SET PERSIST. Verify persisted
7 # variables.
8 CALL mtr.add_suppression("Unsafe statement written to the binary log");
9 # Install semi-sync related plugins
10 INSTALL PLUGIN rpl_semi_sync_source SONAME 'SEMISYNC_SOURCE_PLUGIN';
11 INSTALL PLUGIN rpl_semi_sync_replica SONAME 'SEMISYNC_REPLICA_PLUGIN';
12 CREATE TABLE rplvars (id INT PRIMARY KEY AUTO_INCREMENT, varname VARCHAR(64), varvalue VARCHAR(256));
13 INSERT INTO rplvars (varname, varvalue)
14 SELECT * FROM performance_schema.global_variables
15 WHERE (VARIABLE_NAME LIKE '%binlog%' OR
16 VARIABLE_NAME LIKE '%gtid%' OR
17 VARIABLE_NAME LIKE '%log_bin%' OR
18 VARIABLE_NAME LIKE '%master%' OR
19 VARIABLE_NAME LIKE '%relay%' OR
20 VARIABLE_NAME LIKE '%replica%' OR
21 VARIABLE_NAME LIKE '%rpl%' OR
22 VARIABLE_NAME LIKE '%semi_sync%' OR
23 VARIABLE_NAME LIKE '%slave%' OR
24 VARIABLE_NAME LIKE '%source%') AND
25 (VARIABLE_NAME NOT IN ('innodb_api_enable_binlog',
26 'innodb_master_thread_disabled_debug', 'innodb_replication_delay'))
27 ORDER BY VARIABLE_NAME;
28
29 include/assert.inc [Expect 114 variables in the table.]
30
31 # Test SET PERSIST
32 SET PERSIST binlog_cache_size = @@GLOBAL.binlog_cache_size;
33 SET PERSIST binlog_checksum = @@GLOBAL.binlog_checksum;
34 SET PERSIST binlog_direct_non_transactional_updates = @@GLOBAL.binlog_direct_non_transactional_updates;
35 SET PERSIST binlog_encryption = @@GLOBAL.binlog_encryption;
36 SET PERSIST binlog_error_action = @@GLOBAL.binlog_error_action;
37 SET PERSIST binlog_expire_logs_auto_purge = @@GLOBAL.binlog_expire_logs_auto_purge;
38 SET PERSIST binlog_expire_logs_seconds = @@GLOBAL.binlog_expire_logs_seconds;
39 SET PERSIST binlog_format = @@GLOBAL.binlog_format;
40 Warnings:
41 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
42 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
43 SET PERSIST binlog_group_commit_sync_delay = @@GLOBAL.binlog_group_commit_sync_delay;
44 SET PERSIST binlog_group_commit_sync_no_delay_count = @@GLOBAL.binlog_group_commit_sync_no_delay_count;
45 SET PERSIST binlog_gtid_simple_recovery = @@GLOBAL.binlog_gtid_simple_recovery;
46 ERROR HY000: Variable 'binlog_gtid_simple_recovery' is a read only variable
47 SET PERSIST binlog_max_flush_queue_time = @@GLOBAL.binlog_max_flush_queue_time;
48 Warnings:
49 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
50 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
51 SET PERSIST binlog_order_commits = @@GLOBAL.binlog_order_commits;
52 SET PERSIST binlog_rotate_encryption_master_key_at_startup = @@GLOBAL.binlog_rotate_encryption_master_key_at_startup;
53 ERROR HY000: Variable 'binlog_rotate_encryption_master_key_at_startup' is a read only variable
54 SET PERSIST binlog_row_event_max_size = @@GLOBAL.binlog_row_event_max_size;
55 ERROR HY000: Variable 'binlog_row_event_max_size' is a read only variable
56 SET PERSIST binlog_row_image = @@GLOBAL.binlog_row_image;
57 SET PERSIST binlog_row_metadata = @@GLOBAL.binlog_row_metadata;
58 SET PERSIST binlog_row_value_options = @@GLOBAL.binlog_row_value_options;
59 SET PERSIST binlog_rows_query_log_events = @@GLOBAL.binlog_rows_query_log_events;
60 SET PERSIST binlog_stmt_cache_size = @@GLOBAL.binlog_stmt_cache_size;
61 SET PERSIST binlog_transaction_compression = @@GLOBAL.binlog_transaction_compression;
62 SET PERSIST binlog_transaction_compression_level_zstd = @@GLOBAL.binlog_transaction_compression_level_zstd;
63 SET PERSIST binlog_transaction_dependency_history_size = @@GLOBAL.binlog_transaction_dependency_history_size;
64 SET PERSIST binlog_transaction_dependency_tracking = @@GLOBAL.binlog_transaction_dependency_tracking;
65 Warnings:
66 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
67 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
68 SET PERSIST enforce_gtid_consistency = @@GLOBAL.enforce_gtid_consistency;
69 SET PERSIST group_replication_consistency = @@GLOBAL.group_replication_consistency;
70 SET PERSIST gtid_executed = @@GLOBAL.gtid_executed;
71 ERROR HY000: Variable 'gtid_executed' is a read only variable
72 SET PERSIST gtid_executed_compression_period = @@GLOBAL.gtid_executed_compression_period;
73 SET PERSIST gtid_mode = @@GLOBAL.gtid_mode;
74 SET PERSIST gtid_owned = @@GLOBAL.gtid_owned;
75 ERROR HY000: Variable 'gtid_owned' is a read only variable
76 SET PERSIST gtid_purged = @@GLOBAL.gtid_purged;
77 ERROR HY000: Variable 'gtid_purged' is a non persistent variable
78 SET PERSIST init_replica = @@GLOBAL.init_replica;
79 SET PERSIST init_slave = @@GLOBAL.init_slave;
80 Warnings:
81 Warning 1287 '@@init_slave' is deprecated and will be removed in a future release. Please use init_replica instead.
82 Warning 1287 '@@init_slave' is deprecated and will be removed in a future release. Please use init_replica instead.
83 SET PERSIST log_bin = @@GLOBAL.log_bin;
84 ERROR HY000: Variable 'log_bin' is a read only variable
85 SET PERSIST log_bin_basename = @@GLOBAL.log_bin_basename;
86 ERROR HY000: Variable 'log_bin_basename' is a read only variable
87 SET PERSIST log_bin_index = @@GLOBAL.log_bin_index;
88 ERROR HY000: Variable 'log_bin_index' is a read only variable
89 SET PERSIST log_bin_trust_function_creators = @@GLOBAL.log_bin_trust_function_creators;
90 Warnings:
91 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
92 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
93 SET PERSIST log_bin_use_v1_row_events = @@GLOBAL.log_bin_use_v1_row_events;
94 ERROR HY000: Variable 'log_bin_use_v1_row_events' is a non persistent variable
95 SET PERSIST log_replica_updates = @@GLOBAL.log_replica_updates;
96 ERROR HY000: Variable 'log_replica_updates' is a read only variable
97 SET PERSIST log_slave_updates = @@GLOBAL.log_slave_updates;
98 ERROR HY000: Variable 'log_slave_updates' is a read only variable
99 SET PERSIST log_slow_replica_statements = @@GLOBAL.log_slow_replica_statements;
100 SET PERSIST log_slow_slave_statements = @@GLOBAL.log_slow_slave_statements;
101 Warnings:
102 Warning 1287 '@@log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
103 Warning 1287 '@@log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
104 SET PERSIST log_statements_unsafe_for_binlog = @@GLOBAL.log_statements_unsafe_for_binlog;
105 Warnings:
106 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
107 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
108 SET PERSIST master_info_repository = @@GLOBAL.master_info_repository;
109 Warnings:
110 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
111 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
112 SET PERSIST master_verify_checksum = @@GLOBAL.master_verify_checksum;
113 Warnings:
114 Warning 1287 '@@master_verify_checksum' is deprecated and will be removed in a future release. Please use source_verify_checksum instead.
115 Warning 1287 '@@master_verify_checksum' is deprecated and will be removed in a future release. Please use source_verify_checksum instead.
116 SET PERSIST max_binlog_cache_size = @@GLOBAL.max_binlog_cache_size;
117 SET PERSIST max_binlog_size = @@GLOBAL.max_binlog_size;
118 SET PERSIST max_binlog_stmt_cache_size = @@GLOBAL.max_binlog_stmt_cache_size;
119 SET PERSIST max_relay_log_size = @@GLOBAL.max_relay_log_size;
120 SET PERSIST relay_log = @@GLOBAL.relay_log;
121 ERROR HY000: Variable 'relay_log' is a read only variable
122 SET PERSIST relay_log_basename = @@GLOBAL.relay_log_basename;
123 ERROR HY000: Variable 'relay_log_basename' is a read only variable
124 SET PERSIST relay_log_index = @@GLOBAL.relay_log_index;
125 ERROR HY000: Variable 'relay_log_index' is a read only variable
126 SET PERSIST relay_log_info_file = @@GLOBAL.relay_log_info_file;
127 ERROR HY000: Variable 'relay_log_info_file' is a read only variable
128 SET PERSIST relay_log_info_repository = @@GLOBAL.relay_log_info_repository;
129 Warnings:
130 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
131 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
132 SET PERSIST relay_log_purge = @@GLOBAL.relay_log_purge;
133 SET PERSIST relay_log_recovery = @@GLOBAL.relay_log_recovery;
134 ERROR HY000: Variable 'relay_log_recovery' is a read only variable
135 SET PERSIST relay_log_space_limit = @@GLOBAL.relay_log_space_limit;
136 ERROR HY000: Variable 'relay_log_space_limit' is a read only variable
137 SET PERSIST replica_allow_batching = @@GLOBAL.replica_allow_batching;
138 SET PERSIST replica_checkpoint_group = @@GLOBAL.replica_checkpoint_group;
139 SET PERSIST replica_checkpoint_period = @@GLOBAL.replica_checkpoint_period;
140 SET PERSIST replica_compressed_protocol = @@GLOBAL.replica_compressed_protocol;
141 SET PERSIST replica_exec_mode = @@GLOBAL.replica_exec_mode;
142 SET PERSIST replica_load_tmpdir = @@GLOBAL.replica_load_tmpdir;
143 ERROR HY000: Variable 'replica_load_tmpdir' is a read only variable
144 SET PERSIST replica_max_allowed_packet = @@GLOBAL.replica_max_allowed_packet;
145 SET PERSIST replica_net_timeout = @@GLOBAL.replica_net_timeout;
146 SET PERSIST replica_parallel_type = @@GLOBAL.replica_parallel_type;
147 Warnings:
148 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
149 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
150 SET PERSIST replica_parallel_workers = @@GLOBAL.replica_parallel_workers;
151 SET PERSIST replica_pending_jobs_size_max = @@GLOBAL.replica_pending_jobs_size_max;
152 SET PERSIST replica_preserve_commit_order = @@GLOBAL.replica_preserve_commit_order;
153 SET PERSIST replica_skip_errors = @@GLOBAL.replica_skip_errors;
154 ERROR HY000: Variable 'replica_skip_errors' is a read only variable
155 SET PERSIST replica_sql_verify_checksum = @@GLOBAL.replica_sql_verify_checksum;
156 SET PERSIST replica_transaction_retries = @@GLOBAL.replica_transaction_retries;
157 SET PERSIST replica_type_conversions = @@GLOBAL.replica_type_conversions;
158 SET PERSIST replication_optimize_for_static_plugin_config = @@GLOBAL.replication_optimize_for_static_plugin_config;
159 SET PERSIST replication_sender_observe_commit_only = @@GLOBAL.replication_sender_observe_commit_only;
160 SET PERSIST rpl_read_size = @@GLOBAL.rpl_read_size;
161 SET PERSIST rpl_semi_sync_replica_enabled = @@GLOBAL.rpl_semi_sync_replica_enabled;
162 SET PERSIST rpl_semi_sync_replica_trace_level = @@GLOBAL.rpl_semi_sync_replica_trace_level;
163 SET PERSIST rpl_semi_sync_source_enabled = @@GLOBAL.rpl_semi_sync_source_enabled;
164 SET PERSIST rpl_semi_sync_source_timeout = @@GLOBAL.rpl_semi_sync_source_timeout;
165 SET PERSIST rpl_semi_sync_source_trace_level = @@GLOBAL.rpl_semi_sync_source_trace_level;
166 SET PERSIST rpl_semi_sync_source_wait_for_replica_count = @@GLOBAL.rpl_semi_sync_source_wait_for_replica_count;
167 SET PERSIST rpl_semi_sync_source_wait_no_replica = @@GLOBAL.rpl_semi_sync_source_wait_no_replica;
168 SET PERSIST rpl_semi_sync_source_wait_point = @@GLOBAL.rpl_semi_sync_source_wait_point;
169 SET PERSIST rpl_stop_replica_timeout = @@GLOBAL.rpl_stop_replica_timeout;
170 SET PERSIST rpl_stop_slave_timeout = @@GLOBAL.rpl_stop_slave_timeout;
171 Warnings:
172 Warning 1287 '@@rpl_stop_slave_timeout' is deprecated and will be removed in a future release. Please use rpl_stop_replica_timeout instead.
173 Warning 1287 '@@rpl_stop_slave_timeout' is deprecated and will be removed in a future release. Please use rpl_stop_replica_timeout instead.
174 SET PERSIST session_track_gtids = @@GLOBAL.session_track_gtids;
175 SET PERSIST skip_replica_start = @@GLOBAL.skip_replica_start;
176 ERROR HY000: Variable 'skip_replica_start' is a read only variable
177 SET PERSIST skip_slave_start = @@GLOBAL.skip_slave_start;
178 ERROR HY000: Variable 'skip_slave_start' is a read only variable
179 SET PERSIST slave_allow_batching = @@GLOBAL.slave_allow_batching;
180 Warnings:
181 Warning 1287 '@@slave_allow_batching' is deprecated and will be removed in a future release. Please use replica_allow_batching instead.
182 Warning 1287 '@@slave_allow_batching' is deprecated and will be removed in a future release. Please use replica_allow_batching instead.
183 SET PERSIST slave_checkpoint_group = @@GLOBAL.slave_checkpoint_group;
184 Warnings:
185 Warning 1287 '@@slave_checkpoint_group' is deprecated and will be removed in a future release. Please use replica_checkpoint_group instead.
186 Warning 1287 '@@slave_checkpoint_group' is deprecated and will be removed in a future release. Please use replica_checkpoint_group instead.
187 SET PERSIST slave_checkpoint_period = @@GLOBAL.slave_checkpoint_period;
188 Warnings:
189 Warning 1287 '@@slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
190 Warning 1287 '@@slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
191 SET PERSIST slave_compressed_protocol = @@GLOBAL.slave_compressed_protocol;
192 Warnings:
193 Warning 1287 '@@slave_compressed_protocol' is deprecated and will be removed in a future release. Please use replica_compressed_protocol instead.
194 Warning 1287 '@@slave_compressed_protocol' is deprecated and will be removed in a future release. Please use replica_compressed_protocol instead.
195 SET PERSIST slave_exec_mode = @@GLOBAL.slave_exec_mode;
196 Warnings:
197 Warning 1287 '@@slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
198 Warning 1287 '@@slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
199 SET PERSIST slave_load_tmpdir = @@GLOBAL.slave_load_tmpdir;
200 ERROR HY000: Variable 'slave_load_tmpdir' is a read only variable
201 SET PERSIST slave_max_allowed_packet = @@GLOBAL.slave_max_allowed_packet;
202 Warnings:
203 Warning 1287 '@@slave_max_allowed_packet' is deprecated and will be removed in a future release. Please use replica_max_allowed_packet instead.
204 Warning 1287 '@@slave_max_allowed_packet' is deprecated and will be removed in a future release. Please use replica_max_allowed_packet instead.
205 SET PERSIST slave_net_timeout = @@GLOBAL.slave_net_timeout;
206 Warnings:
207 Warning 1287 '@@slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_timeout instead.
208 Warning 1287 '@@slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_timeout instead.
209 SET PERSIST slave_parallel_type = @@GLOBAL.slave_parallel_type;
210 Warnings:
211 Warning 1287 '@@slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
212 Warning 1287 '@@slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
213 SET PERSIST slave_parallel_workers = @@GLOBAL.slave_parallel_workers;
214 Warnings:
215 Warning 1287 '@@slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead.
216 Warning 1287 '@@slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead.
217 SET PERSIST slave_pending_jobs_size_max = @@GLOBAL.slave_pending_jobs_size_max;
218 Warnings:
219 Warning 1287 '@@slave_pending_jobs_size_max' is deprecated and will be removed in a future release. Please use replica_pending_jobs_size_max instead.
220 Warning 1287 '@@slave_pending_jobs_size_max' is deprecated and will be removed in a future release. Please use replica_pending_jobs_size_max instead.
221 SET PERSIST slave_preserve_commit_order = @@GLOBAL.slave_preserve_commit_order;
222 Warnings:
223 Warning 1287 '@@slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
224 Warning 1287 '@@slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
225 SET PERSIST slave_rows_search_algorithms = @@GLOBAL.slave_rows_search_algorithms;
226 Warnings:
227 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
228 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
229 SET PERSIST slave_skip_errors = @@GLOBAL.slave_skip_errors;
230 ERROR HY000: Variable 'slave_skip_errors' is a read only variable
231 SET PERSIST slave_sql_verify_checksum = @@GLOBAL.slave_sql_verify_checksum;
232 Warnings:
233 Warning 1287 '@@slave_sql_verify_checksum' is deprecated and will be removed in a future release. Please use replica_sql_verify_checksum instead.
234 Warning 1287 '@@slave_sql_verify_checksum' is deprecated and will be removed in a future release. Please use replica_sql_verify_checksum instead.
235 SET PERSIST slave_transaction_retries = @@GLOBAL.slave_transaction_retries;
236 Warnings:
237 Warning 1287 '@@slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_transaction_retries instead.
238 Warning 1287 '@@slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_transaction_retries instead.
239 SET PERSIST slave_type_conversions = @@GLOBAL.slave_type_conversions;
240 Warnings:
241 Warning 1287 '@@slave_type_conversions' is deprecated and will be removed in a future release. Please use replica_type_conversions instead.
242 Warning 1287 '@@slave_type_conversions' is deprecated and will be removed in a future release. Please use replica_type_conversions instead.
243 SET PERSIST source_verify_checksum = @@GLOBAL.source_verify_checksum;
244 SET PERSIST sql_replica_skip_counter = @@GLOBAL.sql_replica_skip_counter;
245 SET PERSIST sql_slave_skip_counter = @@GLOBAL.sql_slave_skip_counter;
246 Warnings:
247 Warning 1287 '@@sql_slave_skip_counter' is deprecated and will be removed in a future release. Please use sql_replica_skip_counter instead.
248 Warning 1287 '@@sql_slave_skip_counter' is deprecated and will be removed in a future release. Please use sql_replica_skip_counter instead.
249 SET PERSIST sync_binlog = @@GLOBAL.sync_binlog;
250 SET PERSIST sync_master_info = @@GLOBAL.sync_master_info;
251 Warnings:
252 Warning 1287 '@@sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
253 Warning 1287 '@@sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
254 SET PERSIST sync_relay_log = @@GLOBAL.sync_relay_log;
255 SET PERSIST sync_relay_log_info = @@GLOBAL.sync_relay_log_info;
256 Warnings:
257 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
258 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
259 SET PERSIST sync_source_info = @@GLOBAL.sync_source_info;
260
261 include/assert.inc [Expect 90 persisted variables in persisted_variables table.]
262
263 ############################################################
264 # 2. Restart server, it must preserve the persisted variable
265 # settings. Verify persisted configuration.
266 # restart
267
268 include/assert.inc [Expect 90 persisted variables in persisted_variables table.']
269 include/assert.inc [Expect 90 persisted variables shown as PERSISTED in variables_info table.']
270 include/assert.inc [Expect 90 persisted variables with matching persisted and global values.]
271
272 ############################################################
273 # 3. Test RESET PERSIST IF EXISTS. Verify persisted variable
274 # settings are removed.
275 RESET PERSIST IF EXISTS binlog_cache_size;
276 RESET PERSIST IF EXISTS binlog_checksum;
277 RESET PERSIST IF EXISTS binlog_direct_non_transactional_updates;
278 RESET PERSIST IF EXISTS binlog_encryption;
279 RESET PERSIST IF EXISTS binlog_error_action;
280 RESET PERSIST IF EXISTS binlog_expire_logs_auto_purge;
281 RESET PERSIST IF EXISTS binlog_expire_logs_seconds;
282 RESET PERSIST IF EXISTS binlog_format;
283 RESET PERSIST IF EXISTS binlog_group_commit_sync_delay;
284 RESET PERSIST IF EXISTS binlog_group_commit_sync_no_delay_count;
285 RESET PERSIST IF EXISTS binlog_gtid_simple_recovery;
286 Warnings:
287 Warning 3615 Variable binlog_gtid_simple_recovery does not exist in persisted config file
288 RESET PERSIST IF EXISTS binlog_max_flush_queue_time;
289 RESET PERSIST IF EXISTS binlog_order_commits;
290 RESET PERSIST IF EXISTS binlog_rotate_encryption_master_key_at_startup;
291 Warnings:
292 Warning 3615 Variable binlog_rotate_encryption_master_key_at_startup does not exist in persisted config file
293 RESET PERSIST IF EXISTS binlog_row_event_max_size;
294 Warnings:
295 Warning 3615 Variable binlog_row_event_max_size does not exist in persisted config file
296 RESET PERSIST IF EXISTS binlog_row_image;
297 RESET PERSIST IF EXISTS binlog_row_metadata;
298 RESET PERSIST IF EXISTS binlog_row_value_options;
299 RESET PERSIST IF EXISTS binlog_rows_query_log_events;
300 RESET PERSIST IF EXISTS binlog_stmt_cache_size;
301 RESET PERSIST IF EXISTS binlog_transaction_compression;
302 RESET PERSIST IF EXISTS binlog_transaction_compression_level_zstd;
303 RESET PERSIST IF EXISTS binlog_transaction_dependency_history_size;
304 RESET PERSIST IF EXISTS binlog_transaction_dependency_tracking;
305 RESET PERSIST IF EXISTS enforce_gtid_consistency;
306 RESET PERSIST IF EXISTS group_replication_consistency;
307 RESET PERSIST IF EXISTS gtid_executed;
308 Warnings:
309 Warning 3615 Variable gtid_executed does not exist in persisted config file
310 RESET PERSIST IF EXISTS gtid_executed_compression_period;
311 RESET PERSIST IF EXISTS gtid_mode;
312 RESET PERSIST IF EXISTS gtid_owned;
313 Warnings:
314 Warning 3615 Variable gtid_owned does not exist in persisted config file
315 RESET PERSIST IF EXISTS gtid_purged;
316 Warnings:
317 Warning 3615 Variable gtid_purged does not exist in persisted config file
318 RESET PERSIST IF EXISTS init_replica;
319 RESET PERSIST IF EXISTS init_slave;
320 Warnings:
321 Warning 3615 Variable init_slave does not exist in persisted config file
322 RESET PERSIST IF EXISTS log_bin;
323 Warnings:
324 Warning 3615 Variable log_bin does not exist in persisted config file
325 RESET PERSIST IF EXISTS log_bin_basename;
326 Warnings:
327 Warning 3615 Variable log_bin_basename does not exist in persisted config file
328 RESET PERSIST IF EXISTS log_bin_index;
329 Warnings:
330 Warning 3615 Variable log_bin_index does not exist in persisted config file
331 RESET PERSIST IF EXISTS log_bin_trust_function_creators;
332 RESET PERSIST IF EXISTS log_bin_use_v1_row_events;
333 Warnings:
334 Warning 3615 Variable log_bin_use_v1_row_events does not exist in persisted config file
335 RESET PERSIST IF EXISTS log_replica_updates;
336 Warnings:
337 Warning 3615 Variable log_replica_updates does not exist in persisted config file
338 RESET PERSIST IF EXISTS log_slave_updates;
339 Warnings:
340 Warning 3615 Variable log_slave_updates does not exist in persisted config file
341 RESET PERSIST IF EXISTS log_slow_replica_statements;
342 RESET PERSIST IF EXISTS log_slow_slave_statements;
343 Warnings:
344 Warning 3615 Variable log_slow_slave_statements does not exist in persisted config file
345 RESET PERSIST IF EXISTS log_statements_unsafe_for_binlog;
346 RESET PERSIST IF EXISTS master_info_repository;
347 RESET PERSIST IF EXISTS master_verify_checksum;
348 RESET PERSIST IF EXISTS max_binlog_cache_size;
349 RESET PERSIST IF EXISTS max_binlog_size;
350 RESET PERSIST IF EXISTS max_binlog_stmt_cache_size;
351 RESET PERSIST IF EXISTS max_relay_log_size;
352 RESET PERSIST IF EXISTS relay_log;
353 Warnings:
354 Warning 3615 Variable relay_log does not exist in persisted config file
355 RESET PERSIST IF EXISTS relay_log_basename;
356 Warnings:
357 Warning 3615 Variable relay_log_basename does not exist in persisted config file
358 RESET PERSIST IF EXISTS relay_log_index;
359 Warnings:
360 Warning 3615 Variable relay_log_index does not exist in persisted config file
361 RESET PERSIST IF EXISTS relay_log_info_file;
362 Warnings:
363 Warning 3615 Variable relay_log_info_file does not exist in persisted config file
364 RESET PERSIST IF EXISTS relay_log_info_repository;
365 RESET PERSIST IF EXISTS relay_log_purge;
366 RESET PERSIST IF EXISTS relay_log_recovery;
367 Warnings:
368 Warning 3615 Variable relay_log_recovery does not exist in persisted config file
369 RESET PERSIST IF EXISTS relay_log_space_limit;
370 Warnings:
371 Warning 3615 Variable relay_log_space_limit does not exist in persisted config file
372 RESET PERSIST IF EXISTS replica_allow_batching;
373 RESET PERSIST IF EXISTS replica_checkpoint_group;
374 RESET PERSIST IF EXISTS replica_checkpoint_period;
375 RESET PERSIST IF EXISTS replica_compressed_protocol;
376 RESET PERSIST IF EXISTS replica_exec_mode;
377 RESET PERSIST IF EXISTS replica_load_tmpdir;
378 Warnings:
379 Warning 3615 Variable replica_load_tmpdir does not exist in persisted config file
380 RESET PERSIST IF EXISTS replica_max_allowed_packet;
381 RESET PERSIST IF EXISTS replica_net_timeout;
382 RESET PERSIST IF EXISTS replica_parallel_type;
383 RESET PERSIST IF EXISTS replica_parallel_workers;
384 RESET PERSIST IF EXISTS replica_pending_jobs_size_max;
385 RESET PERSIST IF EXISTS replica_preserve_commit_order;
386 RESET PERSIST IF EXISTS replica_skip_errors;
387 Warnings:
388 Warning 3615 Variable replica_skip_errors does not exist in persisted config file
389 RESET PERSIST IF EXISTS replica_sql_verify_checksum;
390 RESET PERSIST IF EXISTS replica_transaction_retries;
391 RESET PERSIST IF EXISTS replica_type_conversions;
392 RESET PERSIST IF EXISTS replication_optimize_for_static_plugin_config;
393 RESET PERSIST IF EXISTS replication_sender_observe_commit_only;
394 RESET PERSIST IF EXISTS rpl_read_size;
395 RESET PERSIST IF EXISTS rpl_semi_sync_replica_enabled;
396 RESET PERSIST IF EXISTS rpl_semi_sync_replica_trace_level;
397 RESET PERSIST IF EXISTS rpl_semi_sync_source_enabled;
398 RESET PERSIST IF EXISTS rpl_semi_sync_source_timeout;
399 RESET PERSIST IF EXISTS rpl_semi_sync_source_trace_level;
400 RESET PERSIST IF EXISTS rpl_semi_sync_source_wait_for_replica_count;
401 RESET PERSIST IF EXISTS rpl_semi_sync_source_wait_no_replica;
402 RESET PERSIST IF EXISTS rpl_semi_sync_source_wait_point;
403 RESET PERSIST IF EXISTS rpl_stop_replica_timeout;
404 RESET PERSIST IF EXISTS rpl_stop_slave_timeout;
405 Warnings:
406 Warning 3615 Variable rpl_stop_slave_timeout does not exist in persisted config file
407 RESET PERSIST IF EXISTS session_track_gtids;
408 RESET PERSIST IF EXISTS skip_replica_start;
409 Warnings:
410 Warning 3615 Variable skip_replica_start does not exist in persisted config file
411 RESET PERSIST IF EXISTS skip_slave_start;
412 Warnings:
413 Warning 3615 Variable skip_slave_start does not exist in persisted config file
414 RESET PERSIST IF EXISTS slave_allow_batching;
415 Warnings:
416 Warning 3615 Variable slave_allow_batching does not exist in persisted config file
417 RESET PERSIST IF EXISTS slave_checkpoint_group;
418 Warnings:
419 Warning 3615 Variable slave_checkpoint_group does not exist in persisted config file
420 RESET PERSIST IF EXISTS slave_checkpoint_period;
421 Warnings:
422 Warning 3615 Variable slave_checkpoint_period does not exist in persisted config file
423 RESET PERSIST IF EXISTS slave_compressed_protocol;
424 Warnings:
425 Warning 3615 Variable slave_compressed_protocol does not exist in persisted config file
426 RESET PERSIST IF EXISTS slave_exec_mode;
427 Warnings:
428 Warning 3615 Variable slave_exec_mode does not exist in persisted config file
429 RESET PERSIST IF EXISTS slave_load_tmpdir;
430 Warnings:
431 Warning 3615 Variable slave_load_tmpdir does not exist in persisted config file
432 RESET PERSIST IF EXISTS slave_max_allowed_packet;
433 Warnings:
434 Warning 3615 Variable slave_max_allowed_packet does not exist in persisted config file
435 RESET PERSIST IF EXISTS slave_net_timeout;
436 Warnings:
437 Warning 3615 Variable slave_net_timeout does not exist in persisted config file
438 RESET PERSIST IF EXISTS slave_parallel_type;
439 Warnings:
440 Warning 3615 Variable slave_parallel_type does not exist in persisted config file
441 RESET PERSIST IF EXISTS slave_parallel_workers;
442 Warnings:
443 Warning 3615 Variable slave_parallel_workers does not exist in persisted config file
444 RESET PERSIST IF EXISTS slave_pending_jobs_size_max;
445 Warnings:
446 Warning 3615 Variable slave_pending_jobs_size_max does not exist in persisted config file
447 RESET PERSIST IF EXISTS slave_preserve_commit_order;
448 Warnings:
449 Warning 3615 Variable slave_preserve_commit_order does not exist in persisted config file
450 RESET PERSIST IF EXISTS slave_rows_search_algorithms;
451 RESET PERSIST IF EXISTS slave_skip_errors;
452 Warnings:
453 Warning 3615 Variable slave_skip_errors does not exist in persisted config file
454 RESET PERSIST IF EXISTS slave_sql_verify_checksum;
455 Warnings:
456 Warning 3615 Variable slave_sql_verify_checksum does not exist in persisted config file
457 RESET PERSIST IF EXISTS slave_transaction_retries;
458 Warnings:
459 Warning 3615 Variable slave_transaction_retries does not exist in persisted config file
460 RESET PERSIST IF EXISTS slave_type_conversions;
461 Warnings:
462 Warning 3615 Variable slave_type_conversions does not exist in persisted config file
463 RESET PERSIST IF EXISTS source_verify_checksum;
464 Warnings:
465 Warning 3615 Variable source_verify_checksum does not exist in persisted config file
466 RESET PERSIST IF EXISTS sql_replica_skip_counter;
467 RESET PERSIST IF EXISTS sql_slave_skip_counter;
468 Warnings:
469 Warning 3615 Variable sql_slave_skip_counter does not exist in persisted config file
470 RESET PERSIST IF EXISTS sync_binlog;
471 RESET PERSIST IF EXISTS sync_master_info;
472 RESET PERSIST IF EXISTS sync_relay_log;
473 RESET PERSIST IF EXISTS sync_relay_log_info;
474 RESET PERSIST IF EXISTS sync_source_info;
475 Warnings:
476 Warning 3615 Variable sync_source_info does not exist in persisted config file
477
478 include/assert.inc [Expect 0 persisted variables.]
479
480 ############################################################
481 # 4. Clean up.
482 UNINSTALL PLUGIN rpl_semi_sync_source;
483 UNINSTALL PLUGIN rpl_semi_sync_replica;
484 DROP TABLE rplvars;