Throw connection pool in liferay 6.2

[8年前 に Huy Vo によって更新されました。]

Hi all !
- I have config portlet connect to 3 datasource, using service builder to develop. Database use portgresql. I can get data to 3 datasource. but view console i see log:

 [C3P0PooledConnectionPoolManager[identityToken->8B40R1Be]-HelperThread-#2][BasicResourcePool:313] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@43c6c6f4 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 
org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:293)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:211)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1127)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1114)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1855)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)</init></init></init>

Please help me fix
Thanks !

[8年前 に Olaf Kock によって更新されました。]

Huy Vo:

Hi all !
- I have config portlet connect to 3 datasource, using service builder to develop. Database use portgresql. I can get data to 3 datasource. but view console i see log:

 [C3P0PooledConnectionPoolManager[identityToken->8B40R1Be]-HelperThread-#2][BasicResourcePool:313] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@43c6c6f4 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 
org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:293)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Co

Did you google for the error message?

[8年前 に Huy Vo によって更新されました。]

Hi Olaf Kock!
- My Problem is setting in database. I have config

max_connections = 100

default of postgres. I set = 300. I am monitoring have throw log in console .
Thanks you verry much !