AnsweredAssumed Answered

Connections could not be acquired from underlying database!

Question asked by jeff.wallace on Aug 8, 2016
Latest reply on Aug 9, 2016 by jeff.wallace

When attempting to start my registry, I'm getting the following output in the registry log file (registry.log)

 

Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
Error Code: 0
        at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:309)
        at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)
        at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
        at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:330)
        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:293)
        at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:418)
        at org.eclipse.persistence.sessions.server.ConnectionPool.buildConnection(ConnectionPool.java:216)
        at org.eclipse.persistence.sessions.server.ConnectionPool.startUp(ConnectionPool.java:504)
        at org.eclipse.persistence.sessions.server.ServerSession.connect(ServerSession.java:484)
        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:633)
        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:208)
        at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)
        ... 17 more
Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
        at com.itko.lisa.utils.db.LisaWrappedDataSource.getConnection(LisaWrappedDataSource.java:38)
        at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:123)
        ... 27 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1463)
        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:639)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:549)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683)
        ... 30 more
2016-08-08 19:51:35,106Z (14:51) [main] ERROR com.itko.lisa.utils.JpaUtil    - ==== #################################### ====
2016-08-08 19:51:35,107Z (14:51) [main] ERROR com.itko.lisa.utils.JpaUtil    - The database has not been initialized correctly. There is at least one missing table.
2016-08-08 19:51:35,107Z (14:51) [main] ERROR com.itko.lisa.utils.JpaUtil    - ==== #################################### ====
2016-08-08 19:51:35,107Z (14:51) [main] ERROR System.err                     - The database has not been initialized correctly. There is at least one missing table.
2016-08-08 19:51:35,108Z (14:51) [main] ERROR System.err                     - java.lang.RuntimeException: The database has not been initialized correctly. There is at least one missing table.
2016-08-08 19:51:35,108Z (14:51) [main] ERROR System.err                     -  at com.itko.lisa.utils.JpaUtil.<init>(JpaUtil.java:461)
2016-08-08 19:51:35,109Z (14:51) [main] ERROR System.err                     -  at com.itko.lisa.utils.JpaUtil.getDradisUtil(JpaUtil.java:376)
2016-08-08 19:51:35,109Z (14:51) [main] ERROR System.err                     -  at com.itko.lisa.dradis.comm.JpaUtilWrapper.getAnnotations(JpaUtilWrapper.java:19)
2016-08-08 19:51:35,109Z (14:51) [main] ERROR System.err                     -  at com.itko.lisa.dradis.comm.DradisCommContext.doEnterpriseDashboardHandshake(DradisCommContext.java:137)
2016-08-08 19:51:35,110Z (14:51) [main] ERROR System.err                     -  at com.itko.lisa.coordinator.TestRegistryImpl.<init>(TestRegistryImpl.java:337)
2016-08-08 19:51:35,110Z (14:51) [main] ERROR System.err                     -  at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2401)
2016-08-08 19:51:35,110Z (14:51) [main] ERROR System.err                     -  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2016-08-08 19:51:35,110Z (14:51) [main] ERROR System.err                     -  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2016-08-08 19:51:35,111Z (14:51) [main] ERROR System.err                     -  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2016-08-08 19:51:35,111Z (14:51) [main] ERROR System.err                     -  at java.lang.reflect.Method.invoke(Method.java:497)
2016-08-08 19:51:35,111Z (14:51) [main] ERROR System.err                     -  at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)
2016-08-08 19:51:35,111Z (14:51) [main] ERROR System.err                     -  at com.install4j.runtime.launcher.UnixLauncher.main(Unknown Source)

 

 

It would seem that the connection can't be obtained because of the line, "The database has not been initialized correctly.  There is at least one missing table."

 

Anybody seen that before?

Outcomes