01-18-2017 12:41 AM
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.
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.