Skip to Content.
Sympa Menu

freetds - Re: PHP/tds issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Kimsal <michael AT tapinternet.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP/tds issue
  • Date: Thu, 14 Sep 2000 18:50:15 -0400


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






Archive powered by MHonArc 2.6.24.

Top of Page