Skip to Content.
Sympa Menu

freetds - [freetds] freetds is hanging while trying to connect to the offline host

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Eugene Eugene <box.eugene AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] freetds is hanging while trying to connect to the offline host
  • Date: Thu, 17 Jun 2010 14:29:35 +1000

Hi,
I have got many SQL Server hosts in freetds.conf and usually database
connection check works fine.
But sometimes all SQL Server databases in freetds.conf are giving
timeout messages. It seems that it is because a server is down
resulting in freetds is hanging while trying to connect to the offline
host. Even though our script cycles through all the database servers,
it relies on freetds which cannot go past the offline host. The
resolution is to remove the host entries in freetds.conf . Setting
different timeouts within freetds hasn’t helped.
Any ideas how to fix this hanging problem?

Thank you and best regards, Eugene.




Archive powered by MHonArc 2.6.24.

Top of Page