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;



相关文章推荐

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. 错误处理详解。

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 ...

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

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

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

mysql 清除relay-log文件方法详解 今天在本机的mysql数据目录下发现了许多类似hostname-relay-bin.0000*的文件,该文件一般是在mysql slave实例上存...

relay_log 相关参数

mysql> show variables like '%relay%'; +---------------------------+----------------+ |...

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.这种错...

ERROR: Could not extract package's data directory. Are you sure that your installed application is d

ERROR: Could not extract package's data directory. Are you sure that your installed application is...

错误:Write operations are not allowed in read-only mode (FlushMode.NEVER和could not initiallize proxy -

原因:            在没有使用Spring提供的Open Session In View情况下,因需要在service(or Dao)层里把session关闭,所以lazy loadi...

[main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database

[main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database ...

are 程序 led 及 relay

  • 2011年02月12日 21:09
  • 295KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are
举报原因:
原因补充:

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