stability

Rick Gigger Rick at alpinenetworking.com
Wed Nov 7 00:32:01 EST 2001


sure,

I am using php and certain things seem to cause problems.

While using freetds to set up custom session handlers I have encountered
bizzare random problems.  I will get random "1 is not a sybase index"
errors.  I will refresh the page over and over and the error will come
and go.  This has happened to me multiple times on multiple projects.

When a large number of connections was made to the database I would get
more random errors.  If a lot of people hit the site there would be more
and more connections made to the database.  More random errors.

Often if there is a sql error commited something gets messed up and
freetds begins behaving erratically.  For instance I make a bad sql
query during developement.  Then I fix the query.  I get random errors
that all of a sudden go away when I restart the web server.  These
errors may not be sybase reporting errros but just blatently incorrect
datasets.  Like it supposed to return 10,000 rows on a simple query but
instead returned none.  No error thrown, just an emtpy result set.

I didn't have nearly so many problems (although there were a few issues)
with freetds 0.52.  But then I was using protocol v4.2.  Unfortunately I
am highly reliant on the ability to access varchar fields > 256 bytes
long.

Am I the only one experiencing problems like this?

Rick



> -----Original Message-----
> From: JefferySamuel at binus.ac.id [mailto:JefferySamuel at binus.ac.id]
> Sent: Tuesday, November 06, 2001 9:14 PM
> To: TDS Development Group
> Subject: [freetds] Re: stability
> 
> 
> 
> Can you tell me what kind of stability problems do you 
> experienced ? please
> describe... I'm using freetds 0.52 configured with tds 
> protocol 4.2 it went
> fine till now
> 
> 
> 
>                                                               
>                                                 
>                     rick at alpinenetworking.com                 
>                                                 
>                     Sent by:                                
> To:     "TDS Development Group"                   
>                     bounce-freetds-138068 at franklin.o        
> <freetds at franklin.oit.unc.edu>                    
>                     it.unc.edu                              
> cc:                                               
>                                                             
> Subject:     [freetds] stability                  
>                                                               
>                                                 
>                     11/07/2001 06:20 AM                       
>                                                 
>                     Please respond to "TDS                    
>                                                 
>                     Development Group"                        
>                                                 
>                                                               
>                                                 
>                                                               
>                                                 
> 
> 
> 
> 
> I am having serious stability problems with freetds 0.52 using tds
> protocol v7.  Is this something that is likely to change any 
> time soon?
> 
> ---
> You are currently subscribed to freetds as: 
> [JefferySamuel at binus.ac.id]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
> 
> 
> 
> 
> 
> ---
> You are currently subscribed to freetds as: 
> [rick at alpinenetworking.com]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
> 



More information about the FreeTDS mailing list