Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are

原创 2016年05月30日 10:16:39


mysql> SHOW SLAVE STATUS\G;
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
                  Master_Host: 10.10.1.207
                  Master_User: root
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000598
          Read_Master_Log_Pos: 693157545
               Relay_Log_File: -relay-bin.000908
                Relay_Log_Pos: 745679838
        Relay_Master_Log_File: mysql-bin.000594
             Slave_IO_Running: Yes
            Slave_SQL_Running: No
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 1594
                   Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 745679693
              Relay_Log_Space: 4988129267
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 1594
               Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
1 row in set (0.00 sec)



这个问题原因是,主数据库突然停止或问题终止,更改了mysql-bin.xxx日志,slave服务器找不到这个文件,需要找到同步的点和日志文件,然后chage master即可。

 CHANGE  MASTER  TO  MASTER_HOST='xxxx',MASTER_USER='root',MASTER_PASSWORD='xxxx',MASTER_LOG_FILE='mysql-bin.000594', MASTER_LOG_POS=745679693;



线上MYSQL同步报错故障处理总结

http://www.cnblogs.com/itcomputer/articles/5618907.html 前言 在发生故障切换后,经常遇到的问题就是同步报错,数据库很小的时候,d...
  • Steven_liwen
  • Steven_liwen
  • 2016年12月01日 17:05
  • 2577

mmm 主从复制机制排错过程

一. 主机器发出一个sql,导致所有的从机同步出错的问题解决流程a.)进入从机的mysql控制台b.) 查看复制进程的信息mysql> show slave status\Gc.) 关注以下3个key...
  • remote_roamer
  • remote_roamer
  • 2016年07月19日 14:49
  • 1814

mysql 清除relay-log文件方法详解

mysql 清除relay-log文件方法详解 今天在本机的mysql数据目录下发现了许多类似hostname-relay-bin.0000*的文件,该文件一般是在mysql slave实例上存...
  • u010098331
  • u010098331
  • 2016年02月24日 13:00
  • 6587

Last_Error: Relay log read failure: Could not parse relay log event entry.

Last_Error: Relay log read failure: Could not parse relay log event entry. 错误处理详解。
  • shaochenshuo
  • shaochenshuo
  • 2017年03月06日 14:04
  • 457

Error reading relay log event: slave SQL thread was killed

1.版本 1)操作系统  cat /etc/issue Red Hat Enterprise Linux Server release 5.5 (Tikanga) Kernel \r on an ...
  • shaochenshuo
  • shaochenshuo
  • 2015年12月15日 13:59
  • 2889

Eclipse:Some sites could not be found. See the error log for more detail.解决办法

今天遇到了一个奇葩的问题,我把我的sdk tools的版本升级到23后,我在eclipse中尝试升级ADT,发现了这么一个问题,下面分析下原因: 当我在eclipse中选择Help-->Check f...
  • hyr83960944
  • hyr83960944
  • 2014年06月30日 15:29
  • 8196

relay_log 相关参数

mysql> show variables like '%relay%'; +---------------------------+----------------+ |...
  • lyj1101066558
  • lyj1101066558
  • 2016年03月18日 10:59
  • 1423

mysql 清除relay-log文件方法详解

mysql 清除relay-log文件方法详解 今天在本机的mysql数据目录下发现了许多类似hostname-relay-bin.0000*的文件,该文件一般是在mysql slave实例上存...
  • u010098331
  • u010098331
  • 2016年02月24日 13:00
  • 6587

关于Relay Log无法自动删除的问题

本文介绍了一次运维实践中relay-log长期无法自动删除的原因和解决过程 背景: 今天在运维一个mysql实例时,发现其数据目录下的relay-log 长期没有删除,已经堆积了几十个relay...
  • YABIGNSHI
  • YABIGNSHI
  • 2016年08月24日 09:17
  • 846

Qt中Error:Could not decode "xxx.cpp" with "System"-encoding.Editing not possible.的解决方案

在打开Qt项目中的文件的时候,有时候会遇到Error:Could not decode "xxx.cpp" with"System"-encoding.Editing not possible.这种错...
  • mnonm_mnonm_mnonm
  • mnonm_mnonm_mnonm
  • 2013年01月08日 13:31
  • 8510
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are
举报原因:
原因补充:

(最多只允许输入30个字)