php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #17245 persistence connection problem(ociplogin)
Submitted: 2002-05-15 07:32 UTC Modified: 2003-07-04 02:05 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:0 (0.0%)
From: sureshkb at orillion dot com Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 4.1.2 OS: SUN os 5.6(Solaris)
Private report: No CVE-ID: None
View Developer Edit
 [2002-05-15 07:32 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-09-30 04:18 UTC] 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:
razakhalid40@hotmail.com

I appreciate your help.
Thanks
 [2003-01-29 08:24 UTC] maxim@php.net 
Moving this to OCI8, which is where OCIPLogin() belongs.
 [2003-04-15 13:54 UTC] 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-06-29 21:33 UTC] iliaa@php.net 
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-07-04 02:05 UTC] sniper@php.net 
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 14:01:32 2024 UTC