阿里云rds备份集本地恢复启动错误信息解决

 

阿里云rds上部署有主从环境下的主节点上的备份集下载到本地恢复，启动的时候有报错信息(不影响使用)

2025-11-14 15:09:53 1043 [ERROR] Error creating master info: Error removing old repository.
2025-11-14 15:09:53 1043 [ERROR] Failed to create or recover replication info repository.
2025-11-14 15:09:53 1043 [Note] Check error log for additional messages. You will not be able to start replication until the issue is
 resolved and the server restarted.

 

解决办法:

删除如下表重新创建

/opt/mysql56/bin/mysql -h 127.0.0.1 -uroot
use mysql
drop table slave_master_info;
drop table slave_relay_log_info;
drop table slave_worker_info;
drop table innodb_index_stats;
drop table innodb_table_stats;
source /opt/mysql56/share/mysql_system_tables.sql;

然后重启动

/opt/mysql56/bin/mysqladmin -h 127.0.0.1 -uroot shutdown
/opt/mysql56/bin/mysqld_safe --defaults-file=/opt/mysql56/conf/my.cnf --user=mysql &

 

查看日志,发现继续有错误信息

2025-11-14 15:22:13 5814 [ERROR] Slave SQL: Slave failed to initialize relay log info structure from the repository, Error_code: 1872
2025-11-14 15:22:13 5814 [ERROR] Failed to create slave threads
2025-11-14 15:22:13 5814 [Note] Check error log for additional messages. You will not be able to start replication until the issue is resolved and the server restarted.
 

解决办法:

/opt/mysql56/bin/mysql -h 127.0.0.1 -uroot
mysql> reset slave all;

再次重启
/opt/mysql56/bin/mysqladmin -h 127.0.0.1 -uroot shutdown
/opt/mysql56/bin/mysqld_safe --defaults-file=/opt/mysql56/conf/my.cnf --user=mysql &

发现没有错误信息了