PHP/tds issue
Michael Kimsal
michael at tapinternet.com
Tue Sep 12 12:51:12 EDT 2000
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
More information about the FreeTDS
mailing list