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 <bobjolli...@gmail.com> 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, <knu...@gmail.com> 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@lists.launchpad.net >> 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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
