← Back to team overview

dhis2-users team mailing list archive

Re: Trouble running Analytics for 2.29

 

Your database has popped 😕

To find out why take a look in the postgresql log file around the same
time.

On Thu, 10 May 2018, 13:51 Knut Staring, <knutst@xxxxxxxxx> wrote:

> Hi all,
>
> Wondering if anyone has a tip for what is going wrong on my serer. I just
> tested running Analytics in 2.29 with the same db on my laptop and there
> were no issues, but everytime I try to do this on the server, it gives me
> the following:
>
>  INFO  2018-05-10 08:06:51,987 [Level: INFO, category: ANALYTICS_TABLE,
> time: Thu May 10 08:06:51 UTC 2018, message: Applying aggregation levels]
> (InMemoryNotifier.java [taskScheduler-14])
> * INFO  2018-05-10 08:07:10,890 Vacuumed tables
> (DefaultAnalyticsTableService.java [taskScheduler-14])
> * INFO  2018-05-10 08:07:10,890 Applied aggregation levels: 00:01:54.496
> (Clock.java [taskScheduler-14])
> * INFO  2018-05-10 08:07:10,890 [Level: INFO, category: ANALYTICS_TABLE,
> time: Thu May 10 08:07:10 UTC 2018, message: Creating indexes]
> (InMemoryNotifier.java [taskScheduler-14])
> * INFO  2018-05-10 08:07:10,891 No of analytics table indexes: 204
> (DefaultAnalyticsTableService.java [taskScheduler-14])
> May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:25 AM org.postgresql.Driver connect
> SEVERE: Connection error:
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:25 AM org.postgresql.Driver connect
> SEVERE: Connection error:
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.Driver connect
> SEVERE: Connection error:
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.Driver connect
> SEVERE: Connection error:
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:25 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.Driver connect
> SEVERE: Connection error:
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.Driver connect
> SEVERE: Connection error:
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: FATAL: the database system is in
> recovery mode
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:475)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207)
>         at
> org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
>         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195)
>         at org.postgresql.Driver.makeConnection(Driver.java:452)
>         at org.postgresql.Driver.connect(Driver.java:254)
>         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)
>
> May 10, 2018 8:07:26 AM org.postgresql.Driver connect
> SEVERE: Connection error:
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References