dongnan
总版主
总版主
  • 粉丝52
  • 发帖数2165
  • 铜币13236枚
  • 威望5838点
  • 银元150个
  • 社区居民
  • 最爱沙发
  • 忠实会员
  • 原创写手
阅读:1303回复:0

MySQL read_log_event(): 'Found invalid event in binary log'

楼主#
更多 发布于:2016-07-12 11:35
错误描述
mysqlbinlog  mysql-bin.000063  | more
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 71, event_type: 35
ERROR: Could not read entry at offset 120: Error in log format or read error.
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#160524  0:38:27 server id 46530485  end_log_pos 120 CRC32 0xc0b795db     Start: binlog v 4, server v 5.6.16-log created 160524  0:38:27
BINLOG '
g6JDVw+1/8UCdAAAAHgAAAAAAAQANS42LjE2LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAduV
t8A=
'/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

错误原因

mysqlbinlog 命令版本较低,但是binlog 文件版本较高,导致mysqlbinlog 无法读取 binlog

解决方法
使用高版本 Mysqlbinlog 命令读取 binlog

#
游客

返回顶部