ERROR: Could not read entry at offset 946675767: Error in log format or read error
created at 10-01-2021
views: 2
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
created at 10-01-2021
Please log in to leave a comment.