By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

Replication Binlog Corruption - REPOST

P: n/a
Hello all,

Sorry to post this again, but I go not response and was really hoping
someone can help me as this is a mission-critical problem. I have 3
slave MySQL servers (4.0.13) replicating from a master machine
(4.0.13). The master machine is running only MySQL while the slave
machines are an Apache + Tomcat + MySQL web service. All slave
machines are precisely identical. I'm running into a situation where
(seemly at random) after a month or two of consistently flawless
performance, just ONE of the slave machines will report the following
error in the .err log:

030807 9:22:35 Error in Log_event::read_log_event():
'Event too big', data_len=1869425764,event_type=114
030807 9:22:35 Error reading relay log event: slave SQL thread
aborted because of I/O error
030807 9:22:35 Could not parse log event entry, check the master
for binlog corruption This may also be a network problem,
or just a bug in the master or slave code.
030807 9:22:35 Error running query, slave SQL thread aborted. Fix
the problem, and restart the slave SQL thread with "SLAVE
START".
We stopped at log 'oakpub-bin.002' position 25239274

However the other two slaves are up-to-date on replication with no error
messages and mysqlbinlog output shows no obvious malformed statements.
This problem is not specific to just one machine but has happened on
all 3 slave nodes in the past few months, all at different times. Trying
to restart the slave process results in the same error. Manually
performing the statement in the binlog works fine and then the slave
can be played forward to the current master logfile location with no
problems. I've also tried deleting the entire database on the slave
and recreating everything with LOAD DATA FROM MASTER and that goes
smoothly as well. Any thoughts?

Thanks,
Jason

--
Jason McCormick
Network & Systems Administrator - Lexi-Comp, Inc.
ja*************@lexi.com - 330.656.0239
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.