Debian Codegraph @

mysql-test/suite/rpl/t/rpl_deprecations.test

raw
1 --source include/master-slave.inc
2
3 # no need to run multiple times
4 --source include/have_binlog_format_row.inc
5 --source include/have_slave_repository_type_table.inc
6 --source include/only_mts_replica_parallel_workers.inc
7 --source include/only_replica_preserve_commit_order.inc
8 --source include/only_mts_replica_parallel_type_logical_clock.inc
9 --source include/have_default_replica_transaction_retries.inc
10 --source include/have_default_slave_rows_search_algorithms.inc
11 --source include/have_default_binlog_transaction_dependency_tracking.inc
12
13 #####################################################################
14 # WL#12926: Deprecate --log_bin_use_v1_row_events #
15 # WL#11031: Deprecate --relay-log-info-file and --master-info-file #
16 # WL#12892: Deprecate --slave_rows_search_algorithms #
17 # WL#13958: Deprecate relay_log_info_repository #
18 # WL#14526: Deprecate disconnect-slave-event-count #
19 # and abort-slave-event-count #
20 # WL#13968: Deprecate sync_relay_log_info #
21 # WL#13964: Deprecate binlog_transaction_dependency_tracking #
22 #####################################################################
23
24 --source include/rpl_connection_slave.inc
25 --source include/stop_slave.inc
26
27 --let $rpl_server_number= 2
28 --let $rpl_omit_print_server_parameters=1
29
30 --let $MYSQLD_DATADIR= `SELECT @@datadir`
31 --let $rli_file=$MYSQLD_DATADIR/relay-log.info
32 --let $mi_file=$MYSQLD_DATADIR/master.info
33
34 # assert deprecation warning (TABLE), deprecation warning (FILE) and revert
35 SET @@global.master_info_repository="TABLE";
36 SET @@global.master_info_repository="FILE";
37 SET @@global.master_info_repository="TABLE";
38
39 # assert deprecation warning (TABLE), deprecation warning (FILE) and revert
40 SET @@global.relay_log_info_repository="TABLE";
41 SET @@global.relay_log_info_repository="FILE";
42 SET @@global.relay_log_info_repository="TABLE";
43
44 # check reading deprecated system variables
45 SELECT @@global.log_bin_use_v1_row_events;
46 SET @@global.log_bin_use_v1_row_events = TRUE;
47 SELECT @@global.relay_log_info_file;
48 --replace_regex /INDEX_SCAN,HASH_SCAN/SCAN_METHOD,SCAN_METHOD/ /TABLE_SCAN,INDEX_SCAN/SCAN_METHOD,SCAN_METHOD/
49 SELECT @@global.slave_rows_search_algorithms;
50
51 # assert deprecation warning (WRITESET), deprecation warning (MURMUR32) and revert
52 SET GLOBAL binlog_transaction_dependency_tracking = COMMIT_ORDER;
53 SET @@global.transaction_write_set_extraction='XXHASH64';
54 SET @@global.transaction_write_set_extraction='MURMUR32';
55 SET @@session.transaction_write_set_extraction='XXHASH64';
56 SET @@session.transaction_write_set_extraction='MURMUR32';
57
58 # assert deprecation warning replica_parallel_type
59 SET GLOBAL replica_parallel_type='LOGICAL_CLOCK';
60 SET GLOBAL replica_parallel_type='DATABASE';
61
62 # assert deprecation warning replica_parallel_workers 0
63 SET GLOBAL replica_parallel_workers=0;
64 SET GLOBAL replica_parallel_workers=1;
65
66 # assert deprecation warning for binlog_transaction_dependency_tracking
67 SET GLOBAL binlog_transaction_dependency_tracking=COMMIT_ORDER;
68 SET GLOBAL binlog_transaction_dependency_tracking=WRITESET;
69 SET GLOBAL binlog_transaction_dependency_tracking=WRITESET_SESSION;
70
71 --let $suppress_mode = IGNORE_GLOBAL_SUPPRESSIONS
72 let $messages =
73 .* is deprecated and will be removed in a future release.*
74 ;
75 --source include/suppress_messages.inc
76
77 --let $suppress_mode = IGNORE_GLOBAL_SUPPRESSIONS
78 let $messages =
79 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
80 ;
81 --source include/suppress_messages.inc
82
83 --let $suppress_mode = ADD_SUPPRESSIONS
84 let $messages =
85 The syntax '--master-retry-count' is deprecated and will be removed in a future release.*
86 ;
87 --source include/suppress_messages.inc
88
89 --let $suppress_mode = ADD_SUPPRESSIONS
90 let $messages =
91 The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
92 ;
93 --source include/suppress_messages.inc
94
95 --let $i = 2
96
97 while($i > 0) {
98 if ($i == 2) {
99 --let $rpl_server_parameters = --binlog_format=ROW --sync-relay-log-info=10005 --master-info-repository=TABLE --master-info-file=$mi_file --log-bin-use-v1-row-events --skip-replica-start --relay-log-info-repository=FILE --relay-log-info-file=$rli_file --slave-rows-search-algorithms=INDEX_SCAN,HASH_SCAN --transaction-write-set-extraction=XXHASH64 --disconnect-slave-event-count=2 --abort-slave-event-count=1 --replica-parallel-type=LOGICAL_CLOCK --replica-parallel-workers=0 --binlog-transaction-dependency-tracking=WRITESET_SESSION
100 }
101
102 if ($i == 1)
103 {
104 # check that warnings are emited when setting persist_only as well
105 SET PERSIST_ONLY relay_log_info_repository='FILE';
106 SET PERSIST_ONLY master_info_repository='TABLE';
107 SET PERSIST_ONLY transaction_write_set_extraction='MURMUR32';
108 SET PERSIST_ONLY transaction_write_set_extraction='XXHASH64';
109 SET PERSIST_ONLY replica_parallel_type='DATABASE';
110 SET PERSIST_ONLY replica_parallel_type='LOGICAL_CLOCK';
111 SET PERSIST_ONLY binlog_transaction_dependency_tracking=WRITESET_SESSION;
112 SET PERSIST_ONLY binlog_transaction_dependency_tracking=COMMIT_ORDER;
113 SET PERSIST_ONLY binlog_transaction_dependency_tracking=WRITESET;
114
115 # Warning is not emitted when setting a deprecated value to
116 # a variable with persist_only
117 SET PERSIST_ONLY replica_parallel_workers=0;
118
119 # check that warnings are emited when setting persist as well
120 SET PERSIST relay_log_info_repository='FILE';
121 SET PERSIST master_info_repository='TABLE';
122 SET PERSIST slave_rows_search_algorithms=TABLE_SCAN;
123 SET PERSIST binlog_transaction_dependency_tracking = COMMIT_ORDER;
124 SET PERSIST transaction_write_set_extraction='MURMUR32';
125 SET PERSIST transaction_write_set_extraction='XXHASH64';
126 SET PERSIST replica_parallel_type='DATABASE';
127 SET PERSIST replica_parallel_type='LOGICAL_CLOCK';
128 SET PERSIST replica_parallel_workers=0;
129 SET PERSIST binlog_format=ROW;
130 SET PERSIST sync_relay_log_info=10005;
131 SET PERSIST binlog_transaction_dependency_tracking=WRITESET;
132 SET PERSIST binlog_transaction_dependency_tracking=WRITESET_SESSION;
133 SET PERSIST binlog_transaction_dependency_tracking=COMMIT_ORDER;
134
135 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
136 SET PERSIST_ONLY log_bin_use_v1_row_events = TRUE;
137 --replace_result $rli_file RLI_FILE
138 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
139
140 --eval SET PERSIST_ONLY relay_log_info_file = "$rli_file"
141 --let $rpl_server_parameters= --binlog_format=ROW
142 }
143
144 --let $rpl_omit_print_server_parameters = 2
145 --let $rpl_server_number = 2
146 --source include/save_error_log_position.inc
147 --source include/rpl_restart_server.inc
148
149 if($i==2)
150 {
151 # Check that the warnings are logged in the Error log if the deprecated variables were passed on the command line.
152 let $error_pattern = 'binlog_format' is deprecated and will be removed in a future release.
153 '--sync-relay-log-info' is deprecated and will be removed in a future release.
154 The syntax '--master-info-repository' is deprecated and will be removed in a future release.
155 The syntax '--master-info-file' is deprecated and will be removed in a future release.
156 The syntax '--log-bin-use-v1-row-events' is deprecated and will be removed in a future release.
157 The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
158 The syntax '--relay-log-info-file' is deprecated and will be removed in a future release.
159 The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release.
160 The syntax '--transaction-write-set-extraction' is deprecated and will be removed in a future release.
161 The syntax '--disconnect-slave-event-count' is deprecated and will be removed in a future release.
162 The syntax '--abort-slave-event-count' is deprecated and will be removed in a future release.
163 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
164 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
165 The syntax '--binlog-transaction-dependency-tracking' is deprecated and will be removed in a future release.
166 ;
167 --source include/assert_error_log.inc
168 }
169
170 if ($i==1)
171 {
172 # Check that the warnings are logged in the Error log if the deprecated variables were persisted before server restart.
173 let $error_pattern = 'binlog_format' is deprecated and will be removed in a future release.
174 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
175 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
176 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
177 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
178 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
179 '@@master_info_repository' is deprecated and will be removed in a future release.
180 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
181 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
182 '@@binlog_format' is deprecated and will be removed in a future release.
183 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
184 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
185 ;
186 --source include/assert_error_log.inc
187 }
188 --dec $i
189 }
190 # #############################################################
191
192 --let $suppress_mode = ADD_SUPPRESSIONS
193 let $messages =
194 'binlog_format' is deprecated and will be removed in a future release.
195 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
196 ;
197 --source include/suppress_messages.inc
198
199 --let $suppress_mode = ADD_SUPPRESSIONS
200 let $messages =
201 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
202 ;
203 --source include/suppress_messages.inc
204
205 # revert to vanilla options
206 RESET PERSIST;
207 --let $rpl_server_parameters=
208 --let $rpl_omit_print_server_parameters=0
209 --source include/rpl_restart_server.inc
210 --source include/start_slave.inc
211
212 --source include/rpl_connection_master.inc
213 --source include/rpl_reset.inc
214
215 --source include/rpl_end.inc