Hi all,
Last week I got this message below..
040829 19:38:43 Slave SQL thread: I/O error reading event(errno: -1
cur_log->e
rror: 11)/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306
040829 19:38:43 Error reading relay log event: Aborting slave SQL thread
becaus
e of partial event read
040829 19:38:43 Slave: Could not parse relay log event entry. The possible
reas
ons are: the master's binary log is corrupted (you can check this by running
'my
sqlbinlog' on the binary log), the slave's relay log is corrupted (you can
check
this by running 'mysqlbinlog' on the relay log), a network problem, or a
bug in
the master's or slave's MySQL code. If you want to check the master's
binary lo
g or slave's relay log, you will be able to know their names by issuing
'SHOW SL
AVE STATUS' on this slave. Error_code: 0
040829 19:38:43 Error running query, slave SQL thread aborted. Fix the
problem,
and restart the slave SQL thread with "SLAVE START". We stopped at log
'www-bin
.005' position 633703721
I have 2 mysql daemons running in slave mode and I got his message on only
one of them. So I thought that the corruption was based on the relay.. So
What I did was to "CHANGE MASTER TO" an after possition that the problem
occur. So I tried some values but nothing changed. So As a solution I shut
down the master (I was not willing to do this but I had to) and take a
snapshot and rebuild the master again.. Ans started the slave from the new
master binary log created.. So this solved my problem but Actually What
should I do in a situation like this if it happens again?
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
