PHP/tds issue
Brian Bruns
camber at umcc.ais.org
Thu Sep 14 19:01:44 EDT 2000
sorry, I'm steering you wrong...-a is an option on dbx I assumed gdb had the
same flag. Let me look it up and I'll write back.
On Thu, 14 Sep 2000, Michael Kimsal wrote:
> OK - I'm pretty stupid at this - gdb -a 27552 (the PID) tells
> me that -a is ambiguous. gdb --help doesn't show me any
> options that take a PID. What am I missing? (sorry for the ignorance! -
> I'm learning this guts stuff)
>
>
> Brian Bruns wrote:
>
> > Ok, now we're getting somewhere. Is the process just hanging at this point
> > or does the program exit? If it is hanging can you (from another shell)
> > attach to it (gdb -a <pid>) and run 'where' to get a stack trace? My guess
> > is it'll be blocked in read() for the socket. If so see if you can print
> > tds->in_pos and tds->in_buf[] which should give us a clue as to what is
> > going on. Specifically, look for the last byte with a value of decimal 209
> > (TDS_ROW_TOKEN) and everything that follows until tds->in_buf[tds->in_pos]
> >
> > Brian
> >
> > On Wed, 13 Sep 2000, Michael Kimsal wrote:
> >
> > > 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
> > >
> > >
> > >
> > > ---
> > > 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
>
>
>
> ---
> You are currently subscribed to freetds as: camber at ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
>
More information about the FreeTDS
mailing list