ERROR: Could not read entry at offset 946675767: Error in log format or read error

problem description¶

Check the content in the binlog and find that it cannot be viewed normally:

mysqlbinlog --no-defaults -v master-bin.000543> baidd_543.log

Error¶

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.

Two solutions¶

Add -f parameter to force open

mysqlbinlog --no-defaults -v -f master-bin.000543 > baidd_543.log

Although there is an error:

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

But you can see that the baidd_543.log file contains the complete content