[freetds] FreeTDS & Sybase SQL Anywhere 11
Michal Seliga
michal.seliga at visicom.sk
Mon Dec 21 04:28:13 EST 2009
On 19. 12. 2009 4:56, James K. Lowden wrote:
> Michal Seliga wrote:
>>
>> - always when i close database connection server reports:
>> Connection terminated abnormally
>> Disconnected TCPIP client's AppInfo: HOST=visibuntu;PID=1906
>> however freetds & odbc don't seem to detect any problem (according to
>> logs)
>
> Which API are you using? Does it happen with bsqldb/bsqlodbc/tsql/sqsh?
yes, with tsql it happens too
> A TDSDUMP log of the session would help. If all applications produce the
> same error, a tcpdump(8) log might be helpful, too, but don't post that
> until we know we need it.
tdsdump is attached (freetds.log.gz)
if it will come to tcpdump please write me what you want me to set, i saw it
has really lot of switches....
>
>> - sometimes happens that after a while connection is lost (all execs
>> fail with message about connection terminated).
>
> I would file this under "fix what you know is broken". It might be
> related to the servers' complaint.
i agree
>
>> - when i made simple program which in loop opened connection, made exec
>> of simple select and closed connection, then after several tries it
>> hangs while processing SQLFreeHandle. these logs i can send if needed
>
> If you could make the test as simple as possible, post the code here.
> Perhaps it has something to do with your particular
> environment/OS/network.
today it doesn't happen, i let it run for several minutes (before it hanged
after ~15-20 seconds, sometimes even sooner). so i will call it bad luck and
hope it won't happen anymore. if it will reappear i will write here.
>
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: freetds.log.gz
Type: application/gzip
Size: 1929 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20091221/f39e4dd1/attachment.bin
More information about the FreeTDS
mailing list