FreeTDS Development Group

["Rick Gigger" <Rick AT alpinenetworking.com>]

Thank you so much for this response.  I will try to be able to replicate
the sequence of queries that cause these problems.

Rick

> -----Original Message-----
> From: James Cameron [mailto:cameron AT stl.dec.com]
> Sent: Wednesday, November 07, 2001 3:33 PM
> To: TDS Development Group
> Subject: [freetds] Re: stability
> 
> 
> Rick Gigger wrote:
> > Am I the only one experiencing problems like this?
> 
> No, I've seen similar problems lately.  Since fixed in CVS.
> 
> PHP with Apache?  Persistent database connections?  Sounds like the
> FreeTDS connection is entering a broken state, and once it does then
> that particular Apache process is infected, and it will give problems
> whenever a connection arrives for it.  It only *looks* random and
> unreliable, when in fact it is quite broken.  PHP believes 
> the database
> connection is up, but FreeTDS believes it is down.
> 
> See if the problem goes away with a close and re-open of the database
> connection.  Add a temporary test that will verify the connection is
> stable (e.g. select @@version) and if it fails then close and 
> re-open. 
> See if you can trace the query sequence made to FreeTDS that 
> causes the
> connection to break.  Once you can do that, we can fix it readily.
> 
> It will take a bit of work, but that's exactly the work that our
> developers of PHP and FreeTDS have to go through to reproduce and fix
> the problem.
> 
> -- 
> James Cameron                                      
> (cameron AT stl.dec.com)
> 
> Not the Director of Titanic, but he had his name before I did.
> 
> ---
> You are currently subscribed to freetds as: 
> [rick AT alpinenetworking.com]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
>