Skip to Content.
Sympa Menu

freetds - Re: PHP/tds issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP/tds issue
  • Date: Thu, 14 Sep 2000 18:44:16 -0400 (EDT)



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')
>
>





Archive powered by MHonArc 2.6.24.

Top of Page