Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Binlog errors

From: John Mancuso <John.Mancuso(at)americanhm.com>
Date: Wed Jun 27 2007 - 10:59:37 EDT


This seems to be a frequent occurrence:  

[root@mexxxx01 dblog]# mysqlbinlog mysql.000025 /*!40019 SET @@session.max_insert_delayed_threads=0*/; ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 94, event_type: 15 Could not read entry at offset 4:Error in log format or read error  

This is happening to all my binlogs (other servers as well) all the time. There is nothing wrong with the drive- I have other data on there that never gets corrupted.  

[root@mexxxx01 dblog]# ll
total 4676748

drwx------  2 mysql mysql      16384 May 29 11:50 lost+found

-rw-rw---- 1 mysql mysql 1073746319 Jun 24 00:43 mysql.000020
-rw-rw---- 1 mysql mysql 1073784914 Jun 24 03:50 mysql.000021
-rw-rw---- 1 mysql mysql 1073754672 Jun 24 06:57 mysql.000022
-rw-rw---- 1 mysql mysql 1073743683 Jun 26 10:24 mysql.000023
-rw-rw---- 1 mysql mysql 111863423 Jun 26 11:41 mysql.000024
-rw-rw---- 1 mysql mysql 377289867 Jun 27 10:53 mysql.000025
-rw-rw---- 1 mysql mysql 120 Jun 26 23:00 mysql.index
-rw-rw---- 1 mysql mysql 12418 Jun 26 23:47 mysql-slow.log
-rw-rw---- 1 mysql mysql 117 Jun 13 17:08 relay.000001
-rw-rw---- 1 mysql mysql 20 Jun 13 17:08 relay.index
-rw-r--r-- 1 root root 55 Jun 27 10:53 test.txt
What is going on here? John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475
Received on Wed Jun 27 11:00:51 2007

This archive was generated by hypermail 2.1.8 : Wed Jun 27 2007 - 11:10:04 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library