Debian Codegraph @

mysql-test/suite/rpl/r/rpl_log_info_repository_persistence.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 [connection slave]
7 CALL mtr.add_suppression("Error reading relay log configuration");
8 CALL mtr.add_suppression("Failed to create or recover replication info repositories");
9 CALL mtr.add_suppression("Replica SQL for channel '': Invalid, corrupted PRIVILEGE_CHECKS_USER was found in the replication configuration repository");
10 CALL mtr.add_suppression("PRIVILEGE_CHECKS_USER for replication channel '' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user");
11 CALL mtr.add_suppression("Replica: Failed to initialize the connection metadata structure for channel '';");
12 CALL mtr.add_suppression("Replica SQL for channel '': Replica failed to initialize applier metadata structure from the repository");
13 CALL mtr.add_suppression("Replica SQL for channel 'ch1': Invalid, corrupted PRIVILEGE_CHECKS_USER was found in the replication configuration repository");
14 CALL mtr.add_suppression("PRIVILEGE_CHECKS_USER for replication channel 'ch1' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user");
15 CALL mtr.add_suppression("Replica: Failed to initialize the connection metadata structure for channel 'ch1';");
16 CALL mtr.add_suppression("Replica SQL for channel 'ch1': Replica failed to initialize applier metadata structure from the repository");
17 CREATE USER 'replication_applier'@'localhost' IDENTIFIED BY 'password';
18 GRANT REPLICATION_APPLIER ON * . * TO 'replication_applier'@'localhost';
19 FLUSH PRIVILEGES;
20 #
21 # TC.P.F1: CHANGE MASTER sets the PRIVILEGE_CHECKS_USER correctly.
22 #
23 STOP SLAVE;
24 Warnings:
25 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
26 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER=NULL;
27 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
28 FLUSH RELAY LOGS;
29 START SLAVE;
30 Warnings:
31 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
32 include/assert.inc [Check that mysql.slave_relay_log_info does not have any entry]
33 include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
34 Matching lines are:
35 replication_applier
36 Occurrences of 'replication_applier' in the input file: 1
37 Matching lines are:
38 localhost
39 Occurrences of 'localhost' in the input file: 1
40 #
41 # TC.P.F2: PRIVILEGE_CHECKS_USER persists after restarting the server.
42 #
43 include/rpl_restart_server.inc [server_number=2]
44 include/assert.inc [Check that mysql.slave_relay_log_info does not have any entry]
45 include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
46 Matching lines are:
47 replication_applier
48 Occurrences of 'replication_applier' in the input file: 1
49 Matching lines are:
50 localhost
51 Occurrences of 'localhost' in the input file: 1
52 STOP SLAVE FOR CHANNEL "";
53 Warnings:
54 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
55 Note 3084 Replication thread(s) for channel '' are already stopped.
56 #
57 # TC.E.F1: privilege_checks_username has more than 32 length.
58 #
59 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='repli_priv_checks_user_more_than_32'@'localhost' FOR CHANNEL "";
60 ERROR HY000: String 'repli_priv_checks_user_more_than_32' is too long for user name (should be no longer than 32)
61 include/rpl_stop_server.inc [server_number=2]
62 include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start --debug=d,simulate_priv_check_username_above_limit]
63 SELECT * FROM performance_schema.replication_applier_configuration;
64 CHANNEL_NAME DESIRED_DELAY PRIVILEGE_CHECKS_USER REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
65 0 <INVALID> NO STREAM OFF NULL
66 include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
67 # Removing debug point 'simulate_priv_check_username_above_limit' from @@GLOBAL.debug
68 START SLAVE FOR CHANNEL "";
69 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
70 RESET SLAVE FOR CHANNEL "";
71 Warnings:
72 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
73 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
74 #
75 # TC.E.F2: privilege_checks_hostname has more than 255 length.
76 #
77 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than255' FOR CHANNEL "" ;
78 ERROR HY000: String 'replication_privilege_checks_hostname_more_than_255_replication_privil' is too long for host name (should be no longer than 255)
79 include/rpl_stop_server.inc [server_number=2]
80 include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start --debug=d,simulate_priv_check_hostname_above_limit]
81 SELECT * FROM performance_schema.replication_applier_configuration;
82 CHANNEL_NAME DESIRED_DELAY PRIVILEGE_CHECKS_USER REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
83 0 <INVALID> NO STREAM OFF NULL
84 include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
85 # Removing debug point 'simulate_priv_check_hostname_above_limit' from @@GLOBAL.debug
86 START SLAVE FOR CHANNEL "";
87 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
88 RESET SLAVE FOR CHANNEL "";
89 Warnings:
90 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
91 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
92 #
93 # TC.E.F3: privilege_checks_hostname has @.
94 #
95 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'l@calhost' FOR CHANNEL "" ;
96 ERROR HY000: Malformed hostname (illegal symbol: '@')
97 include/rpl_stop_server.inc [server_number=2]
98 include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start]
99 Matching lines are:
100 replication_applier
101 Occurrences of 'replication_applier' in the input file: 1
102 Matching lines are:
103 l@calhost
104 Occurrences of 'l@calhost' in the input file: 1
105 SELECT * FROM performance_schema.replication_applier_configuration;
106 CHANNEL_NAME DESIRED_DELAY PRIVILEGE_CHECKS_USER REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
107 0 <INVALID> NO STREAM OFF NULL
108 include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
109 START SLAVE FOR CHANNEL "";
110 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
111 RESET SLAVE FOR CHANNEL "";
112 Warnings:
113 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
114 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
115 #
116 # TC.E.F5. privilege_checks_username is anonymous.
117 #
118 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER=''@'localhost' FOR CHANNEL "" ;
119 ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel '' was set to ``@`localhost`, but anonymous users are disallowed for PRIVILEGE_CHECKS_USER.
120 include/rpl_stop_server.inc [server_number=2]
121 include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start]
122 SELECT * FROM performance_schema.replication_applier_configuration;
123 CHANNEL_NAME DESIRED_DELAY PRIVILEGE_CHECKS_USER REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
124 0 <INVALID> NO STREAM OFF NULL
125 include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
126 START SLAVE FOR CHANNEL "";
127 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
128 RESET SLAVE FOR CHANNEL "";
129 Warnings:
130 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
131 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
132 #
133 # TC.E.F6. privilege_checks_user is a non existent user.
134 #
135 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier_nonexist'@'localhost' FOR CHANNEL "" ;
136 ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel '' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user.
137 include/rpl_stop_server.inc [server_number=2]
138 include/rpl_start_server.inc [server_number=2 parameters: --skip_replica_start]
139 Matching lines are:
140 replication_applier_nonexist
141 Occurrences of 'replication_applier_nonexist' in the input file: 1
142 Matching lines are:
143 localhost
144 Occurrences of 'localhost' in the input file: 1
145 SELECT * FROM performance_schema.replication_applier_configuration;
146 CHANNEL_NAME DESIRED_DELAY PRIVILEGE_CHECKS_USER REQUIRE_ROW_FORMAT REQUIRE_TABLE_PRIMARY_KEY_CHECK ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE
147 0 <INVALID> NO STREAM OFF NULL
148 include/assert.inc [Check entry for default channel "" in performance_schema.replication_applier_configuration]
149 START SLAVE FOR CHANNEL "";
150 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
151 RESET SLAVE FOR CHANNEL "";
152 Warnings:
153 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
154 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost';
155 include/assert_grep.inc [Found 4 warning in the error log]
156 include/assert_grep.inc [Found 1 warning in the error log]
157 #
158 # Restart slave with TABLE repository to test with privilege_checks_user config.
159 #
160 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --debug=d,simulate_priv_check_user_nullptr_t]
161 include/assert.inc [Check that mysql.slave_relay_log_info has 1 entries for 1 channels]
162 include/assert.inc [Check that performance_schema.replication_applier_configuration has 1 entries for 1 channels]
163 include/assert.inc [Check that priv_chks_username for channel "" is correct]
164 include/assert.inc [Check that priv_chks_hostname for channel "" is correct]
165 #
166 # TC.P.T1: CHANGE MASTER sets the PRIVILEGE_CHECKS_USER correctly.
167 #
168 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11, PRIVILEGE_CHECKS_USER=NULL FOR CHANNEL "ch1";
169 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'localhost' FOR CHANNEL "ch2" ;
170 FLUSH RELAY LOGS FOR CHANNEL "ch1";
171 FLUSH RELAY LOGS FOR CHANNEL "ch2";
172 include/assert.inc [Check that mysql.slave_relay_log_info has 3 entries for 3 channels]
173 include/assert.inc [Check that performance_schema.replication_applier_configuration has 3 entries for 3 channels]
174 include/assert.inc [Check that priv_chks_username for channel "ch1" is correct]
175 include/assert.inc [Check that priv_chks_hostname for channel "ch1" is correct]
176 include/assert.inc [Check that priv_chks_username for channel "ch2" is correct]
177 include/assert.inc [Check that priv_chks_hostname for channel "ch2" is correct]
178 #
179 # TC.P.T2: PRIVILEGE_CHECKS_USER persists after restarting the server.
180 #
181 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE]
182 include/assert.inc [Check that mysql.slave_relay_log_info has 3 entries for 3 channels]
183 include/assert.inc [Check that performance_schema.replication_applier_configuration has 3 entries for 3 channels]
184 include/assert.inc [Check that priv_chks_username for channel "ch1" is correct]
185 include/assert.inc [Check that priv_chks_hostname for channel "ch1" is correct]
186 include/assert.inc [Check that priv_chks_username for channel "ch2" is correct]
187 include/assert.inc [Check that priv_chks_hostname for channel "ch2" is correct]
188 #
189 # TC.P.T3: RESET SLAVE should keep value of PRIVILEGE_CHECKS_USER.
190 #
191 RESET SLAVE FOR CHANNEL "";
192 Warnings:
193 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
194 include/assert.inc [Check that mysql.slave_relay_log_info has 2 entries for 2 channels]
195 include/assert.inc [Check that performance_schema.replication_applier_configuration has 3 entries for 3 channels]
196 include/assert.inc [Check that priv_chks_user for channel "" is correct]
197 include/assert.inc [Check that priv_chks_username for channel "ch1" is correct]
198 include/assert.inc [Check that priv_chks_hostname for channel "ch1" is correct]
199 include/assert.inc [Check that priv_chks_username for channel "ch2" is correct]
200 include/assert.inc [Check that priv_chks_hostname for channel "ch2" is correct]
201 RESET SLAVE ALL FOR CHANNEL "";
202 Warnings:
203 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
204 RESET SLAVE ALL FOR CHANNEL "ch2";
205 Warnings:
206 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
207 STOP SLAVE FOR CHANNEL "ch1";
208 Warnings:
209 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
210 Note 3084 Replication thread(s) for channel 'ch1' are already stopped.
211 #
212 # TC.E.T1: privilege_checks_username has more than 32 length.
213 #
214 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10, PRIVILEGE_CHECKS_USER='repli_priv_checks_user_more_than_32'@'localhost' FOR CHANNEL "ch1";
215 ERROR HY000: String 'repli_priv_checks_user_more_than_32' is too long for user name (should be no longer than 32)
216 BEGIN;
217 UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="repl_priv_chcks_usr_more_than_32", Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
218 COMMIT;
219 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start --debug=d,simulate_priv_check_username_above_limit,simulate_priv_check_user_nullptr_t]
220 include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
221 # Removing debug point 'simulate_priv_check_username_above_limit' from @@GLOBAL.debug
222 START SLAVE FOR CHANNEL "ch1";
223 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
224 RESET SLAVE FOR CHANNEL "ch1";
225 Warnings:
226 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
227 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
228 #
229 # TC.E.T2: privilege_checks_hostname has more than 255 length.
230 #
231 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than_255_replication_privilege_checks_hostname_more_than255' FOR CHANNEL "ch1" ;
232 ERROR HY000: String 'replication_privilege_checks_hostname_more_than_255_replication_privil' is too long for host name (should be no longer than 255)
233 BEGIN;
234 UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="replication_applier", Privilege_checks_hostname="replication_applier_hostname_more_than_255" WHERE Channel_name="ch1";
235 COMMIT;
236 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start --debug=d,simulate_priv_check_hostname_above_limit,simulate_priv_check_user_nullptr_t]
237 include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
238 # Removing debug point 'simulate_priv_check_hostname_above_limit' from @@GLOBAL.debug
239 START SLAVE FOR CHANNEL "ch1";
240 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
241 RESET SLAVE FOR CHANNEL "ch1";
242 Warnings:
243 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
244 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
245 #
246 # TC.E.T3: privilege_checks_hostname has @.
247 #
248 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier'@'l@calhost' FOR CHANNEL "ch1" ;
249 ERROR HY000: Malformed hostname (illegal symbol: '@')
250 BEGIN;
251 UPDATE mysql.slave_relay_log_info SET Privilege_checks_username='replication_applier', Privilege_checks_hostname='l@calhost' WHERE Channel_name="ch1";
252 COMMIT;
253 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
254 include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
255 START SLAVE FOR CHANNEL "ch1";
256 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
257 RESET SLAVE FOR CHANNEL "ch1";
258 Warnings:
259 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
260 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
261 #
262 # TC.E.T4. privilege_checks_username is NULL and
263 #
264 BEGIN;
265 UPDATE mysql.slave_relay_log_info SET Privilege_checks_username=NULL, Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
266 COMMIT;
267 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
268 include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
269 START SLAVE FOR CHANNEL "ch1";
270 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
271 RESET SLAVE FOR CHANNEL "ch1";
272 Warnings:
273 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
274 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
275 #
276 # TC.E.T5. privilege_checks_username is anonymous.
277 #
278 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER=''@'localhost' FOR CHANNEL "ch1" ;
279 ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel 'ch1' was set to ``@`localhost`, but anonymous users are disallowed for PRIVILEGE_CHECKS_USER.
280 BEGIN;
281 UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="", Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
282 COMMIT;
283 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
284 include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
285 START SLAVE FOR CHANNEL "ch1";
286 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
287 RESET SLAVE FOR CHANNEL "ch1";
288 Warnings:
289 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
290 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=11 FOR CHANNEL "ch1";
291 #
292 # TC.E.T6. privilege_checks_user is a non existent user.
293 #
294 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=12, PRIVILEGE_CHECKS_USER='replication_applier_nonexist'@'localhost' FOR CHANNEL "ch1" ;
295 ERROR HY000: PRIVILEGE_CHECKS_USER for replication channel 'ch1' was set to `replication_applier_nonexist`@`localhost`, but this is not an existing user.
296 BEGIN;
297 UPDATE mysql.slave_relay_log_info SET Privilege_checks_username="replication_applier_nonexist", Privilege_checks_hostname="localhost" WHERE Channel_name="ch1";
298 COMMIT;
299 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --skip_replica_start]
300 include/assert.inc [Check entry for channel "ch1" in performance_schema.replication_applier_configuration]
301 START SLAVE FOR CHANNEL "ch1";
302 ERROR HY000: Replica failed to initialize applier metadata structure from the repository
303 RESET SLAVE FOR CHANNEL "ch1";
304 Warnings:
305 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
306 CHANGE REPLICATION SOURCE TO SOURCE_HOST="127.0.0.1", SOURCE_PORT=11 FOR CHANNEL "ch1";
307 include/assert_grep.inc [Found 5 warning in the error log]
308 include/assert_grep.inc [Found 1 warning in the error log]
309 DROP USER 'replication_applier'@'localhost';
310 include/stop_slave.inc
311 Warnings:
312 Note 3084 Replication thread(s) for channel 'ch1' are already stopped.
313 RESET REPLICA ALL;
314 SET @@global.relay_log_info_repository=FILE;
315 Warnings:
316 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
317 CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST="127.0.0.1", SOURCE_PORT=MASTER_MYPORT;;
318 Warnings:
319 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
320 Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
321 include/start_slave.inc
322 include/rpl_end.inc