Intermittent "ERROR 2005", how to prevent, recover?
Posted by:
Ray Kiddy
Date: October 05, 2011 09:35AM
I have a perl script that processes our application logs and shoves metrics into a database (Server version: 5.0.88-log Source distribution).
Some of the time, the script runs fine. But once a week or so, it gets:
ERROR 2005 (HY000): Unknown MySQL server host 'm.d.com' (1)
ERROR 2005 (HY000): Unknown MySQL server host 'm.d.com' (1)
ERROR 2005 (HY000): Unknown MySQL server host 'm.d.com' (1)
ERROR 2005 (HY000): Unknown MySQL server host 'm.d.com' (1)
When I see the error (it runs from a cron job), I can run the script manually and it runs fine. I am sure there are things I can do, parameters in the database config that need to be changed. But does it make sense that there is an intermittent problem with the database's resources and the server response is just to cover its ears and yell "Nah, nah, nah, I can't hear you!"?
Should there not be some more sensible response from the database? Is there anything in particular I should look for here?
Subject
Written By
Posted
Intermittent "ERROR 2005", how to prevent, recover?
October 05, 2011 09:35AM
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.