Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_persist_only_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_ONLY. 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 CREATE TABLE non_persisted (name VARCHAR(100) PRIMARY KEY);
29 INSERT INTO non_persisted VALUES
30 ('gtid_executed'), ('gtid_owned'), ('gtid_purged'), ('log_bin'),
31 ('log_bin_basename'), ('log_bin_index'), ('relay_log'), ('relay_log_basename'),
32 ('relay_log_index'), ('relay_log_info_file'), ('replica_load_tmpdir'),
33 ('slave_load_tmpdir'), ('log_bin_use_v1_row_events');
34 CREATE TABLE aliases (
35 name VARCHAR(100) PRIMARY KEY
36 );
37 INSERT INTO aliases(name) VALUES
38 ('init_slave'), ('rpl_stop_slave_timeout'), ('log_slow_slave_statements'),
39 ('slave_max_allowed_packet'), ('slave_compressed_protocol'),
40 ('slave_exec_mode'), ('slave_type_conversions'),
41 ('slave_sql_verify_checksum'), ('slave_parallel_type'),
42 ('slave_preserve_commit_order'), ('master_verify_checksum'),
43 ('log_slave_updates'), ('slave_allow_batching'), ('slave_load_tmpdir'),
44 ('slave_net_timeout'), ('sql_slave_skip_counter'), ('slave_skip_errors'),
45 ('slave_checkpoint_period'), ('slave_checkpoint_group'),
46 ('sync_master_info'), ('slave_transaction_retries'),
47 ('slave_parallel_workers'), ('slave_pending_jobs_size_max'),
48 ('pseudo_slave_mode'), ('skip_slave_start');
49
50 include/assert.inc [Expect 114 variables in the table.]
51
52 # Test SET PERSIST_ONLY
53 SET PERSIST_ONLY binlog_cache_size = @@GLOBAL.binlog_cache_size;
54 SET PERSIST_ONLY binlog_checksum = @@GLOBAL.binlog_checksum;
55 SET PERSIST_ONLY binlog_direct_non_transactional_updates = @@GLOBAL.binlog_direct_non_transactional_updates;
56 SET PERSIST_ONLY binlog_encryption = @@GLOBAL.binlog_encryption;
57 SET PERSIST_ONLY binlog_error_action = @@GLOBAL.binlog_error_action;
58 SET PERSIST_ONLY binlog_expire_logs_auto_purge = @@GLOBAL.binlog_expire_logs_auto_purge;
59 SET PERSIST_ONLY binlog_expire_logs_seconds = @@GLOBAL.binlog_expire_logs_seconds;
60 SET PERSIST_ONLY binlog_format = @@GLOBAL.binlog_format;
61 Warnings:
62 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
63 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
64 SET PERSIST_ONLY binlog_group_commit_sync_delay = @@GLOBAL.binlog_group_commit_sync_delay;
65 SET PERSIST_ONLY binlog_group_commit_sync_no_delay_count = @@GLOBAL.binlog_group_commit_sync_no_delay_count;
66 SET PERSIST_ONLY binlog_gtid_simple_recovery = @@GLOBAL.binlog_gtid_simple_recovery;
67 SET PERSIST_ONLY binlog_max_flush_queue_time = @@GLOBAL.binlog_max_flush_queue_time;
68 Warnings:
69 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
70 Warning 1287 '@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
71 SET PERSIST_ONLY binlog_order_commits = @@GLOBAL.binlog_order_commits;
72 SET PERSIST_ONLY binlog_rotate_encryption_master_key_at_startup = @@GLOBAL.binlog_rotate_encryption_master_key_at_startup;
73 SET PERSIST_ONLY binlog_row_event_max_size = @@GLOBAL.binlog_row_event_max_size;
74 SET PERSIST_ONLY binlog_row_image = @@GLOBAL.binlog_row_image;
75 SET PERSIST_ONLY binlog_row_metadata = @@GLOBAL.binlog_row_metadata;
76 SET PERSIST_ONLY binlog_row_value_options = @@GLOBAL.binlog_row_value_options;
77 SET PERSIST_ONLY binlog_rows_query_log_events = @@GLOBAL.binlog_rows_query_log_events;
78 SET PERSIST_ONLY binlog_stmt_cache_size = @@GLOBAL.binlog_stmt_cache_size;
79 SET PERSIST_ONLY binlog_transaction_compression = @@GLOBAL.binlog_transaction_compression;
80 SET PERSIST_ONLY binlog_transaction_compression_level_zstd = @@GLOBAL.binlog_transaction_compression_level_zstd;
81 SET PERSIST_ONLY binlog_transaction_dependency_history_size = @@GLOBAL.binlog_transaction_dependency_history_size;
82 SET PERSIST_ONLY binlog_transaction_dependency_tracking = @@GLOBAL.binlog_transaction_dependency_tracking;
83 Warnings:
84 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
85 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
86 SET PERSIST_ONLY enforce_gtid_consistency = @@GLOBAL.enforce_gtid_consistency;
87 SET PERSIST_ONLY group_replication_consistency = @@GLOBAL.group_replication_consistency;
88 SET PERSIST_ONLY gtid_executed = @@GLOBAL.gtid_executed;
89 ERROR HY000: Variable 'gtid_executed' is a non persistent read only variable
90 SET PERSIST_ONLY gtid_executed_compression_period = @@GLOBAL.gtid_executed_compression_period;
91 SET PERSIST_ONLY gtid_mode = @@GLOBAL.gtid_mode;
92 SET PERSIST_ONLY gtid_owned = @@GLOBAL.gtid_owned;
93 ERROR HY000: Variable 'gtid_owned' is a non persistent read only variable
94 SET PERSIST_ONLY gtid_purged = @@GLOBAL.gtid_purged;
95 ERROR HY000: Variable 'gtid_purged' is a non persistent variable
96 SET PERSIST_ONLY init_replica = @@GLOBAL.init_replica;
97 SET PERSIST_ONLY init_slave = @@GLOBAL.init_slave;
98 Warnings:
99 Warning 1287 '@@init_slave' is deprecated and will be removed in a future release. Please use init_replica instead.
100 Warning 1287 '@@init_slave' is deprecated and will be removed in a future release. Please use init_replica instead.
101 SET PERSIST_ONLY log_bin = @@GLOBAL.log_bin;
102 ERROR HY000: Variable 'log_bin' is a non persistent read only variable
103 SET PERSIST_ONLY log_bin_basename = @@GLOBAL.log_bin_basename;
104 ERROR HY000: Variable 'log_bin_basename' is a non persistent read only variable
105 SET PERSIST_ONLY log_bin_index = @@GLOBAL.log_bin_index;
106 ERROR HY000: Variable 'log_bin_index' is a non persistent read only variable
107 SET PERSIST_ONLY log_bin_trust_function_creators = @@GLOBAL.log_bin_trust_function_creators;
108 Warnings:
109 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
110 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
111 Warnings:
112 Warning 1287 '@@log_bin_trust_function_creators' is deprecated and will be removed in a future release.
113 SET PERSIST_ONLY log_bin_use_v1_row_events = @@GLOBAL.log_bin_use_v1_row_events;
114 ERROR HY000: Variable 'log_bin_use_v1_row_events' is a non persistent variable
115 SET PERSIST_ONLY log_replica_updates = @@GLOBAL.log_replica_updates;
116 SET PERSIST_ONLY log_slave_updates = @@GLOBAL.log_slave_updates;
117 Warnings:
118 Warning 1287 '@@log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
119 Warning 1287 '@@log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
120 SET PERSIST_ONLY log_slow_replica_statements = @@GLOBAL.log_slow_replica_statements;
121 SET PERSIST_ONLY log_slow_slave_statements = @@GLOBAL.log_slow_slave_statements;
122 Warnings:
123 Warning 1287 '@@log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
124 Warning 1287 '@@log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
125 SET PERSIST_ONLY log_statements_unsafe_for_binlog = @@GLOBAL.log_statements_unsafe_for_binlog;
126 Warnings:
127 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
128 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
129 Warnings:
130 Warning 1287 '@@log_statements_unsafe_for_binlog' is deprecated and will be removed in a future release.
131 SET PERSIST_ONLY master_info_repository = @@GLOBAL.master_info_repository;
132 Warnings:
133 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
134 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
135 SET PERSIST_ONLY master_verify_checksum = @@GLOBAL.master_verify_checksum;
136 Warnings:
137 Warning 1287 '@@master_verify_checksum' is deprecated and will be removed in a future release. Please use source_verify_checksum instead.
138 Warning 1287 '@@master_verify_checksum' is deprecated and will be removed in a future release. Please use source_verify_checksum instead.
139 SET PERSIST_ONLY max_binlog_cache_size = @@GLOBAL.max_binlog_cache_size;
140 SET PERSIST_ONLY max_binlog_size = @@GLOBAL.max_binlog_size;
141 SET PERSIST_ONLY max_binlog_stmt_cache_size = @@GLOBAL.max_binlog_stmt_cache_size;
142 SET PERSIST_ONLY max_relay_log_size = @@GLOBAL.max_relay_log_size;
143 SET PERSIST_ONLY relay_log = @@GLOBAL.relay_log;
144 ERROR HY000: Variable 'relay_log' is a non persistent read only variable
145 SET PERSIST_ONLY relay_log_basename = @@GLOBAL.relay_log_basename;
146 ERROR HY000: Variable 'relay_log_basename' is a non persistent read only variable
147 SET PERSIST_ONLY relay_log_index = @@GLOBAL.relay_log_index;
148 ERROR HY000: Variable 'relay_log_index' is a non persistent read only variable
149 SET PERSIST_ONLY relay_log_info_file = @@GLOBAL.relay_log_info_file;
150 ERROR HY000: Variable 'relay_log_info_file' is a non persistent read only variable
151 SET PERSIST_ONLY relay_log_info_repository = @@GLOBAL.relay_log_info_repository;
152 Warnings:
153 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
154 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
155 SET PERSIST_ONLY relay_log_purge = @@GLOBAL.relay_log_purge;
156 SET PERSIST_ONLY relay_log_recovery = @@GLOBAL.relay_log_recovery;
157 SET PERSIST_ONLY relay_log_space_limit = @@GLOBAL.relay_log_space_limit;
158 SET PERSIST_ONLY replica_allow_batching = @@GLOBAL.replica_allow_batching;
159 SET PERSIST_ONLY replica_checkpoint_group = @@GLOBAL.replica_checkpoint_group;
160 SET PERSIST_ONLY replica_checkpoint_period = @@GLOBAL.replica_checkpoint_period;
161 SET PERSIST_ONLY replica_compressed_protocol = @@GLOBAL.replica_compressed_protocol;
162 SET PERSIST_ONLY replica_exec_mode = @@GLOBAL.replica_exec_mode;
163 SET PERSIST_ONLY replica_load_tmpdir = @@GLOBAL.replica_load_tmpdir;
164 ERROR HY000: Variable 'replica_load_tmpdir' is a non persistent read only variable
165 SET PERSIST_ONLY replica_max_allowed_packet = @@GLOBAL.replica_max_allowed_packet;
166 SET PERSIST_ONLY replica_net_timeout = @@GLOBAL.replica_net_timeout;
167 SET PERSIST_ONLY replica_parallel_type = @@GLOBAL.replica_parallel_type;
168 Warnings:
169 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
170 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
171 SET PERSIST_ONLY replica_parallel_workers = @@GLOBAL.replica_parallel_workers;
172 SET PERSIST_ONLY replica_pending_jobs_size_max = @@GLOBAL.replica_pending_jobs_size_max;
173 SET PERSIST_ONLY replica_preserve_commit_order = @@GLOBAL.replica_preserve_commit_order;
174 SET PERSIST_ONLY replica_skip_errors = @@GLOBAL.replica_skip_errors;
175 SET PERSIST_ONLY replica_sql_verify_checksum = @@GLOBAL.replica_sql_verify_checksum;
176 SET PERSIST_ONLY replica_transaction_retries = @@GLOBAL.replica_transaction_retries;
177 SET PERSIST_ONLY replica_type_conversions = @@GLOBAL.replica_type_conversions;
178 SET PERSIST_ONLY replication_optimize_for_static_plugin_config = @@GLOBAL.replication_optimize_for_static_plugin_config;
179 SET PERSIST_ONLY replication_sender_observe_commit_only = @@GLOBAL.replication_sender_observe_commit_only;
180 SET PERSIST_ONLY rpl_read_size = @@GLOBAL.rpl_read_size;
181 SET PERSIST_ONLY rpl_semi_sync_replica_enabled = @@GLOBAL.rpl_semi_sync_replica_enabled;
182 SET PERSIST_ONLY rpl_semi_sync_replica_trace_level = @@GLOBAL.rpl_semi_sync_replica_trace_level;
183 SET PERSIST_ONLY rpl_semi_sync_source_enabled = @@GLOBAL.rpl_semi_sync_source_enabled;
184 SET PERSIST_ONLY rpl_semi_sync_source_timeout = @@GLOBAL.rpl_semi_sync_source_timeout;
185 SET PERSIST_ONLY rpl_semi_sync_source_trace_level = @@GLOBAL.rpl_semi_sync_source_trace_level;
186 SET PERSIST_ONLY rpl_semi_sync_source_wait_for_replica_count = @@GLOBAL.rpl_semi_sync_source_wait_for_replica_count;
187 SET PERSIST_ONLY rpl_semi_sync_source_wait_no_replica = @@GLOBAL.rpl_semi_sync_source_wait_no_replica;
188 SET PERSIST_ONLY rpl_semi_sync_source_wait_point = @@GLOBAL.rpl_semi_sync_source_wait_point;
189 SET PERSIST_ONLY rpl_stop_replica_timeout = @@GLOBAL.rpl_stop_replica_timeout;
190 SET PERSIST_ONLY rpl_stop_slave_timeout = @@GLOBAL.rpl_stop_slave_timeout;
191 Warnings:
192 Warning 1287 '@@rpl_stop_slave_timeout' is deprecated and will be removed in a future release. Please use rpl_stop_replica_timeout instead.
193 Warning 1287 '@@rpl_stop_slave_timeout' is deprecated and will be removed in a future release. Please use rpl_stop_replica_timeout instead.
194 SET PERSIST_ONLY session_track_gtids = @@GLOBAL.session_track_gtids;
195 SET PERSIST_ONLY skip_replica_start = @@GLOBAL.skip_replica_start;
196 SET PERSIST_ONLY skip_slave_start = @@GLOBAL.skip_slave_start;
197 Warnings:
198 Warning 1287 '@@skip_slave_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead.
199 Warning 1287 '@@skip_slave_start' is deprecated and will be removed in a future release. Please use skip_replica_start instead.
200 SET PERSIST_ONLY slave_allow_batching = @@GLOBAL.slave_allow_batching;
201 Warnings:
202 Warning 1287 '@@slave_allow_batching' is deprecated and will be removed in a future release. Please use replica_allow_batching instead.
203 Warning 1287 '@@slave_allow_batching' is deprecated and will be removed in a future release. Please use replica_allow_batching instead.
204 SET PERSIST_ONLY slave_checkpoint_group = @@GLOBAL.slave_checkpoint_group;
205 Warnings:
206 Warning 1287 '@@slave_checkpoint_group' is deprecated and will be removed in a future release. Please use replica_checkpoint_group instead.
207 Warning 1287 '@@slave_checkpoint_group' is deprecated and will be removed in a future release. Please use replica_checkpoint_group instead.
208 SET PERSIST_ONLY slave_checkpoint_period = @@GLOBAL.slave_checkpoint_period;
209 Warnings:
210 Warning 1287 '@@slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
211 Warning 1287 '@@slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
212 SET PERSIST_ONLY slave_compressed_protocol = @@GLOBAL.slave_compressed_protocol;
213 Warnings:
214 Warning 1287 '@@slave_compressed_protocol' is deprecated and will be removed in a future release. Please use replica_compressed_protocol instead.
215 Warning 1287 '@@slave_compressed_protocol' is deprecated and will be removed in a future release. Please use replica_compressed_protocol instead.
216 SET PERSIST_ONLY slave_exec_mode = @@GLOBAL.slave_exec_mode;
217 Warnings:
218 Warning 1287 '@@slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
219 Warning 1287 '@@slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
220 SET PERSIST_ONLY slave_load_tmpdir = @@GLOBAL.slave_load_tmpdir;
221 ERROR HY000: Variable 'slave_load_tmpdir' is a non persistent read only variable
222 SET PERSIST_ONLY slave_max_allowed_packet = @@GLOBAL.slave_max_allowed_packet;
223 Warnings:
224 Warning 1287 '@@slave_max_allowed_packet' is deprecated and will be removed in a future release. Please use replica_max_allowed_packet instead.
225 Warning 1287 '@@slave_max_allowed_packet' is deprecated and will be removed in a future release. Please use replica_max_allowed_packet instead.
226 SET PERSIST_ONLY slave_net_timeout = @@GLOBAL.slave_net_timeout;
227 Warnings:
228 Warning 1287 '@@slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_timeout instead.
229 Warning 1287 '@@slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_timeout instead.
230 SET PERSIST_ONLY slave_parallel_type = @@GLOBAL.slave_parallel_type;
231 Warnings:
232 Warning 1287 '@@slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
233 Warning 1287 '@@slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
234 SET PERSIST_ONLY slave_parallel_workers = @@GLOBAL.slave_parallel_workers;
235 Warnings:
236 Warning 1287 '@@slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead.
237 Warning 1287 '@@slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead.
238 SET PERSIST_ONLY slave_pending_jobs_size_max = @@GLOBAL.slave_pending_jobs_size_max;
239 Warnings:
240 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.
241 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.
242 SET PERSIST_ONLY slave_preserve_commit_order = @@GLOBAL.slave_preserve_commit_order;
243 Warnings:
244 Warning 1287 '@@slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
245 Warning 1287 '@@slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
246 SET PERSIST_ONLY slave_rows_search_algorithms = @@GLOBAL.slave_rows_search_algorithms;
247 Warnings:
248 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
249 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
250 SET PERSIST_ONLY slave_skip_errors = @@GLOBAL.slave_skip_errors;
251 Warnings:
252 Warning 1287 '@@slave_skip_errors' is deprecated and will be removed in a future release. Please use replica_skip_errors instead.
253 Warning 1287 '@@slave_skip_errors' is deprecated and will be removed in a future release. Please use replica_skip_errors instead.
254 SET PERSIST_ONLY slave_sql_verify_checksum = @@GLOBAL.slave_sql_verify_checksum;
255 Warnings:
256 Warning 1287 '@@slave_sql_verify_checksum' is deprecated and will be removed in a future release. Please use replica_sql_verify_checksum instead.
257 Warning 1287 '@@slave_sql_verify_checksum' is deprecated and will be removed in a future release. Please use replica_sql_verify_checksum instead.
258 SET PERSIST_ONLY slave_transaction_retries = @@GLOBAL.slave_transaction_retries;
259 Warnings:
260 Warning 1287 '@@slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_transaction_retries instead.
261 Warning 1287 '@@slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_transaction_retries instead.
262 SET PERSIST_ONLY slave_type_conversions = @@GLOBAL.slave_type_conversions;
263 Warnings:
264 Warning 1287 '@@slave_type_conversions' is deprecated and will be removed in a future release. Please use replica_type_conversions instead.
265 Warning 1287 '@@slave_type_conversions' is deprecated and will be removed in a future release. Please use replica_type_conversions instead.
266 SET PERSIST_ONLY source_verify_checksum = @@GLOBAL.source_verify_checksum;
267 SET PERSIST_ONLY sql_replica_skip_counter = @@GLOBAL.sql_replica_skip_counter;
268 SET PERSIST_ONLY sql_slave_skip_counter = @@GLOBAL.sql_slave_skip_counter;
269 Warnings:
270 Warning 1287 '@@sql_slave_skip_counter' is deprecated and will be removed in a future release. Please use sql_replica_skip_counter instead.
271 Warning 1287 '@@sql_slave_skip_counter' is deprecated and will be removed in a future release. Please use sql_replica_skip_counter instead.
272 SET PERSIST_ONLY sync_binlog = @@GLOBAL.sync_binlog;
273 SET PERSIST_ONLY sync_master_info = @@GLOBAL.sync_master_info;
274 Warnings:
275 Warning 1287 '@@sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
276 Warning 1287 '@@sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
277 SET PERSIST_ONLY sync_relay_log = @@GLOBAL.sync_relay_log;
278 SET PERSIST_ONLY sync_relay_log_info = @@GLOBAL.sync_relay_log_info;
279 Warnings:
280 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
281 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
282 SET PERSIST_ONLY sync_source_info = @@GLOBAL.sync_source_info;
283
284 include/assert.inc [Expect 101 persisted variables in persisted_variables table.]
285
286 ############################################################
287 # 2. Restart server, it must preserve the persisted variable
288 # settings. Verify persisted configuration.
289 # restart
290
291 include/assert.inc [Expect 101 persisted variables in persisted_variables table.]
292 include/assert.inc [Expect 101 persisted variables shown as PERSISTED in variables_info table.]
293 include/assert.inc [Expect 101 persisted variables with matching persisted and global values.]
294
295 ############################################################
296 # 3. Test RESET PERSIST. Verify persisted variable settings
297 # are removed.
298 RESET PERSIST binlog_cache_size;
299 RESET PERSIST binlog_checksum;
300 RESET PERSIST binlog_direct_non_transactional_updates;
301 RESET PERSIST binlog_encryption;
302 RESET PERSIST binlog_error_action;
303 RESET PERSIST binlog_expire_logs_auto_purge;
304 RESET PERSIST binlog_expire_logs_seconds;
305 RESET PERSIST binlog_format;
306 RESET PERSIST binlog_group_commit_sync_delay;
307 RESET PERSIST binlog_group_commit_sync_no_delay_count;
308 RESET PERSIST binlog_gtid_simple_recovery;
309 RESET PERSIST binlog_max_flush_queue_time;
310 RESET PERSIST binlog_order_commits;
311 RESET PERSIST binlog_rotate_encryption_master_key_at_startup;
312 RESET PERSIST binlog_row_event_max_size;
313 RESET PERSIST binlog_row_image;
314 RESET PERSIST binlog_row_metadata;
315 RESET PERSIST binlog_row_value_options;
316 RESET PERSIST binlog_rows_query_log_events;
317 RESET PERSIST binlog_stmt_cache_size;
318 RESET PERSIST binlog_transaction_compression;
319 RESET PERSIST binlog_transaction_compression_level_zstd;
320 RESET PERSIST binlog_transaction_dependency_history_size;
321 RESET PERSIST binlog_transaction_dependency_tracking;
322 RESET PERSIST enforce_gtid_consistency;
323 RESET PERSIST group_replication_consistency;
324 RESET PERSIST gtid_executed;
325 ERROR HY000: Variable gtid_executed does not exist in persisted config file
326 RESET PERSIST gtid_executed_compression_period;
327 RESET PERSIST gtid_mode;
328 RESET PERSIST gtid_owned;
329 ERROR HY000: Variable gtid_owned does not exist in persisted config file
330 RESET PERSIST gtid_purged;
331 ERROR HY000: Variable gtid_purged does not exist in persisted config file
332 RESET PERSIST init_replica;
333 RESET PERSIST log_bin;
334 ERROR HY000: Variable log_bin does not exist in persisted config file
335 RESET PERSIST log_bin_basename;
336 ERROR HY000: Variable log_bin_basename does not exist in persisted config file
337 RESET PERSIST log_bin_index;
338 ERROR HY000: Variable log_bin_index does not exist in persisted config file
339 RESET PERSIST log_bin_trust_function_creators;
340 RESET PERSIST log_bin_use_v1_row_events;
341 ERROR HY000: Variable log_bin_use_v1_row_events does not exist in persisted config file
342 RESET PERSIST log_replica_updates;
343 RESET PERSIST log_slow_replica_statements;
344 RESET PERSIST log_statements_unsafe_for_binlog;
345 RESET PERSIST master_info_repository;
346 RESET PERSIST max_binlog_cache_size;
347 RESET PERSIST max_binlog_size;
348 RESET PERSIST max_binlog_stmt_cache_size;
349 RESET PERSIST max_relay_log_size;
350 RESET PERSIST relay_log;
351 ERROR HY000: Variable relay_log does not exist in persisted config file
352 RESET PERSIST relay_log_basename;
353 ERROR HY000: Variable relay_log_basename does not exist in persisted config file
354 RESET PERSIST relay_log_index;
355 ERROR HY000: Variable relay_log_index does not exist in persisted config file
356 RESET PERSIST relay_log_info_file;
357 ERROR HY000: Variable relay_log_info_file does not exist in persisted config file
358 RESET PERSIST relay_log_info_repository;
359 RESET PERSIST relay_log_purge;
360 RESET PERSIST relay_log_recovery;
361 RESET PERSIST relay_log_space_limit;
362 RESET PERSIST replica_allow_batching;
363 RESET PERSIST replica_checkpoint_group;
364 RESET PERSIST replica_checkpoint_period;
365 RESET PERSIST replica_compressed_protocol;
366 RESET PERSIST replica_exec_mode;
367 RESET PERSIST replica_load_tmpdir;
368 ERROR HY000: Variable replica_load_tmpdir does not exist in persisted config file
369 RESET PERSIST replica_max_allowed_packet;
370 RESET PERSIST replica_net_timeout;
371 RESET PERSIST replica_parallel_type;
372 RESET PERSIST replica_parallel_workers;
373 RESET PERSIST replica_pending_jobs_size_max;
374 RESET PERSIST replica_preserve_commit_order;
375 RESET PERSIST replica_skip_errors;
376 RESET PERSIST replica_sql_verify_checksum;
377 RESET PERSIST replica_transaction_retries;
378 RESET PERSIST replica_type_conversions;
379 RESET PERSIST replication_optimize_for_static_plugin_config;
380 RESET PERSIST replication_sender_observe_commit_only;
381 RESET PERSIST rpl_read_size;
382 RESET PERSIST rpl_semi_sync_replica_enabled;
383 RESET PERSIST rpl_semi_sync_replica_trace_level;
384 RESET PERSIST rpl_semi_sync_source_enabled;
385 RESET PERSIST rpl_semi_sync_source_timeout;
386 RESET PERSIST rpl_semi_sync_source_trace_level;
387 RESET PERSIST rpl_semi_sync_source_wait_for_replica_count;
388 RESET PERSIST rpl_semi_sync_source_wait_no_replica;
389 RESET PERSIST rpl_semi_sync_source_wait_point;
390 RESET PERSIST rpl_stop_replica_timeout;
391 RESET PERSIST session_track_gtids;
392 RESET PERSIST skip_replica_start;
393 RESET PERSIST slave_rows_search_algorithms;
394 RESET PERSIST source_verify_checksum;
395 RESET PERSIST sql_replica_skip_counter;
396 RESET PERSIST sync_binlog;
397 RESET PERSIST sync_relay_log;
398 RESET PERSIST sync_relay_log_info;
399 RESET PERSIST sync_source_info;
400
401 include/assert.inc [Expect 0 persisted variables.]
402
403 ############################################################
404 # 4. Clean up.
405 SET @varvalue=NULL;
406 UNINSTALL PLUGIN rpl_semi_sync_source;
407 UNINSTALL PLUGIN rpl_semi_sync_replica;
408 DROP TABLE rplvars;
409 DROP TABLE aliases;
410 DROP TABLE non_persisted;