cancel
Showing results for 
Search instead for 
Did you mean: 

No ManagedConnections available within configured blocking timeout

Antonio_Pescion
Confirmed Champ
Confirmed Champ

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 REPLIES 0
Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.