一 问题描述
查看binlog里内容,发现无法正常查看:
mysqlbinlog --no-defaults -v master-bin.000543 > baidd_543.log
报错:
ERROR: Error in Log_event::read_log_event(): 'Event truncated', data_len: 1413827653, event_type: 109
ERROR: Could not read entry at offset 946675767: Error in log format or read error.
二 解决办法
添加-f参数,强制打开
mysqlbinlog --no-defaults -v -f master-bin.000543 > baidd_543.log
虽然有报错:
mysqlbinlog: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.3.18/sql/log_event.cc:10883: Rows_log_event::Rows_log_event(const char*, uint, const Format_description_log_event*): Assertion `var_header_len >= 2' failed.
Aborted
但是能查看到baidd_543.log文件包含了完整内容