Apache children dieing

[mnuzum]

Hello all,

I'm noticing a serious problem with my webapplication. About every 7th time you view a page, you get a DNS error, server not found in IE or a DOCUMENT CONTAINS NO DATA error in Netscape.

I checked the logs and I get some funny things, namely apache children segfaulting and something about adding a missing from clause to table domains.

I have a table in postgres called domains, but I checked all my queries and they look right.

Any clues? Matt Nuzum

here's the last 25 lines of /var/log/httpd/errors :
$ tail -n 25 /var/log/httpd/error

[Fri Oct 26 14:36:24 2001] [notice] child pid 8083 exit signal Segmentation fault (11)
[Fri Oct 26 14:36:27 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:33 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:34 2001] [notice] child pid 16106 exit signal Segmentation fault (11)
[Fri Oct 26 14:36:36 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:38 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:39 2001] [notice] child pid 15934 exit signal Segmentation fault (11)
[Fri Oct 26 14:36:41 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:44 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:45 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:47 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:50 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[Fri Oct 26 14:36:50 2001] [notice] child pid 15937 exit signal Segmentation fault (11)
[Fri Oct 26 14:36:52 2001] [error] NOTICE: Adding missing FROM-clause entry for table "domains"

[basim]

It's funny how i'm seeing this message.
For the past 2 days, I've been experiencing the same problem with the exact error message in the log. First I tried restarting the http daemon, then even rebooting on my mandrake box. My version of apache is 1.3.19 with PHP 4.0.4. What might be happening is that if you are using a function in an if statement and forgetting to finish closing the if statement

I had:

if(!@in_array($needle, $haystack ) { ....

i fixed it to
if(!@in_array($needle, $haystack ) ) { ....

and everything started working again.

From the looks of it, you might be missing the SQL command in your string that you are passing around. Check to see if you are missing any closing brackets where you have SQL statements

Hope this helps