ID: 17245 Updated by: [EMAIL PROTECTED] Reported By: sureshkb at orillion dot com -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: SUN os 5.6(Solaris) PHP Version: 4.1.2 New Comment:
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2003-06-29 21:33:23] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2003-04-15 13:54:27] fred dot cohen at iridium dot com I've experienced the same problem for a long time now. (OCI8 connecting to oracle 7.3.4) I haven't revisted it to see if it's still an issue, however a good interm solution is to reduce the life of the apache processes to live only a few hours. I've set MaxRequestsPerChild 100 in apache. Adjust for your server's level of activity. ------------------------------------------------------------------------ [2003-01-29 08:24:41] [EMAIL PROTECTED] Moving this to OCI8, which is where OCIPLogin() belongs. ------------------------------------------------------------------------ [2002-09-30 04:18:00] razakhalid40 at hotmail dot com Please tell me the solution of "Too many connection" the error occured in PHP while connecting to the database. if any body knows about the solution, then please mail me at the following email address: [EMAIL PROTECTED] I appreciate your help. Thanks ------------------------------------------------------------------------ [2002-05-15 07:32:10] sureshkb at orillion dot com I am using apache1.3.22,php4.1.1 with oracle8 and OS is solaris as well as WINDOWS 2000. I am using the persistence connection(PHP ociplogin()) for update/insert/select to the database. The apache server is opeing a child process and holding connection(one connection per child) on every database transaction. For every request the connection is opening to database and it is not getting closed. As per PHP document(Pl refer the PHP doc on persistence connection) the child created by apache, holds the persistence connection until it die(child). But for every request the apache is crating the child(i am asuming... because it is opening databse connection every time) and it is trying to hold the database connection even the remaining childs are free(not doing any thing). After some time all of my database connections are in use and giving error "MAX number of connections exceeded". Bye SURESH. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17245&edit=1
