search

hugowan / maatkit

Automatically exported from code.google.com/p/maatkit
0 stars 0 forks source link

mk-slave-restart should handle a new kind of log corruption #125

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
081104 13:31:00 [ERROR] Error reading packet from server: binlog truncated
in the middle of event ( server_errno=1236)
081104 13:31:00 [ERROR] Got fatal error 1236: 'binlog truncated in the
middle of event' from master when reading data from binary log
081104 13:31:00 [Note] Slave I/O thread exiting, read up to log
'mysql-bin.000170', position 962617784

This type of error comes when the binlog is actually corrupt on the master.
 The best thing to do is probably to advance one byte at a time until it
can read successfully.

Original issue reported on code.google.com by baron.schwartz on 4 Nov 2008 at 7:43

GoogleCodeExporter commented 9 years ago 
Tricky: this kind of bug shows nothing in SHOW SLAVE STATUS except that the io 
thread
isn't running.  No error message.

Original comment by baron.schwartz on 4 Nov 2008 at 9:56

GoogleCodeExporter commented 9 years ago 
This can't be solved on MySQL 5.0 but may be solvable on 5.1.

Original comment by baron.schwartz on 23 Nov 2008 at 11:58

GoogleCodeExporter commented 9 years ago

Original comment by dan...@percona.com on 5 Jun 2009 at 3:03

GoogleCodeExporter commented 9 years ago 
I think we need to research this and see if it's possible to see this error in 
SHOW
SLAVE STATUS in 5.1.  I think it might be.  Still a low priority, because these 
kinds
of problems are best suited for human intervention.

Original comment by baron.schwartz on 1 Feb 2010 at 12:10

GoogleCodeExporter commented 9 years ago

Original comment by dan...@percona.com on 23 Mar 2010 at 7:04