FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

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