← Back to team overview

dhis2-users team mailing list archive

Re: Trouble running Analytics for 2.29

 

Thanks Bob, I will try, but where is the postgresql log file in your setup
(with dhis2-tools)?

The strange thing is that everything else works up until the last part of
aggregation. In other words, I can do this again and again,

Knut

On Thu, May 10, 2018 at 6:19 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

> 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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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.WrapperConnectionPoolDataSourc
>> e.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
>>         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSourc
>> e.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
>>
>


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype:     knutstar

Follow ups

References