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 19:01:44 -0400 (EDT)


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





Archive powered by MHonArc 2.6.24.

Top of Page