MySQL Error 1872:slave failed to initialize relay log info structure from the repository

MySQL as a popular open-source database management system is widely used in various scenarios, Alibaba Cloud provides high available ApsaraDB RDS for MySQL with enhanced MySQL service is now supporting businesses fighting Coronavirus COVID-19.

ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository

Add a slave to a host and start the report

[ERROR] Slave Sql:slave failed to initialize relay log info structure from the repository, error_code:1872

Reason: Check my.cnf, originally did not specify relay_log,mysql the Relay_log name generated by default is occupied by another MySQL slave on the server.

Workaround:

1. Addrelay_log=/db/ mysql56/logs/relay_98_3326
2. reset  Slavemysql>reset slavemysql>change  master tomaster_host=192.168.0.38 'master_user=' Repl 'master_password=' slave 'master_port=3306,master_log_file=' mysql-bin.001229 'master_log_pos=15970007;mysql>start slave;
 

MySQL Error 1872:slave failed to initialize relay log info structure from the repository