MySQL Forums
Forum List  »  Replication

Getting connection abort error with replication user in Master Salve replication
Posted by: sandeep thakur
Date: February 14, 2013 01:30AM

Hi,

I've setup Master-Slave replication on two windows 2008 servers. I've setup the log-warning variable to 2. In the error log of master there are a lot of messages of aborted connections of Slave.
The error log of slave also contains the error messages while connecting to Master.
The issue is only with the replication user only. Other users are not facing any connect abort error.
Can someone please suggest me what is the issue here & how I can troubleshoot this issue.
My config for soe variables are as follow:-
++
max_allowed_packet = 50M
net-read_timeout = 90
net_write_timeout = 180
++


Master error log:-
++++
130214 4:08:10 [Warning] Aborted connection 10266 to db: 'unconnected' user: '<replication-user>' host: '<hostname>' (Got an error writing communication packets)
130214 4:13:10 [Warning] Aborted connection 10271 to db: 'unconnected' user: '<replication-user>' host: '<hostname>' (Got an error writing communication packets)
130214 4:18:11 [Warning] Aborted connection 10276 to db: 'unconnected' user: '<replication-user>' host: '<hostname>' (Got an error writing communication packets)
130214 4:46:42 [Warning] Aborted connection 10281 to db: 'unconnected' user: '<replication-user>' host: '<hostname>' (Got an error writing communication packets)
++++

Slave error log:-
+++
130214 4:22:39 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
130214 4:22:39 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master_binlog.000094' at position 65753305
130214 4:51:10 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
130214 4:51:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'master_binlog.000094' at position 65766674
+++

Please post your reply ASAP.

Thanks,
Sandeep

Options: ReplyQuote


Subject
Views
Written By
Posted
Getting connection abort error with replication user in Master Salve replication
6604
February 14, 2013 01:30AM


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.