MySQL复制报错(Slave failed to initialize relay log info structure from the repository)
机器重启以后,主从出现了问题,具体报错信息:
Slave failed to initialize relay log info structure from the repository
解决方案:
mysql> start slave; ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> start slave IO_THREAD; Query OK, 0 rows affected (0.07 sec) mysql> stop slave IO_THREAD; Query OK, 0 rows affected (0.01 sec) mysql> reset slave; Query OK, 0 rows affected (0.10 sec) mysql> start slave; Query OK, 0 rows affected (0.20 sec) mysql> show slave status\G
参考:https://bugs.mysql.com/bug.php?id=83713
热衷于学习讨论MySQL和SQL Server,NoSQL等数据库技术,欢迎加入SQL优化群:659336691