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, <knu...@gmail.com> 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 <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.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@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
