Weird Behavior on PHP+Apache+Oracle 9

[tmoesch]

Hi,
I installed PHP 4.3.2 on a RH 8 with Apache 1.3.27.
The PHP was compiled with OCI8 support (Oracle 9.0.2 client libs)
Everything during the making process occured ok, and after a lot of web search I finally found out how to connect to Oracle via PHP.

But a strange problem appeared. After some time of usage, the Apache server stops responding and I have to restart it to have the site back up. The client simply stays waiting for a server response but nothing occurs. There's no log on apache either!

Did any one faced something like that before?
I'm digging the web but so far nothing...

Thanks,
Thiago Moesch

[ksandom]

I had a similar thing a while back. It was todo with my database query taking a really really long time. Play about with this (http://php.net/manual/en/function.set-time-limit.php). If I was you, I would try putting this in many places throughout your script and setting it really really small, something like 4 to 5 seconds. It may be that it's waiting for something to happen. By putting the set_time_limit on, it will stop and give an error on the line that is taking to long.

Another way of doing this, which might be better as a start, is to put this line right at the top and set it to about 10ish. This will give you a general overview of where things are taking time.

side note: On my computer it takes about twice the time that is set for it to trigger the error. But it does come up.

[tmoesch]

I'll try that, but this strange thing comes up even when I'm not connecting to Oracle.

But not always, if I never access the scripts that uses the Oracle, the system runs fine, but when I do, after a while the apache stops responding, to anyone who tries to access it.

Thiago

[stolzyboy]

maybe you should try upgrading to the latest stable apache version