weird error messages on slave
Hi,
i've set up a replication system (working ok), but i'm getting weird error messages in the slave log.
The messages look like these :
<cut>
050513 0:33:59 [ERROR] Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
050513 0:33:59 [ERROR] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master-bin.001' position nnnnnnnn
050513 0:33:59 [Note] Slave: connected to master 'replicator@master:3306',replication resumed in log master-bin.001' at position nnnnnnnn
<cut>
This error messages happen almost every hour.
I tried to figure out what happened that closed the connection, and looked at the binlog file, and nnnnnnnn was the end of the file.
Why do i get error messages when slave is up to date.
The problem is that my relaylog doesnt empty itself. As most request are big ones, the logs increase very rapidly and rise over GBs after one week.
QUESTION :
1. Doesn't the relay log delete succeeding requests when they are done ?
2. Do i have to unset a connection timeout in order not to get those annoying 'error' messages ?
Thanks for help.
Thierry Delbushaye
DBiT s.a.
Subject
Views
Written By
Posted
weird error messages on slave
3008
May 13, 2005 07:07AM
1928
June 07, 2005 12:38PM
1986
June 08, 2005 08:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.