PAMP: httpd terminated, reasons unclear

[Grismar]

Hello,

I've progressed a lot since I last visited these pages, but now I've run into a problem I'm unable to fix. When I post a value and start a (somewhat complex) query from the pages I wrote, I get a "Web: Connection time-out!" error.

A look at PAMP shows that the httpd was 'terminated'. But when I look at the error-log, all I see are these messages:
[notice] Digest: generating secret for digest authentication ...
[notice] Digest: done
[notice] MaxSpareThreads of 1 exceeds or is equal to ThreadLimit of 1, reset to 0.
[notice] MinSpareThreads of 1 exceeds MaxSpareThreads of 0, reset to 0.

I've tried all combinations that seemed to make sense and some that didn't:
- Increasing the threadlimit doesn't work, since Py and PHP don't support it yet, according to the error log.
- Setting the MaxSpareThreads to 1 and the MinSpareThreads to 0, or 1 and 1 respectively or 0 and 0 respectively doesn't work, the error messages change accordingly, but it comes down to the server resetting them both back to 0, since MaxSpareThreads is greater than or equal to ThreadLimit and Min SpareThreads is greater than or equal to MaxSpareThreads.

Requesting other pages, that run simpler queries on the same database, yields no problems. What about my situation could be causing the termination? Does it have to do with the threads at all and is there some settings I'm overlooking? Or does it have something to do with trying to process a POSTed form somehow?

(edit) I've tried to set my local install of Apache to the settings used by the PAMP one, but it chokes on the MaxSpareThreads and MinSpareThreads for other reasons, which I presume have to do with the ton of mods it is loading.

The application works flawlessly on my PC installation of Apache, MySQL and PHP and on the online version, so I'm at a loss...

(edit) For reference: the same page on an online location: http://www.grismar.net/seekwell

Any help appreciated, greetings,
Grismar.

[jhnwkmn]

Hi,

...
Requesting other pages, that run simpler queries on the same database, yields no problems. What about my situation could be causing the termination? Does it have to do with the threads at all and is there some settings I'm overlooking? Or does it have something to do with trying to process a POSTed form somehow?

Apache can terminate in a controlled or uncontrolled way. When it terminates in a controlled way, Apache has noticed that something has gone badly wrong, so it exits after having written an appropriate entry to the error log. When it terminates in an uncontrolled way, it simply crashes due to some bug somewhere.

So, since nothing is written to the error log it's likely that Apache in your case crashes for some reason.

Do you have a file C:/Resource/ErrRd on your device? If not, check here for details. With that file present, you may be shown a Kern-Exec error message box when you post your request. That would confirm that it is indeed an Apache crash.

Have you tried increasing the amount of RAM available to Apache? If you are running PAMP standalone, then you can do that from [Options]->[Settings]->[httpd]->'Max heap size'. If you are running PAMP under MWS, then you need to edit the file c:/data/apache/httpds.xml.

Br,
Johan