Re: FreeTDS & Sybase SQL Anywhere 11

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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds