美文网首页
[ERROR] Slave I/O: Error_code:

[ERROR] Slave I/O: Error_code:

作者: jojo1313 | 来源:发表于2019-04-09 15:34 被阅读0次

    /var/log/mysql.log错误日志:
    [ERROR] Slave I/O: error connecting to master 'syc@1.1.1.1:3306' - retry-time: 300 retries: 999, Error_code: 2013

    show slave status:
    Master_Log_File: mysql-bin.000010
    Read_Master_Log_Pos: 739386385
    Relay_Log_File: mysqld-relay-bin.000001
    Relay_Log_Pos: 4
    Relay_Master_Log_File: mysql-bin.000010
    Slave_IO_Running: No
    Slave_SQL_Running: Yes

    解决方法:
    stop slave;
    CHANGE MASTER TO Relay_Log_Pos=588;
    start slave;
    show slave status \G
    跳过出问题的点,修复此问题.

    相关文章

      网友评论

          本文标题:[ERROR] Slave I/O: Error_code:

          本文链接:https://www.haomeiwen.com/subject/hpzbiqtx.html