Too many connections to PostgreSQL

pablogosse

Hi all. I'm running into a problem wherein I'm unable to connect to my postgresql db because the maximum number of connections has been reached.

I use ADOdb for my db work, and the thing is I'm using the PConnect function, so it's supposed to be using persistent connections.

Since this is the case, I find it very strange that I'm having problems with the number of connections to postgresql.

Also, I'm the only one using Postgresql on this server (a test machine) and I'm working on one area of my project (two or three pages) so it should definitely be reusing the connections.

Does anyone have any idea why this wouldn't be working?

Thanks in advance,
Pablo

niyogi

Hi there,

That is strange although sometimes the code could be causing the problem. Post some of the code here and we'll take a look at it.

Also, you might want to take a look at your phpinfo() (PHP configuration) as you might have persistent connections for PostgreSQL turned off.

Cheers,
niyogi

pgHoster - PostgreSQL Web Hosting
http://www.pghoster.com

pablogosse

Hi Niyogi. Thanks for your help.

I looked at the php setup, and found the following (values are the same for local and master):

pgsql.allow_persistent - On
pgsql.auto_reset_persistent - Off
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited

Here's the code I'm using to connect with (this is the file conn.wms_admin.inc.php):

include_once("wms/_classes/adodb/adodb.inc.php");
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$conn = &ADONewConnection("postgres");
$conn->PConnect("localhost","wms_admin","***************","unbc");

This code is called through the following on any page where I need to access the database:

include_once("wms/_classes/adodb/conn/conn.wms_admin.inc.php");

and then I simply access the $conn object and do what ever I need to do.

Is there a problem in the way I'm doing this?

Thanks in advance,
Pablo

niyogi

Interesting. I don't use ADODB type connections to PostgreSQL since I wrote my own PostgreSQL module to connect to and administer PostgreSQL databases.

To troubleshoot, have you tried the "traditional" way of connecting to PostgreSQL with the native pg_ functions?

If it works this way, then we can isolate the error to the ADODB class you're using.

-niyogi

pablogosse

I haven't tried that yet, but it'll be my next step. Thanks for the tip.

The weird thing is this problem has only occurred twice, and I've been testing on this server for almost a month now. It happened a few weeks ago, and then it happened again yesterday.

Last night, after my sysadmin restarted everything, I even went so far as to sit at my computer for almost 20 minutes just reloading the page that gave me the problem over and over and over again. However, I was unable to duplicate the problem.

Now that I think about it, though, a few months ago on another server on which I used ADOdb with PostgreSQL I ran into a similar problem, so maybe it is ADOdb.

Thanks,
P.