Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Every so often requests to a Linux server (say, where the web app (Django) pulls in data from a SQL Server database via FreeTDS will hang.

Requests on other servers pointing to the database still work, as do requests on that use local MySQL databases. Only the server plus FreeTDS appear to be affected.

Restarting httpd makes the database connections work correctly again.

What could cause this problem?

Using: Centos 5.9 freetds 0.91 Apache httpd 2.2.3


Description = SQL Server 2005
Driver      = FreeTDS
;Database   = dbname        
Servername  = SERVERNAME
;TDS_Version    = 8.0


driver = /usr/lib64/
host =
port = 1433
tds version = 8.0
client charset = UTF-8
share|improve this question

Are you able to reproduce it programatically? I mean, have a testcase that you can run and get the same behavior to happen. Have you logged the SQL it's trying to run when this happens? Do you see any error message on logs? I'd attach strace to appropriate processes to check what's going on, tcpdump, etc.

share|improve this answer
Yeah, can't reproduce. It happens sporadically unfortunately, possibly based on either issues with the database that are resolved by all other servers with a restart of the DB server. I really can't tell. This might just be one of those unsolvable issues; was hoping someone else had run into the identical problem and figured it out. – Jordan Reiter Nov 15 '13 at 14:38

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.