Skip to Content.
Sympa Menu

freetds - Re: [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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] freetds is hanging while trying to connect to the offline host
  • Date: Fri, 18 Jun 2010 15:01:17 +0200

2010/6/17 Eugene Eugene <box.eugene AT gmail.com>:
> 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.

Strange, should return after the timeout? Could you post your
connection settings?
Which FreeTDS version are you using ??

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page