Re: apache process going wild...

Johny C. Buzz wrote:

Hello,

I have a small FreeBSD 6.3 R server with 1Go of RAM and 5Go of swap. No
X enviroment, just the basic PHP5, apache 2 and Berkley DBXML database
with few other small programs...

The native XML database is loaded with a 60Mb XML file and a PHP form
enables request on the data passing XML (xpath) queries. My problem is
that a simple query translate sometime in a 130-140Mb of RAM used by one
HTTPD process without giving the RAM back to the system. 3 or 4 process
like that and apache is out of memory, leaving any new request with and
error and no results...

The request made with PHP is of 2 kind:
1) make a list of everything, no cretiria... we show the firt 200
products... the apache process grows with the search into DBXML and
becomes 130Mb but 10 secondes later, goes back to be few kb... the web
pages is showing the results... everything perfect!

2) make a list but with products that cost less than X and from this Y
supplier... we show the firt 200 products (if more than)... the apache
process grows with the search into DBXML (same data) and becomes 130Mb
but 10 secondes later, the web pages is showing the results, the query
is over BUT the apache process is still stuck to 130Mb... after few
request like that, no new queries are possible...

I have no clue to what is the cause... the PHP code is identical in both
form, the same XML database, the only deference is few extra cretiria in
the query... what is the link between that and apache... ?

How to make sure after the query that the buffer will be flushed? But I
guess it's not normal to terminate a process like that! I dont want a
fix but a cure!

Thank you for any advice...
Bye
--
Johny

You might try adding this to your code:

http://us.php.net/manual/en/function.apache-child-terminate.php

-Jason

.

Relevant Pages

  • apache process going wild...
    ... No X enviroment, just the basic PHP5, apache 2 and Berkley DBXML database with few other small programs... ... The native XML database is loaded with a 60Mb XML file and a PHP form enables request on the data passing XML queries. ... My problem is that a simple query translate sometime in a 130-140Mb of RAM used by one HTTPD process without giving the RAM back to the system. ...
    (comp.unix.bsd.freebsd.misc)
  • [TOOL] Blowchunks - Protecting Existing Apache Servers Until Upgrades Arrive
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... a known vulnerable apache server until they can ... on HTTP "request" messages. ... Attached are a two versions of code to allow the server to intercept each ...
    (Securiteam)
  • [UNIX] Apache HTTP Server 413 Error Page XSS
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Apache HTTP Server 413 Error Page XSS ... Apache 2.X returns a '413 Request Entity Too Large' error, ...
    (Securiteam)
  • Re: mod_perl, "use lib", and stuff ...
    ... Under mod_perl the Perl interpreter can ... persist from one request to the next. ... Alternatively have a separate Apache instance per version. ... > create a program plus some modules for that program to use, ...
    (comp.lang.perl.modules)
  • setpeuid(pid_t, uid_t) proposal
    ... Apache sends and receives HTTP posts, ... Apache on the server must either a) run as root, ... The request comes with authentication information (in a number ... This daemon is highly audited and does one purpose, ...
    (Linux-Kernel)