dhis2-users team mailing list archive

[Barnabas Akumba <akumbabarns@xxxxxxxxx>]

Hello All,

I've been receiving an Analytics Failure message on my DHIS2 Instance
(version 2.27) for some days now.
I've been looking through the Error message to try and figure out what the
issue could be but can't pin-point it.
Any one with a solution to this problem?
See Error message below:

Time: 2018-03-20T01:32:49.598Z
Message: Exception during execution

Cause: java.util.concurrent.ExecutionException: org.springframework.
transaction.CannotCreateTransactionException: Could not open Hibernate
Session for transaction; nested exception is
org.hibernate.exception.GenericJDBCException:
Unable to acquire JDBC Connection
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at org.hisp.dhis.commons.util.ConcurrentUtils.waitForCompletion(
ConcurrentUtils.java:53)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.
populateTables(DefaultAnalyticsTableService.java:210)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableService.update(
DefaultAnalyticsTableService.java:132)
at org.hisp.dhis.analytics.table.DefaultAnalyticsTableGenerator
.generateTables(DefaultAnalyticsTableGenerator.java:112)
at org.hisp.dhis.analytics.table.scheduling.AnalyticsTableTask.
call(AnalyticsTableTask.java:68)
at org.hisp.dhis.security.NoSecurityContextRunnable.run(
NoSecurityContextRunnable.java:47)
at org.hisp.dhis.scheduling.ScheduledTasks.run(ScheduledTasks.java:60)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:54)
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(
ReschedulingRunnable.java:81)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$
ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(
ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.transaction.CannotCreateTransactionException:
Could not open Hibernate Session for transaction; nested exception is
org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC
Connection
at org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin(
HibernateTransactionManager.java:542)
at org.springframework.transaction.support.AbstractPlatformTransactionMan
ager.getTransaction(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
createTransactionIfNecessary(TransactionAspectSupport.java:447)
at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:277)
at org.springframework.transaction.interceptor.
TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(
ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.
invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy61.getDataDimensionsNoAcl(Unknown Source)
at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.
getDimensionColumns(JdbcAnalyticsTableManager.java:307)
at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTable(
JdbcAnalyticsTableManager.java:209)
at org.hisp.dhis.analytics.table.JdbcAnalyticsTableManager.populateTable(
JdbcAnalyticsTableManager.java:180)
at org.hisp.dhis.analytics.table.AbstractJdbcTableManager.
populateTablesAsync(AbstractJdbcTableManager.java:201)
at sun.reflect.GeneratedMethodAccessor1583.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection
(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.
invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:157)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(
AsyncExecutionInterceptor.java:115)
... 6 more
Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire
JDBC Connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(
StandardSQLExceptionConverter.java:47)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
SqlExceptionHelper.java:97)
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.
acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:87)
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.
getPhysicalConnection(LogicalConnectionManagedImpl.java:109)
at org.hibernate.internal.SessionImpl.connection(SessionImpl.java:492)
at org.springframework.orm.hibernate5.HibernateTransactionManager.doBegin(
HibernateTransactionManager.java:448)
... 26 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:692)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(
AbstractPoolBackedDataSource.java:146)
at org.hibernate.engine.jdbc.connections.internal.
DatasourceConnectionProviderImpl.getConnection(
DatasourceConnectionProviderImpl.java:122)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAcc
ess.obtainConnection(AbstractSessionImpl.java:386)
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.
acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:84)
... 29 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:1469)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(
BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(
BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.
checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.
checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
... 33 more
Caused by: org.postgresql.util.PSQLException: Connection to localhost:5432
refused. Check that the hostname and port are correct and that the
postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
ConnectionFactoryImpl.java:265)
at org.postgresql.core.ConnectionFactory.openConnection(
ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:194)
at org.postgresql.Driver.makeConnection(Driver.java:450)
at org.postgresql.Driver.connect(Driver.java:252)
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.WrapperConnectionPoolDataSource.getPooledConnection(
WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$
1PooledConnectionResourcePoolManager.acquireResource(
C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(
BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.
doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(
BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(
BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(
BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(
ThreadPoolAsynchronousRunner.java:696)
Caused by: java.net.ConnectException: Connection refused (Connection
refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:
350)
at java.net.AbstractPlainSocketImpl.connectToAddress(
AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at org.postgresql.core.PGStream.(PGStream.java:68)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(
ConnectionFactoryImpl.java:144)
... 13 more


-- 

Barnabas AKUMBA

*Mobile:* +2348036195778
*Skype:* barnabas.akumba