Jon Foreman wrote:
Does anyone have any suggestions for the following problem:
I'm running Apache/1.3.31 and PHP Version 4.3.8 connecting to an Oracle database. Periodically, PHP is unable to connect to the database. When this problem occurs, I am able to connect to the database from the webserver without any problem using SQLPlus. I've also run tcpdump on my database server and I see no incoming requests from the problem web server when I run a PHP page that queries the database.
A graceful restart of apache, or simple 'apachectl restart' do not fix the problem. I have to manually stop and start the Apache process and the problem goes away (for a while at least).
We are using persistent database connections, but non-persistent ociconnect calls also fail. The number of DB connections is unlimited in the php.ini config. Also, my DB server has plenty of capacity to accommodate many more connections.
Thanks,
Jon
Are you getting any errors? Are the failing connections to the same or different database users? What sorts of load is Apache under? What platform? What kinds of statements are being run (is anything blocking threads/connections etc)? Are you using the "oci8" or "oracle" calls (do both have the problem)?
Chris
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
