Debian Codegraph @

mysql-test/suite/binlog_nogtid/t/binlog_persist_only_variables.test

raw
1 ################################################################################
2 # The aim of this testcase is to test persisted behavior of replication
3 # variables with SET PERSIST_ONLY and RESET PERSIST clauses.
4 #
5 # Test:
6 # 0. Check that there are no persisted variable settings due to improper
7 # cleanup by other testcases.
8 # 1. Test SET PERSIST_ONLY. Verify persisted variables.
9 # 2. Restart server, it must preserve the persisted variable settings.
10 # Verify persisted configuration.
11 # 3. Test RESET PERSIST. Verify persisted variable settings are removed.
12 # 4. Clean up.
13 ################################################################################
14 --source include/have_log_bin.inc
15 --source include/have_semisync_plugin.inc
16 # Test is agnostic to binlog_format.
17 --source include/have_binlog_format_row.inc
18
19
20 --echo ############################################################
21 --echo # 0. Check that there are no persisted variable settings.
22 --let $assert_text = Expect 0 persisted variables.
23 --let $assert_cond = [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = 0
24 --source include/assert.inc
25
26
27 --echo
28 --echo ############################################################
29 --echo # 1. Initialization. Test SET PERSIST_ONLY. Verify persisted
30 --echo # variables.
31 --let $MYSQLD_DATADIR= `select @@datadir;`
32 CALL mtr.add_suppression("Unsafe statement written to the binary log");
33
34 --echo # Install semi-sync related plugins
35 --replace_result $SEMISYNC_SOURCE_PLUGIN SEMISYNC_SOURCE_PLUGIN
36 eval INSTALL PLUGIN rpl_semi_sync_source SONAME '$SEMISYNC_SOURCE_PLUGIN';
37 --replace_result $SEMISYNC_REPLICA_PLUGIN SEMISYNC_REPLICA_PLUGIN
38 eval INSTALL PLUGIN rpl_semi_sync_replica SONAME '$SEMISYNC_REPLICA_PLUGIN';
39
40 CREATE TABLE rplvars (id INT PRIMARY KEY AUTO_INCREMENT, varname VARCHAR(64), varvalue VARCHAR(256));
41 # Disable warning to avoid printing of ER_BINLOG_UNSAFE_STATEMENT
42 --disable_warnings
43 INSERT INTO rplvars (varname, varvalue)
44 SELECT * FROM performance_schema.global_variables
45 WHERE (VARIABLE_NAME LIKE '%binlog%' OR
46 VARIABLE_NAME LIKE '%gtid%' OR
47 VARIABLE_NAME LIKE '%log_bin%' OR
48 VARIABLE_NAME LIKE '%master%' OR
49 VARIABLE_NAME LIKE '%relay%' OR
50 VARIABLE_NAME LIKE '%replica%' OR
51 VARIABLE_NAME LIKE '%rpl%' OR
52 VARIABLE_NAME LIKE '%semi_sync%' OR
53 VARIABLE_NAME LIKE '%slave%' OR
54 VARIABLE_NAME LIKE '%source%') AND
55 (VARIABLE_NAME NOT IN ('innodb_api_enable_binlog',
56 'innodb_master_thread_disabled_debug', 'innodb_replication_delay'))
57 ORDER BY VARIABLE_NAME;
58 --enable_warnings
59 --let $countvars= `SELECT COUNT(*) FROM rplvars;`
60
61 CREATE TABLE non_persisted (name VARCHAR(100) PRIMARY KEY);
62 INSERT INTO non_persisted VALUES
63 ('gtid_executed'), ('gtid_owned'), ('gtid_purged'), ('log_bin'),
64 ('log_bin_basename'), ('log_bin_index'), ('relay_log'), ('relay_log_basename'),
65 ('relay_log_index'), ('relay_log_info_file'), ('replica_load_tmpdir'),
66 ('slave_load_tmpdir'), ('log_bin_use_v1_row_events');
67
68 CREATE TABLE aliases (
69 name VARCHAR(100) PRIMARY KEY
70 );
71 INSERT INTO aliases(name) VALUES
72 ('init_slave'), ('rpl_stop_slave_timeout'), ('log_slow_slave_statements'),
73 ('slave_max_allowed_packet'), ('slave_compressed_protocol'),
74 ('slave_exec_mode'), ('slave_type_conversions'),
75 ('slave_sql_verify_checksum'), ('slave_parallel_type'),
76 ('slave_preserve_commit_order'), ('master_verify_checksum'),
77 ('log_slave_updates'), ('slave_allow_batching'), ('slave_load_tmpdir'),
78 ('slave_net_timeout'), ('sql_slave_skip_counter'), ('slave_skip_errors'),
79 ('slave_checkpoint_period'), ('slave_checkpoint_group'),
80 ('sync_master_info'), ('slave_transaction_retries'),
81 ('slave_parallel_workers'), ('slave_pending_jobs_size_max'),
82 ('pseudo_slave_mode'), ('skip_slave_start');
83
84 # If this count differs, it means a variable has been added or removed.
85 # In that case, this testcase needs to be updated accordingly.
86 --echo
87 --let $expected = 114
88 --let $assert_text = Expect $expected variables in the table.
89 --let $assert_cond = [SELECT COUNT(*) as count FROM rplvars, count, 1] = $expected
90 --source include/assert.inc
91
92 --echo
93 --echo # Test SET PERSIST_ONLY
94 --let $varid=1
95 while ( $varid <= $countvars )
96 {
97 --let $varname= `SELECT varname FROM rplvars WHERE id=$varid`
98
99 # Following variables are non persistent read only variables.
100 if (`SELECT COUNT(*) FROM non_persisted WHERE name = '$varname'`)
101 {
102 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
103 }
104 --eval SET PERSIST_ONLY $varname = @@GLOBAL.$varname
105
106 # TODO: Remove/update this once Bug#27322592 is FIXED.
107 if (`SELECT '$varname' IN ('binlog_direct_non_transactional_updates', 'binlog_order_commits', 'binlog_rows_query_log_events', 'log_bin_trust_function_creators', 'log_slow_replica_statements', 'log_statements_unsafe_for_binlog', 'source_verify_checksum', 'replica_allow_batching', 'replica_compressed_protocol', 'replica_preserve_commit_order', 'replica_sql_verify_checksum', 'relay_log_purge', 'rpl_semi_sync_source_enabled', 'rpl_semi_sync_source_wait_no_replica', 'rpl_semi_sync_replica_enabled', 'binlog_gtid_simple_recovery', 'log_replica_updates', 'relay_log_recovery', 'binlog_rotate_encryption_master_key_at_startup', 'binlog_transaction_compression')`)
108 {
109 --disable_query_log
110 --eval SELECT varvalue INTO @varvalue FROM rplvars WHERE id=$varid
111 --eval SET PERSIST_ONLY $varname = @varvalue
112 --enable_query_log
113 }
114
115 --inc $varid
116 }
117
118 --echo
119 --let $expected = 101
120 --let $assert_text = Expect $expected persisted variables in persisted_variables table.
121 --let $assert_cond = [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = $expected
122 --source include/assert.inc
123
124 --echo
125 --echo ############################################################
126 --echo # 2. Restart server, it must preserve the persisted variable
127 --echo # settings. Verify persisted configuration.
128 --source include/restart_mysqld.inc
129 --source include/wait_until_connected_again.inc
130
131 --echo
132 --let $assert_text = Expect $expected persisted variables in persisted_variables table.
133 --let $assert_cond = [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = $expected
134 --source include/assert.inc
135
136 # Due to the following bug, variable_source is wrong for
137 # skip_slave_start/skip_replica_start:
138 # BUG#32640588: SOURCE FOR SKIP_SLAVE_START DISPLAYED AS COMPILED WHEN IT IS PERSISTED
139 --let $assert_text = Expect $expected persisted variables shown as PERSISTED in variables_info table.
140 --let $assert_cond = [SELECT COUNT(*) as count FROM performance_schema.variables_info WHERE variable_source="PERSISTED" OR variable_name LIKE "skip_%_start", count, 1] = $expected
141 --source include/assert.inc
142
143 --let $assert_text = Expect $expected persisted variables with matching persisted and global values.
144 --let $assert_cond = [SELECT COUNT(*) as count FROM performance_schema.variables_info vi JOIN performance_schema.persisted_variables pv JOIN performance_schema.global_variables gv ON vi.variable_name=pv.variable_name AND vi.variable_name=gv.variable_name AND pv.variable_value=gv.variable_value WHERE vi.variable_source="PERSISTED" OR vi.variable_name LIKE "skip_%_start", count, 1] = $expected
145 --source include/assert.inc
146
147
148 --echo
149 --echo ############################################################
150 --echo # 3. Test RESET PERSIST. Verify persisted variable settings
151 --echo # are removed.
152 --let $varid=1
153 while ( $varid <= $countvars )
154 {
155 --let $varname= `SELECT varname FROM rplvars WHERE id=$varid`
156
157 if (!`SELECT COUNT(*) FROM aliases WHERE name = '$varname'`)
158 {
159 if (`SELECT COUNT(*) FROM non_persisted WHERE name = '$varname'`)
160 {
161 --error ER_VAR_DOES_NOT_EXIST
162 }
163 --eval RESET PERSIST $varname
164 }
165
166 --inc $varid
167 }
168
169 --echo
170 --let $assert_text = Expect 0 persisted variables.
171 --let $assert_cond = [SELECT COUNT(*) as count FROM performance_schema.persisted_variables, count, 1] = 0
172 --source include/assert.inc
173
174
175 --echo
176 --echo ############################################################
177 --echo # 4. Clean up.
178 --let $countvars=
179 --let $varid=
180 --let $varname=
181 --let $varvalue=
182 SET @varvalue=NULL;
183 --remove_file $MYSQLD_DATADIR/mysqld-auto.cnf
184 UNINSTALL PLUGIN rpl_semi_sync_source;
185 UNINSTALL PLUGIN rpl_semi_sync_replica;
186 DROP TABLE rplvars;
187 DROP TABLE aliases;
188 DROP TABLE non_persisted;