FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Ok, I've added some code to help debug this.  Grab a copy from CVS.  In 
the freetds.conf file turn on the option 'dump file append' like so:

[global]
...
   dump file        = /tmp/freetds.log
   dump file append = yes
...

Change /tmp/freetds.log to wherever you need to put it. If you have 
multiple databases and only want to do this for one, then put it in the 
database section instead.

This will cause all apache children to append onto the same log file.

Now, in addition to the normal caveat of passwords showing up (I'm working 
on a patch for that one by the way), the peformance hit of opening the 
log file every time we need to write to it is unknown but likely will have 
some impact.  Also, the log file is likely to grow quite large.

So, what I would recommend is to flip the switch, stress test it until it 
breaks, then revert the conf file and send me the resultant logs off-list.
Then we should be able to better trace what is causing the problem.

Also, send me the pid number of the crashed child.

Cheers,

Brian

On Fri, 9 Nov 2001, Stefan Carstens wrote:

> Hi out there,
> The problem occurs only sometimes but it does an entry in the apache 
> error_log
> 
> Error: 104 (Connection reset by peer) TDS: Write failed in tds_write_packet"
> 
> If we use pconnect, the problems comes up more often, than with the use of 
> a "normal" connect !
> The webserver is a Mandrake Linux 8.0 System, Apache 1.3.20 + PHP 4.0.6 
> with FreeTDS 0.53.
> 
> PHP was configured this way :
> ./configure --with-apxs --enable-versioning --enable-trans-sid 
> --without-mysql --enable-track-vars --enable-sysvsem --enable-sysvshm 
> --enable-
> sockets --with-zlib=/usr/local/ --with-apxs --with-curl=/usr/local/lib 
> --with-sybase=/usr/local/sqlserver
> 
> Apache was compiled with support for SSL.
> 
> FreeTDS was compiled with --prefix=/usr/local/sqlserver --with-tdsver=7.0
> 
> The MS SQL Server is a 2000 SP1 running on a 2000 Server SP2.
> 
> Both maschines are IBM xSeries 330 with 2 x PIII 866 and 512 MB RAM.
> 
> 
> MS's Query Analyzer runs perfectly, so all other tools do, only the 
> combination mentioned above make problems.
> 
> Thanks in advance,
> Stefan
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>