一.今天处理个报警,需要回放下binlog
结果如下:
mysqlbinlog mysql-bin.010619
/*!40019 SET @@session.max_insert_delayed_threads=0*/;ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 94, event_type: 15
Could not read entry at offset 4:Error in log format or read error
咋看 binlog 格式不对....
后来想了想,可能mysqlbinlog与 binlog版本不对应。
二.处理
[mysql@longxibendi var]$ ../bin/mysqlbinlog -V
../bin/mysqlbinlog Ver 3.2 for redhat-linux-gnu at x86_64
[mysql@longxibendi var]$ mysqlbinlog -V
mysqlbinlog Ver 3.0 for redhat-linux-gnu at x86_64
果然默认安装的mysqlbinlog 版本较低。使用mysql实例下的,问题解决。