dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #15746
Re: Trouble running Analytics for 2.29
It will most likely be a memory issue which gets exhausted at the same
place each time. The log should be in standard place of
/var/log/postgreswl/ etc. Not really anything to do with tools.
On Thu, 10 May 2018, 22:00 Knut Staring, <knutst@xxxxxxxxx> wrote:
> 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.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
>>>
>>
>
>
> --
> 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