標籤：Error in Log_event Found invalid even
一、問題描述
mysql v 5.0.91
[[email protected] bin]# ./mysqlbinlog /tmp/mysql-bin.000015
/
!40019 SET @@session.max_insert_delayed_threads=0/;
/
!50003 SET @[email protected]@COMPLETION_TYPE,COMPLETION_TYPE=0/;
DELIMITER /
!/;
#at 4
#180227 10:31:55 server id 1 end_log_pos 98 Start: binlog v 4, server v 5.0.91-log created 180227 10:31:55
ERROR: Error in Log_event::read_log_event(): ‘Found invalid event in binary log‘, data_len: 69, event_type: 2
Could not read entry at offset 98:Error in log format or read error
DELIMITER ;
#End of log file
ROLLBACK /
added by mysqlbinlog /;
/
!50003 SET [email protected]_COMPLETION_TYPE/;
二、解決方案
去掉預設字元集
#vim /etc/my.cnf
[client]
#default-character-set = utf8
#character-set-server = utf8
#password = your_password
port = 3306
socket = /var/mysql/mysql.sock
……
[mysqld]
datadir=/var/lib/mysql
#default-character-set = utf8
#character-set-server = utf8
……
[mysql]
no-auto-rehash
#default-character-set = utf8
MYSQL: mysqlbinlog讀取二進位檔案報錯read_log_event()
