No ManagedConnections available within configured blocking timeout

Hi all, I have this error:

ore.api.NuxeoException: Cannot connect to database: default
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.openConnections(JDBCConnection.java:140) [nuxeo-core-storage-sql-7.10.jar:]
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.connect(JDBCMapper.java:1326) [nuxeo-core-storage-sql-7.10.jar:]
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:53) [nuxeo-core-storage-sql-7.10.jar:]
        at com.sun.proxy.$Proxy62.queryAndFetch(Unknown Source)
        at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.queryAndFetch(SoftRefCachingMapper.java:92) [nuxeo-core-storage-sql-7.10.jar:]
        at org.nuxeo.ecm.core.storage.sql.SessionImpl.queryAndFetch(SessionImpl.java:1223) [nuxeo-core-storage-sql-7.10.jar:]
        at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.queryAndFetch(ConnectionImpl.java:330) [nuxeo-core-storage-sql-ra-7.10.jar:]
        at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.queryAndFetch(SQLSession.java:435) [nuxeo-core-storage-sql-7.10.jar:]
        at org.nuxeo.ecm.core.api.AbstractSession.queryAndFetch(AbstractSession.java:1205) [nuxeo-core-7.10.jar:]
        at org.nuxeo.ecm.core.security.UpdateACEStatusWork.work(UpdateACEStatusWork.java:74) [nuxeo-core-7.10.jar:]
        at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransaction(AbstractWork.java:340) [nuxeo-core-event-7.10.jar:]
        at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransactionAndCheckExceptions(AbstractWork.java:301) [nuxeo-core-event-7.10.jar:]
        at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:272) [nuxeo-core-event-7.10.jar:]
        at org.nuxeo.ecm.core.work.WorkHolder.run(WorkHolder.java:52) [nuxeo-core-event-7.10.jar:]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_111]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_111]
        at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
Caused by: java.sql.SQLException
        at org.tranql.connector.jdbc.TranqlDataSource.getConnection(TranqlDataSource.java:67) [tranql-connector-1.8.jar:1.8]
        at org.nuxeo.runtime.datasource.geronimo.PooledDataSourceFactory$DataSource.getConnection(PooledDataSourceFactory.java:51) [nuxeo-runtime-datasource-7.10.jar:]
        at org.nuxeo.runtime.datasource.ConnectionHelper.getConnection(ConnectionHelper.java:823) [nuxeo-runtime-datasource-7.10.jar:]
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.openBaseConnection(JDBCConnection.java:147) [nuxeo-core-storage-sql-7.10.jar:]
        at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCConnection.openConnections(JDBCConnection.java:136) [nuxeo-core-storage-sql-7.10.jar:]
        ... 16 more
Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 90000 [ms] ) for pool org.apache.geronimo.connector.outbound.SinglePoolMatc
hAllConnectionInterceptor@27b92dc9
        at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:86) [geronimo-connector-2.2.1-NX1.jar:2.
2.1-NX1]
        at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:49) [geronimo-connector-2.2.1-NX1.jar:2.2.1-NX1]
        at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:109) [geronimo-connector-2.2.1-NX1.jar:2.2.1-NX1]
        at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43) [geronimo-connector-2.2.1-NX1.jar:2.2.1-NX1]
        at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39) [geronimo-connector-2.2.1-NX1.jar:2.2.1-NX1]
        at org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66) [geronimo-connector-2.2.1-NX1.jar:2.2.1-NX1]
        at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:77) [geronimo-connector-2.2.1-NX1.jar:2.2.1-NX1]
        at org.nuxeo.runtime.jtajca.NuxeoContainer$ConnectionManagerWrapper.allocateConnection(NuxeoContainer.java:837) [nuxeo-runtime-jtajca-7.10.jar:]
        at org.tranql.connector.jdbc.TranqlDataSource.getConnection(TranqlDataSource.java:62) [tranql-connector-1.8.jar:1.8]
        ... 20 more

I tried to update Nuxeo ( I have gotten last hot fix), I increased the connection pool (nuxeo.db.max-pool-size and nuxeo.vcs.max-pool-size), but the issue is alwayse present after that I use Nuxeo for a bit.

What can it be?

I'm using Wildfly 8.1 (as guide) and Oracle 12 + jdk8 on Redhat 7.2

Other note: I'm using the static war. This one, deployed on tomcat, manages the connection pools perfectly. In wildfly, instead, it creates always new connections in the pool until that this one is fully filled, causing the above error.

0 votes

0 answers

3066 views

ANSWER