Skip to Content.
Sympa Menu

freetds - Re: freetds never finishes?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: freetds never finishes?
  • Date: Wed, 9 Feb 2000 20:27:24 -0500 (EST)



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
>





Archive powered by MHonArc 2.6.24.

Top of Page