List:General Discussion« Previous MessageNext Message »
From:Jørn Dahl-Stamnes Date:January 11 2010 3:26pm
Subject:Binary log problems
View as plain text  
I tried to look at the binary logs by using phpMyAdmin, but got an error:

SQL error:
SHOW BINLOG EVENTS LIMIT 0, 30;

MySQL said:
#1220 - Error when executing command SHOW BINLOG EVENTS: Wrong offset or I/O 
error.

From the error-file:

100111 16:15:40 [ERROR] Error in Log_event::read_log_event(): 'Found invalid 
event in binary log', data_len: 100, event_type: 2
100111 16:16:51 [ERROR] Error in Log_event::read_log_event(): 'Found invalid 
event in binary log', data_len: 100, event_type: 2
100111 16:17:08 [ERROR] Error in Log_event::read_log_event(): 'Found invalid 
event in binary log', data_len: 100, event_type: 2

What is causing this? How can I fix this?

I'm using version mySQL 5.1.42.

-- 
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
Thread
Binary log problemsJørn Dahl-Stamnes11 Jan