MySQL read_log_event (): 'found invalid event in binary Log'

MySQL read_log_event (): 'found invalid event in binary Log'

MySQL is known for its ease of use. It can install N different versions on the same server to facilitate testing and migration. In addition, mysql is integrated in most Linux systems and is installed by default. Therefore, problems with multiple versions may cause some inexplicable errors. Recently, when extracting binlog, we encountered a read_log_event, Found invalid event in binary log. It was found that the problem was caused by the mysqlbinlog version. For your reference.

1. fault description
[Root @ HKBO bak] # mysqlbinlog -- start-datetime = "00:30:00" mysql-bin.000399bk | more
ERROR: Error in Log_event: read_log_event (): 'found invalid event in binary log', data_len: 376, event_type: 19
/*! 40019 SET @ session. max_insert_delayed_threads = 0 */;
/*! 50003 SET @ OLD_COMPLETION_TYPE = @ COMPLETION_TYPE, COMPLETION_TYPE = 0 */;
DELIMITER /*! */;
# At 4
#141213 21:05:01 server id 11 end_log_pos 120 Start: binlog v 4, server v 5.6.12-log created 141213 21:05:01
# Warning: this binlog is either in use or was not closed properly.
DELIMITER;
# End of log file
ROLLBACK/* added by mysqlbinlog */;
/*! 50003 SET COMPLETION_TYPE = @ OLD_COMPLETION_TYPE */;

2. Fault Analysis and Solution
# View the current mysqlbinlog File
[Root @ HKBO bak] # which mysqlbinlog
/Usr/bin/mysqlbinlog

# Check the version of mysqlbinlog. The value is 3.2.
[Root @ HKBO bak] # mysqlbinlog -- version
Mysqlbinlog Ver 3.2 for RedHat-linux-gnu at x86_64
# Author: Leshami
# Blog:

Install MySQL in Ubuntu 14.04

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL

Build a MySQL Master/Slave server in Ubuntu 14.04

Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS

Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04

MySQL-5.5.38 universal binary Installation

-------------------------------------- Split line --------------------------------------

This article permanently updates the link address: