[freetds] FreeTDS hang

James K. Lowden jklowden at schemamania.org
Sat May 22 16:25:17 EDT 2004

On Sat, 22 May 2004, Frediano Ziglio <freddyz77 at tin.it> wrote:
> Il sab, 2004-05-22 alle 12:36, Hany Heggy ha scritto:
> > 
> >   The program is multi threaded and each thread connect to certain
> >   MSSQL server, it works fine until one of the sever is unreachable (
> >   i cannot ping it from Linux command line) at this point i get an
> >   error from FreeTDS :
> >    server   connect time out
> > 
> >   at this point the program freeze and all threads freeze totally
> Do you get error or it just hangs inside ODBC?
> I would try to enable logging and remove network wire just to test...

If you do this, remember that every connection initializes the log file

	dump file append = yes

is in your freetds.conf.  Another workaround is to set TDSDUMP=stderr.  

Nothing springs to mind, unfortunately.  I would run the application under
gdb and, when it hangs, find out where.  

I would like to know, though:  What advantage is to be found in a
multi-threaded design?  It seems to me that one process per simultaneous
connection would be much safer, and that Linux is rich in IPC choices.  


More information about the FreeTDS mailing list