connections not closing

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello all,

Platform:
Apache/1.3.20 (Unix)
Redhat 7.2
PHP/4.2.3
Postgres 7.2.1

Summary: periodically, something spazzes out and causes connections to the
database to stop closing at script termination; after a few seconds, the
number of connections to the database exceeds the connection limit for
postgres and all further connections to the database are denied ... the only
way to rectify the problem is to stop and restart apache

I use pgsql_connect (non-persistent connections) ... so that doesn't explain
it ...

I have the connection limit for postgres set at 64 ... and the Apache
MaxClients set to 150 ...

I cannot replicate this problem on production nor testing hardware ... It
happens very sporadically and without any real warning (it has happened
twice so far) ... Generally, it happens when the site is busy, but not
busier than what I've thrown at it with load test software ...

If and when this happens again, what further debugging information can i
gather to help diagnose this problem?

Thanks in advance,
Dave



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux