Getting connection abort error with replication user in Master Salve replication
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
Subject
Views
Written By
Posted
Getting connection abort error with replication user in Master Salve replication
6604
February 14, 2013 01:30AM
2648
February 22, 2013 01:34AM
2661
February 22, 2013 10:13PM
1890
March 11, 2013 06:06AM
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.