FreeTDS Development Group

[Michael Kimsal <michael AT tapinternet.com>]

Little more info - maybe this is familiar to someone else too.

Now doing some work with PHP/FreeTDS as CGI, and still getting the
same problems.  Actually not CGI thru webserver, but from a command line.
Every 5th or 6th time I run a particular script, the process will
hang at the same query.  The tdsdump log I have always stops
in the same spot.


2000-09-13 18:53:12 inside dbnextrow()
2000-09-13 18:53:12 processing row tokens.  marker is  d1
2000-09-13 18:53:12 setting column 0 to NULL
2000-09-13 18:53:12 setting column 1 to NULL
2000-09-13 18:53:12 setting column 2 to NULL
2000-09-13 18:53:12 setting column 3 to NULL
2000-09-13 18:53:12 setting column 4 to NULL
2000-09-13 18:53:12 leaving dbnextrow() returning -1

it's looping thru this - it gets PART way thru the 29th row

2000-09-13 18:53:12 inside dbnextrow()
2000-09-13 18:53:12 processing row tokens.  marker is  d1
2000-09-13 18:53:12 setting column 0 to NULL
2000-09-13 18:53:12 setting column 1 to NULL
2000-09-13 18:53:12 setting column 2 to NULL
2000-09-13 18:53:12 setting column 3 to NULL

then stops on this column, even tho there are 43 rows to
get.

If this behaviour is familiar to anyone the list, or anyone has
any ideas to help, please let me know.

Thanks!




Brian Bruns wrote:

> Questions, is PHP run through dso or statically compiled in?  Is the httpd
> child core dumping? If so can you get a stack trace off the core file? Are
> you using persistant connections? Have you tried running PHP in cgi mode
> (like on a test server on a different port) and does it still happen
> there?
>
> We may need to tweak the code a bit to see what is going...Let me know
>
> Brian
>
> On Tue, 12 Sep 2000, Michael Kimsal wrote:
>
> > Hello all.  :)
> >
> > I'm having a devil of a time tracking this one down - I hope someone has
> > some knowledge here that can fix this.
> >
> > Situation:
> > We've been developing a web app for a couple months.  We're using PHP4
> > with the latest freetds and MSSQL7 (sp1).  Things were pretty fine up 
> > until about a
> > week ago.  *something's* changed, but I don't know what.  We are
> > now *often* having a page come back 'document contained no data' or the
> > IE equivalent.  By often I mean perhaps every 50 requests or so.  This 
> > NEVER used to
> > happen - we wouldn't have pressed forward with this if it did.
> >
> > Original development box:
> > Caldera 2.4 (kernel 2.2.14)
> > MSSQL7
> > FreeTDS CVS - August 17 snapshot and one from June were both used
> > at various times.
> > PHP - either the snapshots after the 4.0.1pl2 release or the current
> > 4.0.2
> >
> > Current box
> > RedHat 6.2 (kernel 2.2.14 also I believe with SMP - 2 processors)
> > MSSQL7 (again sp1)
> > FreeTDS CVS - August 17 snapshot and one from June were both used
> > at various times.
> > PHP - either the snapshots after the 4.0.1pl2 release or the current
> > 4.0.2
> >
> > Both boxes also running Apache 1.3.12
> >
> > Things worked fine on original box, and moved to final box (redhat) about 
> > 3
> > weeks ago.
> >
> > Sometime last week, though, the RedHat box started flaking out -
> > queries simply HANG and die.  I've dumped FreeTDS to a log, but it 
> > doesn't seem
> > to tell me anything.  There is no rhyme nor reason for this - hitting 
> > reload will
> > normally do the querys again and the page is fine.
> >
> > There is no error in the Apache error log - the access log shows the page 
> > as
> > getting called, but returning 0 bytes (or, more precisely, '-' bytes).
> >
> > I've compiled freetds with
> > --enable-msdblib --with-tdsver=4.2
> > Also tried tdsver=7.0 with no better results.
> >
> > Any troubleshooting information anyone can pass on?
> >
> > I can send logfiles to anyone individually if you'd like - just didn't 
> > want to clog up
> > the
> > list with big big mails.
> >
> > Thanks in advance.  :)
> >
> >
> > ==========================
> > Michael Kimsal
> > http://www.tapinternet.com
> > 734-480-9961
> >
> >
> >
> > ---
> > You are currently subscribed to freetds as: camber AT ais.org
> > To unsubscribe, forward this message to $subst('Email.Unsub')
> >
> >
>
> ---
> You are currently subscribed to freetds as: michael AT tapinternet.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

--
==========================
Michael Kimsal
http://www.tapinternet.com
734-480-9961