client hangs intermittently
Has anyone else had problems with clients (Perl DBI in this case) hanging intermittently talking to a server? We have a process that pops mail and inserts it into a database. What happens is that at some point, the script will send a query and wait for the server's response, but the server shows the connection in a sleep state; it seems to never receive the query. As a result, the client will wait for the server's response forever.
As a quick workaround, we reduced the server's wait and interactive timeouts to 5 minutes, which breaks the client wait and cause it to reconnect and continue. We just upgraded to new hardware and OS, from Fedora running 4.0.20 to CentOS running 4.1.20. We have since upgraded the new server to 5.0.27, since we had no other ideas for what to try, but it's still happening a few times per hour.
Does anybody have any clue what may cause such behavior? The client side was not modified.
Subject
Written By
Posted
client hangs intermittently
February 20, 2007 07:13AM
February 21, 2007 12:52AM
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.