MySQL Forums
Forum List  »  Replication

slave losing connection
Posted by: D Rickard
Date: April 04, 2005 03:00PM

I've got a master and slave, both running 5.0.3 on Windows 2003. Replication is working fine, as updates made to the master get replicated to the slave in near real-time, but the slave consistently loses its connection. Every hour, the following three lines get written to the error log on the slave (the timestamps and binlog positions change, of course):

050404 13:02:47 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
050404 13:02:47 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'ServerNameHere-bin.000014' position 98
050404 13:02:47 [Note] Slave: connected to master 'slaveuserhere@ServerNameHere:3306',replication resumed in log 'ServerNameHere-bin.000014' at position 98

I've been Googling all over looking for an answer to why this is happening, but so far I've found nothing. My guess is it's something obvious that I've overlooked. Anyone have any ideas? I can post my config files if needed, but thought I'd ask for ideas first.

Thanks
D

Options: ReplyQuote


Subject
Views
Written By
Posted
slave losing connection
4118
April 04, 2005 03:00PM
2375
April 25, 2005 01:03PM


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.