httpd hangs after user abort

hwyss

Hello all

Problem: My script retrieves a lot of data from a MySQL-db. Whenever there is a user-abort or the processing-time exceeds max_execution_time, the database-server shuts down fine (mysql_query("KILL $connection") registered in shutdown-function) -- but the httpd keeps building up to a size of approx. 20 Mbyte and then simply goes to sleep. The process sticks around for about a day, if it's not killed by the server-admin, and there have been threads around for up to three days, just clogging up vm-space...

Any suggestion what I could do? Is there a way to send a kill_thread()-signal to apache from my shutdown-function?

thanx in advance for all your suggestions!

ingooellers

Hello,

i think there are 3 possibilities

1) buggy PHP-Module, if you have an older module < 4.0.6 or an older Apache, think about an update if possible

2)
Apache caches some pages. Mark them as dynamic with metatags such as.

3) use mysql_free_result() wherever possible
or/and cut your script into smaller pieces

hwyss

Hi Ingo

thanx for the Ideas -
1) and
2) were 100% implemented before i wrote to the forum and
3) about 60% - I fixed that now, but the problem still prevails...

kparker

Are you using pconnect or connect? Suggest switching to the latter.

smarlowe

and of course, a prophylactic 'apache_ctl restart' in an hourly or daily cron job might help keep the box from dying while you're trying to figure out what's wrong.