FreeTDS Development Group

["Lowden, James K" <james.k.lowden AT alliancebernstein.com>]

> From: Largo
> Sent: Thursday, February 01, 2007 4:50 AM
> 
> I had a problem posted here 2 weeks ago:
> http://lists.ibiblio.org/pipermail/freetds/2007q1/021045.html which
> still isn't solved. But meanwhile I have some more information as
> I've been digging in the code of freetds. It seems freetds is stuck
> in an endless loop in the function tds_goodread in the file net.c

Because of problems like yours, and because of messages like yours, I
rewrote the timeout logic in CVS HEAD.  It's very different from the
code you're looking at because, as you noted, it has to be.  

I don't think it will be possible to take some of my changes.  I'm
afraid your best bet is to upgrade to the current snapshot.  If you do,
please let us know how it goes.  If there are still timeout issues, I
obviously would want to know about them.  

You might want to look over my discussion with Frediano re the ODBC
driver and cancel timeouts.  On  Jan 16 2007 at 4:13am we said:

> > ODBC's specification is a little vague. Probably if you set a query
> > timeout of 20 seconds and pull the wire, you'll get a failure in 40
> > seconds, because when the timer expires the library will make one
> > good-faith effort to cancel the pending request (which will 
> > itself timeout
> > 20 seconds later). I'm sure Frediano made a sensible choice 
> > in any case. 
> > 
> 
> Mmmm... are you sure?
> No, currently it returns always TDS_INT_TIMEOUT (that is send cancel
and
> continue) so probably it just keep waiting forever...

If you're reading the new code and have any questions, just ask.  

HTH.  

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.