[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 22.214.171.124 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