binlog_persist_variables.result

############################################################
# 0. Check that there are no persisted variable settings.
include/assert.inc [Expect 0 persisted variables.]

############################################################
# 1. Initialization. Test SET PERSIST. Verify persisted
#    variables.
CALL mtr.add_suppression("Unsafe statement written to the binary log");
# Install semi-sync related plugins
INSTALL PLUGIN rpl_semi_sync_source SONAME 'SEMISYNC_SOURCE_PLUGIN';
INSTALL PLUGIN rpl_semi_sync_replica SONAME 'SEMISYNC_REPLICA_PLUGIN';
CREATE TABLE rplvars (id INT PRIMARY KEY AUTO_INCREMENT, varname VARCHAR(64), varvalue VARCHAR(256));
INSERT INTO rplvars (varname, varvalue)
SELECT * FROM performance_schema.global_variables
WHERE (VARIABLE_NAME LIKE '%binlog%' OR
VARIABLE_NAME LIKE '%gtid%' OR
VARIABLE_NAME LIKE '%log_bin%' OR
VARIABLE_NAME LIKE '%master%' OR
VARIABLE_NAME LIKE '%relay%' OR
VARIABLE_NAME LIKE '%replica%' OR
VARIABLE_NAME LIKE '%rpl%' OR
VARIABLE_NAME LIKE '%semi_sync%' OR
VARIABLE_NAME LIKE '%slave%' OR
VARIABLE_NAME LIKE '%source%') AND
(VARIABLE_NAME NOT IN ('innodb_api_enable_binlog',
'binlog_file_basedir', 'binlog_index_basedir',
'skip_flush_master_info', 'skip_flush_relay_worker_info',
'read_only_slave', 'rpl_semi_sync_source_crash_if_active_trxs',
'reset_seconds_behind_master',
'innodb_master_thread_disabled_debug', 'innodb_replication_delay'))
AND (VARIABLE_NAME NOT LIKE 'rocksdb%')
ORDER BY VARIABLE_NAME;

include/assert.inc ['Expect $expected variables in the table.']

# Test SET PERSIST
SET PERSIST binlog_cache_size = @@GLOBAL.binlog_cache_size;
SET PERSIST binlog_checksum = @@GLOBAL.binlog_checksum;
SET PERSIST binlog_direct_non_transactional_updates = @@GLOBAL.binlog_direct_non_transactional_updates;
SET PERSIST binlog_encryption = @@GLOBAL.binlog_encryption;
SET PERSIST binlog_error_action = @@GLOBAL.binlog_error_action;
SET PERSIST binlog_expire_logs_auto_purge = @@GLOBAL.binlog_expire_logs_auto_purge;
SET PERSIST binlog_expire_logs_seconds = @@GLOBAL.binlog_expire_logs_seconds;
SET PERSIST binlog_format = @@GLOBAL.binlog_format;
SET PERSIST binlog_group_commit_sync_delay = @@GLOBAL.binlog_group_commit_sync_delay;
SET PERSIST binlog_group_commit_sync_no_delay_count = @@GLOBAL.binlog_group_commit_sync_no_delay_count;
SET PERSIST binlog_gtid_simple_recovery = @@GLOBAL.binlog_gtid_simple_recovery;
ERROR HY000: Variable 'binlog_gtid_simple_recovery' is a read only variable
SET PERSIST binlog_max_flush_queue_time = @@GLOBAL.binlog_max_flush_queue_time;
Warnings:
Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
Warning	1287	'@@binlog_max_flush_queue_time' is deprecated and will be removed in a future release.
SET PERSIST binlog_order_commits = @@GLOBAL.binlog_order_commits;
SET PERSIST binlog_rotate_encryption_master_key_at_startup = @@GLOBAL.binlog_rotate_encryption_master_key_at_startup;
ERROR HY000: Variable 'binlog_rotate_encryption_master_key_at_startup' is a read only variable
SET PERSIST binlog_row_event_max_size = @@GLOBAL.binlog_row_event_max_size;
ERROR HY000: Variable 'binlog_row_event_max_size' is a read only variable
SET PERSIST binlog_row_image = @@GLOBAL.binlog_row_image;
SET PERSIST binlog_row_metadata = @@GLOBAL.binlog_row_metadata;
SET PERSIST binlog_row_value_options = @@GLOBAL.binlog_row_value_options;
SET PERSIST binlog_rows_event_max_rows = @@GLOBAL.binlog_rows_event_max_rows;
SET PERSIST binlog_rows_query_log_events = @@GLOBAL.binlog_rows_query_log_events;
SET PERSIST binlog_stmt_cache_size = @@GLOBAL.binlog_stmt_cache_size;
SET PERSIST binlog_transaction_compression = @@GLOBAL.binlog_transaction_compression;
SET PERSIST binlog_transaction_compression_level_zstd = @@GLOBAL.binlog_transaction_compression_level_zstd;
SET PERSIST binlog_transaction_dependency_history_size = @@GLOBAL.binlog_transaction_dependency_history_size;
SET PERSIST binlog_transaction_dependency_tracking = @@GLOBAL.binlog_transaction_dependency_tracking;
SET PERSIST binlog_trx_meta_data = @@GLOBAL.binlog_trx_meta_data;
SET PERSIST enable_binlog_hlc = @@GLOBAL.enable_binlog_hlc;
SET PERSIST enforce_gtid_consistency = @@GLOBAL.enforce_gtid_consistency;
SET PERSIST group_replication_consistency = @@GLOBAL.group_replication_consistency;
SET PERSIST gtid_committed = @@GLOBAL.gtid_committed;
ERROR HY000: Variable 'gtid_committed' is a read only variable
SET PERSIST gtid_executed = @@GLOBAL.gtid_executed;
ERROR HY000: Variable 'gtid_executed' is a read only variable
SET PERSIST gtid_executed_compression_period = @@GLOBAL.gtid_executed_compression_period;
SET PERSIST gtid_mode = @@GLOBAL.gtid_mode;
SET PERSIST gtid_owned = @@GLOBAL.gtid_owned;
ERROR HY000: Variable 'gtid_owned' is a read only variable
SET PERSIST gtid_purged = @@GLOBAL.gtid_purged;
ERROR HY000: Variable 'gtid_purged' is a non persistent variable
SET PERSIST init_replica = @@GLOBAL.init_replica;
SET PERSIST init_slave = @@GLOBAL.init_slave;
Warnings:
Warning	1287	'@@init_slave' is deprecated and will be removed in a future release. Please use init_replica instead.
Warning	1287	'@@init_slave' is deprecated and will be removed in a future release. Please use init_replica instead.
SET PERSIST log_bin = @@GLOBAL.log_bin;
ERROR HY000: Variable 'log_bin' is a read only variable
SET PERSIST log_bin_basename = @@GLOBAL.log_bin_basename;
ERROR HY000: Variable 'log_bin_basename' is a read only variable
SET PERSIST log_bin_index = @@GLOBAL.log_bin_index;
ERROR HY000: Variable 'log_bin_index' is a read only variable
SET PERSIST log_bin_trust_function_creators = @@GLOBAL.log_bin_trust_function_creators;
SET PERSIST log_bin_use_v1_row_events = @@GLOBAL.log_bin_use_v1_row_events;
ERROR HY000: Variable 'log_bin_use_v1_row_events' is a non persistent variable
SET PERSIST log_replica_updates = @@GLOBAL.log_replica_updates;
ERROR HY000: Variable 'log_replica_updates' is a read only variable
SET PERSIST log_slave_updates = @@GLOBAL.log_slave_updates;
ERROR HY000: Variable 'log_slave_updates' is a read only variable
SET PERSIST log_slow_replica_statements = @@GLOBAL.log_slow_replica_statements;
SET PERSIST log_slow_slave_statements = @@GLOBAL.log_slow_slave_statements;
Warnings:
Warning	1287	'@@log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
Warning	1287	'@@log_slow_slave_statements' is deprecated and will be removed in a future release. Please use log_slow_replica_statements instead.
SET PERSIST log_statements_unsafe_for_binlog = @@GLOBAL.log_statements_unsafe_for_binlog;
SET PERSIST master_info_repository = @@GLOBAL.master_info_repository;
Warnings:
Warning	1287	'@@master_info_repository' is deprecated and will be removed in a future release.
Warning	1287	'@@master_info_repository' is deprecated and will be removed in a future release.
SET PERSIST master_verify_checksum = @@GLOBAL.master_verify_checksum;
Warnings:
Warning	1287	'@@master_verify_checksum' is deprecated and will be removed in a future release. Please use source_verify_checksum instead.
Warning	1287	'@@master_verify_checksum' is deprecated and will be removed in a future release. Please use source_verify_checksum instead.
SET PERSIST max_binlog_cache_size = @@GLOBAL.max_binlog_cache_size;
SET PERSIST max_binlog_size = @@GLOBAL.max_binlog_size;
SET PERSIST max_binlog_stmt_cache_size = @@GLOBAL.max_binlog_stmt_cache_size;
SET PERSIST max_relay_log_size = @@GLOBAL.max_relay_log_size;
SET PERSIST relay_log = @@GLOBAL.relay_log;
ERROR HY000: Variable 'relay_log' is a read only variable
SET PERSIST relay_log_basename = @@GLOBAL.relay_log_basename;
ERROR HY000: Variable 'relay_log_basename' is a read only variable
SET PERSIST relay_log_index = @@GLOBAL.relay_log_index;
ERROR HY000: Variable 'relay_log_index' is a read only variable
SET PERSIST relay_log_info_file = @@GLOBAL.relay_log_info_file;
ERROR HY000: Variable 'relay_log_info_file' is a read only variable
SET PERSIST relay_log_info_repository = @@GLOBAL.relay_log_info_repository;
Warnings:
Warning	1287	'@@relay_log_info_repository' is deprecated and will be removed in a future release.
Warning	1287	'@@relay_log_info_repository' is deprecated and will be removed in a future release.
SET PERSIST relay_log_purge = @@GLOBAL.relay_log_purge;
SET PERSIST relay_log_recovery = @@GLOBAL.relay_log_recovery;
ERROR HY000: Variable 'relay_log_recovery' is a read only variable
SET PERSIST relay_log_space_limit = @@GLOBAL.relay_log_space_limit;
ERROR HY000: Variable 'relay_log_space_limit' is a read only variable
SET PERSIST replica_allow_batching = @@GLOBAL.replica_allow_batching;
SET PERSIST replica_checkpoint_group = @@GLOBAL.replica_checkpoint_group;
SET PERSIST replica_checkpoint_period = @@GLOBAL.replica_checkpoint_period;
SET PERSIST replica_compressed_protocol = @@GLOBAL.replica_compressed_protocol;
SET PERSIST replica_exec_mode = @@GLOBAL.replica_exec_mode;
SET PERSIST replica_load_tmpdir = @@GLOBAL.replica_load_tmpdir;
ERROR HY000: Variable 'replica_load_tmpdir' is a read only variable
SET PERSIST replica_max_allowed_packet = @@GLOBAL.replica_max_allowed_packet;
SET PERSIST replica_net_timeout = @@GLOBAL.replica_net_timeout;
SET PERSIST replica_parallel_type = @@GLOBAL.replica_parallel_type;
Warnings:
Warning	1287	'@@replica_parallel_type' is deprecated and will be removed in a future release.
Warning	1287	'@@replica_parallel_type' is deprecated and will be removed in a future release.
SET PERSIST replica_parallel_workers = @@GLOBAL.replica_parallel_workers;
SET PERSIST replica_pending_jobs_size_max = @@GLOBAL.replica_pending_jobs_size_max;
SET PERSIST replica_preserve_commit_order = @@GLOBAL.replica_preserve_commit_order;
SET PERSIST replica_skip_errors = @@GLOBAL.replica_skip_errors;
ERROR HY000: Variable 'replica_skip_errors' is a read only variable
SET PERSIST replica_sql_verify_checksum = @@GLOBAL.replica_sql_verify_checksum;
SET PERSIST replica_transaction_retries = @@GLOBAL.replica_transaction_retries;
SET PERSIST replica_type_conversions = @@GLOBAL.replica_type_conversions;
SET PERSIST replication_optimize_for_static_plugin_config = @@GLOBAL.replication_optimize_for_static_plugin_config;
SET PERSIST replication_sender_observe_commit_only = @@GLOBAL.replication_sender_observe_commit_only;
SET PERSIST rpl_read_size = @@GLOBAL.rpl_read_size;
SET PERSIST rpl_receive_buffer_size = @@GLOBAL.rpl_receive_buffer_size;
SET PERSIST rpl_semi_sync_replica_enabled = @@GLOBAL.rpl_semi_sync_replica_enabled;
SET PERSIST rpl_semi_sync_replica_trace_level = @@GLOBAL.rpl_semi_sync_replica_trace_level;
SET PERSIST rpl_semi_sync_source_enabled = @@GLOBAL.rpl_semi_sync_source_enabled;
SET PERSIST rpl_semi_sync_source_histogram_trx_wait_step_size = @@GLOBAL.rpl_semi_sync_source_histogram_trx_wait_step_size;
SET PERSIST rpl_semi_sync_source_timeout = @@GLOBAL.rpl_semi_sync_source_timeout;
SET PERSIST rpl_semi_sync_source_trace_level = @@GLOBAL.rpl_semi_sync_source_trace_level;
SET PERSIST rpl_semi_sync_source_wait_for_replica_count = @@GLOBAL.rpl_semi_sync_source_wait_for_replica_count;
SET PERSIST rpl_semi_sync_source_wait_no_replica = @@GLOBAL.rpl_semi_sync_source_wait_no_replica;
SET PERSIST rpl_semi_sync_source_wait_point = @@GLOBAL.rpl_semi_sync_source_wait_point;
SET PERSIST rpl_semi_sync_source_whitelist = @@GLOBAL.rpl_semi_sync_source_whitelist;
SET PERSIST rpl_send_buffer_size = @@GLOBAL.rpl_send_buffer_size;
SET PERSIST rpl_slave_flow_control = @@GLOBAL.rpl_slave_flow_control;
SET PERSIST rpl_stop_replica_timeout = @@GLOBAL.rpl_stop_replica_timeout;
SET PERSIST rpl_stop_slave_timeout = @@GLOBAL.rpl_stop_slave_timeout;
Warnings:
Warning	1287	'@@rpl_stop_slave_timeout' is deprecated and will be removed in a future release. Please use rpl_stop_replica_timeout instead.
Warning	1287	'@@rpl_stop_slave_timeout' is deprecated and will be removed in a future release. Please use rpl_stop_replica_timeout instead.
SET PERSIST rpl_wait_for_semi_sync_ack = @@GLOBAL.rpl_wait_for_semi_sync_ack;
SET PERSIST session_track_gtids = @@GLOBAL.session_track_gtids;
SET PERSIST skip_master_info_check_for_read_only_error_msg_extra = @@GLOBAL.skip_master_info_check_for_read_only_error_msg_extra;
SET PERSIST skip_replica_start = @@GLOBAL.skip_replica_start;
ERROR HY000: Variable 'skip_replica_start' is a read only variable
SET PERSIST skip_slave_start = @@GLOBAL.skip_slave_start;
ERROR HY000: Variable 'skip_slave_start' is a read only variable
SET PERSIST slave_allow_batching = @@GLOBAL.slave_allow_batching;
Warnings:
Warning	1287	'@@slave_allow_batching' is deprecated and will be removed in a future release. Please use replica_allow_batching instead.
Warning	1287	'@@slave_allow_batching' is deprecated and will be removed in a future release. Please use replica_allow_batching instead.
SET PERSIST slave_check_before_image_consistency = @@GLOBAL.slave_check_before_image_consistency;
SET PERSIST slave_checkpoint_group = @@GLOBAL.slave_checkpoint_group;
Warnings:
Warning	1287	'@@slave_checkpoint_group' is deprecated and will be removed in a future release. Please use replica_checkpoint_group instead.
Warning	1287	'@@slave_checkpoint_group' is deprecated and will be removed in a future release. Please use replica_checkpoint_group instead.
SET PERSIST slave_checkpoint_period = @@GLOBAL.slave_checkpoint_period;
Warnings:
Warning	1287	'@@slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
Warning	1287	'@@slave_checkpoint_period' is deprecated and will be removed in a future release. Please use replica_checkpoint_period instead.
SET PERSIST slave_compressed_protocol = @@GLOBAL.slave_compressed_protocol;
Warnings:
Warning	1287	'@@slave_compressed_protocol' is deprecated and will be removed in a future release. Please use replica_compressed_protocol instead.
Warning	1287	'@@slave_compressed_protocol' is deprecated and will be removed in a future release. Please use replica_compressed_protocol instead.
SET PERSIST slave_compression_lib = @@GLOBAL.slave_compression_lib;
SET PERSIST slave_dump_thread_wait_sleep_usec = @@GLOBAL.slave_dump_thread_wait_sleep_usec;
SET PERSIST slave_exec_mode = @@GLOBAL.slave_exec_mode;
Warnings:
Warning	1287	'@@slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
Warning	1287	'@@slave_exec_mode' is deprecated and will be removed in a future release. Please use replica_exec_mode instead.
SET PERSIST slave_high_priority_ddl = @@GLOBAL.slave_high_priority_ddl;
SET PERSIST slave_high_priority_lock_wait_timeout = @@GLOBAL.slave_high_priority_lock_wait_timeout;
SET PERSIST slave_load_tmpdir = @@GLOBAL.slave_load_tmpdir;
ERROR HY000: Variable 'slave_load_tmpdir' is a read only variable
SET PERSIST slave_max_allowed_packet = @@GLOBAL.slave_max_allowed_packet;
Warnings:
Warning	1287	'@@slave_max_allowed_packet' is deprecated and will be removed in a future release. Please use replica_max_allowed_packet instead.
Warning	1287	'@@slave_max_allowed_packet' is deprecated and will be removed in a future release. Please use replica_max_allowed_packet instead.
SET PERSIST slave_net_timeout = @@GLOBAL.slave_net_timeout;
Warnings:
Warning	1287	'@@slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_timeout instead.
Warning	1287	'@@slave_net_timeout' is deprecated and will be removed in a future release. Please use replica_net_timeout instead.
SET PERSIST slave_parallel_type = @@GLOBAL.slave_parallel_type;
Warnings:
Warning	1287	'@@slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
Warning	1287	'@@slave_parallel_type' is deprecated and will be removed in a future release. Please use replica_parallel_type instead.
SET PERSIST slave_parallel_workers = @@GLOBAL.slave_parallel_workers;
Warnings:
Warning	1287	'@@slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead.
Warning	1287	'@@slave_parallel_workers' is deprecated and will be removed in a future release. Please use replica_parallel_workers instead.
SET PERSIST slave_pending_jobs_size_max = @@GLOBAL.slave_pending_jobs_size_max;
Warnings:
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.
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.
SET PERSIST slave_preserve_commit_order = @@GLOBAL.slave_preserve_commit_order;
Warnings:
Warning	1287	'@@slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
Warning	1287	'@@slave_preserve_commit_order' is deprecated and will be removed in a future release. Please use replica_preserve_commit_order instead.
SET PERSIST slave_rows_search_algorithms = @@GLOBAL.slave_rows_search_algorithms;
Warnings:
Warning	1287	'@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
Warning	1287	'@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
SET PERSIST slave_run_triggers_for_rbr = @@GLOBAL.slave_run_triggers_for_rbr;
SET PERSIST slave_skip_errors = @@GLOBAL.slave_skip_errors;
ERROR HY000: Variable 'slave_skip_errors' is a read only variable
SET PERSIST slave_sql_verify_checksum = @@GLOBAL.slave_sql_verify_checksum;
Warnings:
Warning	1287	'@@slave_sql_verify_checksum' is deprecated and will be removed in a future release. Please use replica_sql_verify_checksum instead.
Warning	1287	'@@slave_sql_verify_checksum' is deprecated and will be removed in a future release. Please use replica_sql_verify_checksum instead.
SET PERSIST slave_transaction_retries = @@GLOBAL.slave_transaction_retries;
Warnings:
Warning	1287	'@@slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_transaction_retries instead.
Warning	1287	'@@slave_transaction_retries' is deprecated and will be removed in a future release. Please use replica_transaction_retries instead.
SET PERSIST slave_type_conversions = @@GLOBAL.slave_type_conversions;
Warnings:
Warning	1287	'@@slave_type_conversions' is deprecated and will be removed in a future release. Please use replica_type_conversions instead.
Warning	1287	'@@slave_type_conversions' is deprecated and will be removed in a future release. Please use replica_type_conversions instead.
SET PERSIST slave_use_idempotent_for_recovery = @@GLOBAL.slave_use_idempotent_for_recovery;
SET PERSIST source_verify_checksum = @@GLOBAL.source_verify_checksum;
SET PERSIST sql_log_bin_triggers = @@GLOBAL.sql_log_bin_triggers;
SET PERSIST sql_replica_skip_counter = @@GLOBAL.sql_replica_skip_counter;
SET PERSIST sql_slave_skip_counter = @@GLOBAL.sql_slave_skip_counter;
Warnings:
Warning	1287	'@@sql_slave_skip_counter' is deprecated and will be removed in a future release. Please use sql_replica_skip_counter instead.
Warning	1287	'@@sql_slave_skip_counter' is deprecated and will be removed in a future release. Please use sql_replica_skip_counter instead.
SET PERSIST sync_binlog = @@GLOBAL.sync_binlog;
SET PERSIST sync_master_info = @@GLOBAL.sync_master_info;
Warnings:
Warning	1287	'@@sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
Warning	1287	'@@sync_master_info' is deprecated and will be removed in a future release. Please use sync_source_info instead.
SET PERSIST sync_relay_log = @@GLOBAL.sync_relay_log;
SET PERSIST sync_relay_log_info = @@GLOBAL.sync_relay_log_info;
SET PERSIST sync_source_info = @@GLOBAL.sync_source_info;

include/assert.inc ['Expect $expected persisted variables in persisted_variables table.']

############################################################
# 2. Restart server, it must preserve the persisted variable
#    settings. Verify persisted configuration.
# restart

include/assert.inc ['Expect $expected persisted variables in persisted_variables table.']
include/assert.inc ['Expect $expected persisted variables shown as PERSISTED in variables_info table.']
include/assert.inc ['Expect $expected persisted variables with matching persisted and global values.']

############################################################
# 3. Test RESET PERSIST IF EXISTS. Verify persisted variable
#    settings are removed.
RESET PERSIST IF EXISTS binlog_cache_size;
RESET PERSIST IF EXISTS binlog_checksum;
RESET PERSIST IF EXISTS binlog_direct_non_transactional_updates;
RESET PERSIST IF EXISTS binlog_encryption;
RESET PERSIST IF EXISTS binlog_error_action;
RESET PERSIST IF EXISTS binlog_expire_logs_auto_purge;
RESET PERSIST IF EXISTS binlog_expire_logs_seconds;
RESET PERSIST IF EXISTS binlog_format;
RESET PERSIST IF EXISTS binlog_group_commit_sync_delay;
RESET PERSIST IF EXISTS binlog_group_commit_sync_no_delay_count;
RESET PERSIST IF EXISTS binlog_gtid_simple_recovery;
Warnings:
Warning	3615	Variable binlog_gtid_simple_recovery does not exist in persisted config file
RESET PERSIST IF EXISTS binlog_max_flush_queue_time;
RESET PERSIST IF EXISTS binlog_order_commits;
RESET PERSIST IF EXISTS binlog_rotate_encryption_master_key_at_startup;
Warnings:
Warning	3615	Variable binlog_rotate_encryption_master_key_at_startup does not exist in persisted config file
RESET PERSIST IF EXISTS binlog_row_event_max_size;
Warnings:
Warning	3615	Variable binlog_row_event_max_size does not exist in persisted config file
RESET PERSIST IF EXISTS binlog_row_image;
RESET PERSIST IF EXISTS binlog_row_metadata;
RESET PERSIST IF EXISTS binlog_row_value_options;
RESET PERSIST IF EXISTS binlog_rows_event_max_rows;
RESET PERSIST IF EXISTS binlog_rows_query_log_events;
RESET PERSIST IF EXISTS binlog_stmt_cache_size;
RESET PERSIST IF EXISTS binlog_transaction_compression;
RESET PERSIST IF EXISTS binlog_transaction_compression_level_zstd;
RESET PERSIST IF EXISTS binlog_transaction_dependency_history_size;
RESET PERSIST IF EXISTS binlog_transaction_dependency_tracking;
RESET PERSIST IF EXISTS binlog_trx_meta_data;
RESET PERSIST IF EXISTS enable_binlog_hlc;
RESET PERSIST IF EXISTS enforce_gtid_consistency;
RESET PERSIST IF EXISTS group_replication_consistency;
RESET PERSIST IF EXISTS gtid_committed;
Warnings:
Warning	3615	Variable gtid_committed does not exist in persisted config file
RESET PERSIST IF EXISTS gtid_executed;
Warnings:
Warning	3615	Variable gtid_executed does not exist in persisted config file
RESET PERSIST IF EXISTS gtid_executed_compression_period;
RESET PERSIST IF EXISTS gtid_mode;
RESET PERSIST IF EXISTS gtid_owned;
Warnings:
Warning	3615	Variable gtid_owned does not exist in persisted config file
RESET PERSIST IF EXISTS gtid_purged;
Warnings:
Warning	3615	Variable gtid_purged does not exist in persisted config file
RESET PERSIST IF EXISTS init_replica;
RESET PERSIST IF EXISTS init_slave;
Warnings:
Warning	3615	Variable init_slave does not exist in persisted config file
RESET PERSIST IF EXISTS log_bin;
Warnings:
Warning	3615	Variable log_bin does not exist in persisted config file
RESET PERSIST IF EXISTS log_bin_basename;
Warnings:
Warning	3615	Variable log_bin_basename does not exist in persisted config file
RESET PERSIST IF EXISTS log_bin_index;
Warnings:
Warning	3615	Variable log_bin_index does not exist in persisted config file
RESET PERSIST IF EXISTS log_bin_trust_function_creators;
RESET PERSIST IF EXISTS log_bin_use_v1_row_events;
Warnings:
Warning	3615	Variable log_bin_use_v1_row_events does not exist in persisted config file
RESET PERSIST IF EXISTS log_replica_updates;
Warnings:
Warning	3615	Variable log_replica_updates does not exist in persisted config file
RESET PERSIST IF EXISTS log_slave_updates;
Warnings:
Warning	3615	Variable log_slave_updates does not exist in persisted config file
RESET PERSIST IF EXISTS log_slow_replica_statements;
RESET PERSIST IF EXISTS log_slow_slave_statements;
Warnings:
Warning	3615	Variable log_slow_slave_statements does not exist in persisted config file
RESET PERSIST IF EXISTS log_statements_unsafe_for_binlog;
RESET PERSIST IF EXISTS master_info_repository;
RESET PERSIST IF EXISTS master_verify_checksum;
RESET PERSIST IF EXISTS max_binlog_cache_size;
RESET PERSIST IF EXISTS max_binlog_size;
RESET PERSIST IF EXISTS max_binlog_stmt_cache_size;
RESET PERSIST IF EXISTS max_relay_log_size;
RESET PERSIST IF EXISTS relay_log;
Warnings:
Warning	3615	Variable relay_log does not exist in persisted config file
RESET PERSIST IF EXISTS relay_log_basename;
Warnings:
Warning	3615	Variable relay_log_basename does not exist in persisted config file
RESET PERSIST IF EXISTS relay_log_index;
Warnings:
Warning	3615	Variable relay_log_index does not exist in persisted config file
RESET PERSIST IF EXISTS relay_log_info_file;
Warnings:
Warning	3615	Variable relay_log_info_file does not exist in persisted config file
RESET PERSIST IF EXISTS relay_log_info_repository;
RESET PERSIST IF EXISTS relay_log_purge;
RESET PERSIST IF EXISTS relay_log_recovery;
Warnings:
Warning	3615	Variable relay_log_recovery does not exist in persisted config file
RESET PERSIST IF EXISTS relay_log_space_limit;
Warnings:
Warning	3615	Variable relay_log_space_limit does not exist in persisted config file
RESET PERSIST IF EXISTS replica_allow_batching;
RESET PERSIST IF EXISTS replica_checkpoint_group;
RESET PERSIST IF EXISTS replica_checkpoint_period;
RESET PERSIST IF EXISTS replica_compressed_protocol;
RESET PERSIST IF EXISTS replica_exec_mode;
RESET PERSIST IF EXISTS replica_load_tmpdir;
Warnings:
Warning	3615	Variable replica_load_tmpdir does not exist in persisted config file
RESET PERSIST IF EXISTS replica_max_allowed_packet;
RESET PERSIST IF EXISTS replica_net_timeout;
RESET PERSIST IF EXISTS replica_parallel_type;
RESET PERSIST IF EXISTS replica_parallel_workers;
RESET PERSIST IF EXISTS replica_pending_jobs_size_max;
RESET PERSIST IF EXISTS replica_preserve_commit_order;
RESET PERSIST IF EXISTS replica_skip_errors;
Warnings:
Warning	3615	Variable replica_skip_errors does not exist in persisted config file
RESET PERSIST IF EXISTS replica_sql_verify_checksum;
RESET PERSIST IF EXISTS replica_transaction_retries;
RESET PERSIST IF EXISTS replica_type_conversions;
RESET PERSIST IF EXISTS replication_optimize_for_static_plugin_config;
RESET PERSIST IF EXISTS replication_sender_observe_commit_only;
RESET PERSIST IF EXISTS rpl_read_size;
RESET PERSIST IF EXISTS rpl_receive_buffer_size;
RESET PERSIST IF EXISTS rpl_semi_sync_replica_enabled;
RESET PERSIST IF EXISTS rpl_semi_sync_replica_trace_level;
RESET PERSIST IF EXISTS rpl_semi_sync_source_enabled;
RESET PERSIST IF EXISTS rpl_semi_sync_source_histogram_trx_wait_step_size;
RESET PERSIST IF EXISTS rpl_semi_sync_source_timeout;
RESET PERSIST IF EXISTS rpl_semi_sync_source_trace_level;
RESET PERSIST IF EXISTS rpl_semi_sync_source_wait_for_replica_count;
RESET PERSIST IF EXISTS rpl_semi_sync_source_wait_no_replica;
RESET PERSIST IF EXISTS rpl_semi_sync_source_wait_point;
RESET PERSIST IF EXISTS rpl_semi_sync_source_whitelist;
RESET PERSIST IF EXISTS rpl_send_buffer_size;
RESET PERSIST IF EXISTS rpl_slave_flow_control;
RESET PERSIST IF EXISTS rpl_stop_replica_timeout;
RESET PERSIST IF EXISTS rpl_stop_slave_timeout;
Warnings:
Warning	3615	Variable rpl_stop_slave_timeout does not exist in persisted config file
RESET PERSIST IF EXISTS rpl_wait_for_semi_sync_ack;
RESET PERSIST IF EXISTS session_track_gtids;
RESET PERSIST IF EXISTS skip_master_info_check_for_read_only_error_msg_extra;
RESET PERSIST IF EXISTS skip_replica_start;
Warnings:
Warning	3615	Variable skip_replica_start does not exist in persisted config file
RESET PERSIST IF EXISTS skip_slave_start;
Warnings:
Warning	3615	Variable skip_slave_start does not exist in persisted config file
RESET PERSIST IF EXISTS slave_allow_batching;
Warnings:
Warning	3615	Variable slave_allow_batching does not exist in persisted config file
RESET PERSIST IF EXISTS slave_check_before_image_consistency;
RESET PERSIST IF EXISTS slave_checkpoint_group;
Warnings:
Warning	3615	Variable slave_checkpoint_group does not exist in persisted config file
RESET PERSIST IF EXISTS slave_checkpoint_period;
Warnings:
Warning	3615	Variable slave_checkpoint_period does not exist in persisted config file
RESET PERSIST IF EXISTS slave_compressed_protocol;
Warnings:
Warning	3615	Variable slave_compressed_protocol does not exist in persisted config file
RESET PERSIST IF EXISTS slave_compression_lib;
RESET PERSIST IF EXISTS slave_dump_thread_wait_sleep_usec;
RESET PERSIST IF EXISTS slave_exec_mode;
Warnings:
Warning	3615	Variable slave_exec_mode does not exist in persisted config file
RESET PERSIST IF EXISTS slave_high_priority_ddl;
RESET PERSIST IF EXISTS slave_high_priority_lock_wait_timeout;
RESET PERSIST IF EXISTS slave_load_tmpdir;
Warnings:
Warning	3615	Variable slave_load_tmpdir does not exist in persisted config file
RESET PERSIST IF EXISTS slave_max_allowed_packet;
Warnings:
Warning	3615	Variable slave_max_allowed_packet does not exist in persisted config file
RESET PERSIST IF EXISTS slave_net_timeout;
Warnings:
Warning	3615	Variable slave_net_timeout does not exist in persisted config file
RESET PERSIST IF EXISTS slave_parallel_type;
Warnings:
Warning	3615	Variable slave_parallel_type does not exist in persisted config file
RESET PERSIST IF EXISTS slave_parallel_workers;
Warnings:
Warning	3615	Variable slave_parallel_workers does not exist in persisted config file
RESET PERSIST IF EXISTS slave_pending_jobs_size_max;
Warnings:
Warning	3615	Variable slave_pending_jobs_size_max does not exist in persisted config file
RESET PERSIST IF EXISTS slave_preserve_commit_order;
Warnings:
Warning	3615	Variable slave_preserve_commit_order does not exist in persisted config file
RESET PERSIST IF EXISTS slave_rows_search_algorithms;
RESET PERSIST IF EXISTS slave_run_triggers_for_rbr;
RESET PERSIST IF EXISTS slave_skip_errors;
Warnings:
Warning	3615	Variable slave_skip_errors does not exist in persisted config file
RESET PERSIST IF EXISTS slave_sql_verify_checksum;
Warnings:
Warning	3615	Variable slave_sql_verify_checksum does not exist in persisted config file
RESET PERSIST IF EXISTS slave_transaction_retries;
Warnings:
Warning	3615	Variable slave_transaction_retries does not exist in persisted config file
RESET PERSIST IF EXISTS slave_type_conversions;
Warnings:
Warning	3615	Variable slave_type_conversions does not exist in persisted config file
RESET PERSIST IF EXISTS slave_use_idempotent_for_recovery;
RESET PERSIST IF EXISTS source_verify_checksum;
Warnings:
Warning	3615	Variable source_verify_checksum does not exist in persisted config file
RESET PERSIST IF EXISTS sql_log_bin_triggers;
RESET PERSIST IF EXISTS sql_replica_skip_counter;
RESET PERSIST IF EXISTS sql_slave_skip_counter;
Warnings:
Warning	3615	Variable sql_slave_skip_counter does not exist in persisted config file
RESET PERSIST IF EXISTS sync_binlog;
RESET PERSIST IF EXISTS sync_master_info;
RESET PERSIST IF EXISTS sync_relay_log;
RESET PERSIST IF EXISTS sync_relay_log_info;
RESET PERSIST IF EXISTS sync_source_info;
Warnings:
Warning	3615	Variable sync_source_info does not exist in persisted config file

include/assert.inc [Expect 0 persisted variables.]

############################################################
# 4. Clean up.
UNINSTALL PLUGIN rpl_semi_sync_source;
UNINSTALL PLUGIN rpl_semi_sync_replica;
DROP TABLE rplvars;