| 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 |