Bug #30504 [ERROR] Slave I/O thread: error reconnecting to master
Submitted: 20 Aug 2007 8:24 Modified: 20 Aug 2007 10:15
Reporter: Shaker Al-Zoubi Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.0 OS:Windows
Assigned to: CPU Architecture:Any

[20 Aug 2007 8:24] Shaker Al-Zoubi

there is a replication [master to master] between two nodes by MySQL 5.0 on windows operating system, i noticed from times to times the replication is not working and i got this error message:

[ERROR] Slave I/O thread: error reconnecting to master 'replication@172...:3306': Error: 'Can't connect to MySQL server on '172....' (10061)'  errno: 2003  retry-time: 60  retries: 86400

the solution for this issue to restart the service of MySQL on both node then it will work smoothly!!

so can you please advise how to solve this issue automatically without restart the service manually because it's for the online system and we need to control this case in better way.

Best Regards,
Ahmad Omar

How to repeat:
from time to time i notice this issue maybe for connection failure but i think when the connection up again between nodes, it should resum the replication between two nodes.

Suggested fix:
solve this issue automatically without restart the MySQL service manually
[20 Aug 2007 10:15] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

I see no information in the bug report about cause of the problem is MySQL itself. If you can provide such information feel free to do it and reopen the report.