freetds never finishes?

Brian Bruns camber at umcc.ais.org
Wed Feb 9 20:27:24 EST 2000



I agree, it appears everything is ok, ct_cmd_drop doesn't really do
anything.  So, it has to be happening elsewhere.  One thing I'm aware of
is ct_cancel occasionally fails against MS SQL (but not Sybase), so you
migh need to set syb_flush_finish...here is the revelent text from
dbd::perl

--------
syb_flush_finish

If $dbh->{syb_flush_finish} is set then $dbh->finish will drain
any results remaining for the current command by actually fetching them.
The default behaviour is to issue a ct_cancel(CS_CANCEL_ALL), but this
appears to cause connections to hang or to fail in certain cases (although
I've never witnessed this myself.)
--------

Also, I'd like to apologize for not being a bit more responsive...things
are hectic at work and I'm trying to buy a house as well, so my freetime
to work on freetds is very limited at the moment.

Brian 


On 9 Feb 2000, William P. McGonigle wrote:

> At least that's what it seems like to my non-expert eye.
> 
> This happens after a compount INSERT:
> 
> [lots just like this]
> 2000-02-08 15:56:05 inside ct_con_props() action = CS_GET property = 13
> 2000-02-08 15:56:05 processing result tokens.  marker is  fd
> 2000-02-08 15:56:05 processing result tokens.  marker is  aa
> 2000-02-08 15:56:05 inside ct_con_props() action = CS_GET property = 13
> 2000-02-08 15:56:05 processing result tokens.  marker is  ab
> 2000-02-08 15:56:05 inside ct_con_props() action = CS_GET property = 13
> 2000-02-08 15:56:05 processing result tokens.  marker is  fd
> 2000-02-08 15:56:05 processing result tokens.  marker is  aa
> 2000-02-08 15:56:05 inside ct_con_props() action = CS_GET property = 13
> 2000-02-08 15:56:05 processing result tokens.  marker is  ab
> 2000-02-08 15:56:05 inside ct_con_props() action = CS_GET property = 13
> 2000-02-08 15:56:05 processing result tokens.  marker is  fd
> 2000-02-08 15:56:05 processing result tokens.  marker is  aa
> 2000-02-08 15:56:05 inside ct_con_props() action = CS_GET property = 13
> 2000-02-08 15:56:05 processing result tokens.  marker is  ab
> 2000-02-08 15:56:05 inside ct_con_props() action = CS_GET property = 13
> 2000-02-08 15:56:05 processing result tokens.  marker is  fd
> 2000-02-08 15:56:05 inside ct_results()
> 2000-02-08 15:56:05 inside ct_cmd_drop()
> 
> It almost seems like the INSERT's worked, but then it got stuck trying to hang up - that's just my lay interpretation.  Anything I should be doing differently?  BTW, this works ~25% of the time.
>  
> Setup: solaris7->mssql 7.0, freetdsver=4.2,  through apache/mod_perl/Apache::DBI/DBD::Sybase
> 
> Thanks,
> -Bill
> 




More information about the FreeTDS mailing list