ERROR: Error in Log_event::read_log_event(): 'Event too big', data_len:
1597257529, event_type: 49
ERROR: Could not read entry at offset 240378281 : Error in log format or
read error
On the master it's reporting this error. The data_len is 1.48 GB which
is an error. I know that this is not the case since I don't insert 1.4GB
of data in one sql statement. At this offset, the binary log is corrupt.
Also the size of the binary file is: (Note: size and position are
related)
240378300 Nov 12 00:04 ef112-bin.060
I read someplace that this is due to the binlog pointer becoming
displaced.
I don't believe it's a big problem for me since only 19 bytes of data is
missing and queries to this box are never <= 19 bytes. I assume its some
padding of data/or bad data. Unfortunately the only way that I can
recover from a possible missed event on the master-is to read every row
of the master and compare it with every row of the slave once the master
and slave are in-sync.
Anyone have better solution?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
