php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: sureshkb at orillion dot com
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-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-2021 The PHP Group
All rights reserved.
Last updated: Fri Dec 03 08:03:33 2021 UTC