Re: DBCP borrowObject failed

Lists: pgsql-bugs
From: "Azam (dot)" <azam1980ir(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: DBCP borrowObject failed
Date: 2003-06-27 09:18:07
Message-ID: 20030627091807.13569.qmail@web41802.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

hi all

I don't know if this is the right list to ask this question or not but however I'm using postgres and tomcat4.1.24, I got this error

DBCP borrowObject failed: Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: FATAL 1: Sorry, too many clients already
Stack Trace:
java.sql.SQLException: FATAL 1: Sorry, too many clients already
at org.postgresql.Connection.openConnection(Connection.java:274)
at org.postgresql.Driver.connect(Driver.java:149)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(P....

and after I restarted tomcat It was corrected,Is there anything wrong?This is the content of my postmaster.opts
/usr/bin/postmaster '-i' '-N' '64' '-B' '256'

Thanks in advance
azam

---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Azam (dot)" <azam1980ir(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: DBCP borrowObject failed
Date: 2003-06-27 14:56:08
Message-ID: 27940.1056725768@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"Azam ." <azam1980ir(at)yahoo(dot)com> writes:
> DBCP borrowObject failed: Something unusual has occured to cause the
> driver to fail. Please report this exception: Exception:
> java.sql.SQLException: FATAL 1: Sorry, too many clients already
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Time to increase the postmaster's MAX_CONNECTIONS setting.

regards, tom lane