2019-09-27T12:43:07,975|ERROR||||0000000000|main|SqlExceptionHelper - ERROR: relation "sysclans" does not exist Position: 196 2019-09-27T12:43:09,455|INFO ||||0000000000|main|HibConfigurationHelper - JDBC driver name: PostgreSQL JDBC Driver 2019-09-27T12:43:09,456|INFO ||||0000000000|main|HibConfigurationHelper - JDBC driver version: 42.2.5 2019-09-27T12:43:09,456|INFO ||||0000000000|main|HibConfigurationHelper - database product name: PostgreSQL 2019-09-27T12:43:09,456|INFO ||||0000000000|main|HibConfigurationHelper - database product version: 11.0 2019-09-27T12:43:09,457|INFO ||||0000000000|main|HibConfigurationHelper - Hibernate version: 5.3.7.Final 2019-09-27T14:42:03,789|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver name: PostgreSQL JDBC Driver 2019-09-27T14:42:03,790|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver version: 42.2.5 2019-09-27T14:42:03,790|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product name: PostgreSQL 2019-09-27T14:42:03,790|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product version: 11.0 2019-09-27T14:42:03,791|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - Hibernate version: 5.3.7.Final 2019-09-27T14:43:51,909|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-09-27T14:43:51,910|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:ardb:internalClanId=1) 2019-09-27T14:43:53,618|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:ardb:internalClanId=1) 2019-09-27T14:43:53,618|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-09-27T14:43:54,769|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-09-27T14:43:54,769|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:alsdb:internalClanId=2) 2019-09-27T14:43:55,344|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:alsdb:internalClanId=2) 2019-09-27T14:43:55,344|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-09-27T16:02:19,795|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver name: PostgreSQL JDBC Driver 2019-09-27T16:02:19,807|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver version: 42.2.5 2019-09-27T16:02:19,807|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product name: PostgreSQL 2019-09-27T16:02:19,808|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product version: 11.0 2019-09-27T16:02:19,808|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - Hibernate version: 5.3.7.Final 2019-09-27T16:04:08,163|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-09-27T16:04:08,174|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:ardb:internalClanId=1) 2019-09-27T16:04:11,819|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:ardb:internalClanId=1) 2019-09-27T16:04:11,819|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-09-27T16:04:13,752|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-09-27T16:04:13,752|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:alsdb:internalClanId=2) 2019-09-27T16:04:15,044|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:alsdb:internalClanId=2) 2019-09-27T16:04:15,044|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-09-27T17:40:02,800|WARN |abs0000000000|default|OwKLx3_Nyw|0000000254|Tomcat-ajp-17|HibReplayer - Starting replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000 2019-09-27T17:40:02,832|WARN |abs0000000000|default|OwKLx3_Nyw|0000000254|Tomcat-ajp-17|HibReplayer - Finished replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000replayPacketsCnt=2 obliteratPacktsCnt=0 2019-09-27T17:40:02,918|WARN |abs0000000000|default|OwKLx3_Nyw|0000000253|Tomcat-ajp-13|HibReplayer - Starting replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000 2019-09-27T17:40:02,925|WARN |abs0000000000|default|OwKLx3_Nyw|0000000253|Tomcat-ajp-13|HibReplayer - Finished replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000replayPacketsCnt=2 obliteratPacktsCnt=0 2019-11-01T12:07:13,701|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver name: PostgreSQL JDBC Driver 2019-11-01T12:07:13,712|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver version: 42.2.5 2019-11-01T12:07:13,712|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product name: PostgreSQL 2019-11-01T12:07:13,712|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product version: 11.0 2019-11-01T12:07:13,712|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - Hibernate version: 5.3.7.Final 2019-11-01T12:09:13,371|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-11-01T12:09:13,372|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:ardb:internalClanId=1) 2019-11-01T12:09:17,007|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:ardb:internalClanId=1) 2019-11-01T12:09:17,007|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-11-01T12:09:18,877|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-11-01T12:09:18,877|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:alsdb:internalClanId=2) 2019-11-01T12:09:20,875|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:alsdb:internalClanId=2) 2019-11-01T12:09:20,875|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-11-01T12:30:38,499|WARN |abs0000000000|default|YPND4PZcti|0000000049|Tomcat-ajp-16|HibReplayer - Starting replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000 2019-11-01T12:30:38,561|WARN |abs0000000000|default|YPND4PZcti|0000000049|Tomcat-ajp-16|HibReplayer - Finished replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000replayPacketsCnt=2 obliteratPacktsCnt=0 2019-11-01T12:30:38,651|WARN |abs0000000000|default|YPND4PZcti|0000000050|Tomcat-ajp-20|HibReplayer - Starting replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000 2019-11-01T12:30:38,667|WARN |abs0000000000|default|YPND4PZcti|0000000050|Tomcat-ajp-20|HibReplayer - Finished replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000replayPacketsCnt=2 obliteratPacktsCnt=0 2019-11-07T11:06:03,225|WARN |abs0000000000|||0000000000|MutationSessionCleaner-cleanUp-0|SchemaBasedMultiTenantConnectionProviderImpl$Retryable - retryable action failed. will keep on trying (0/3000) org.postgresql.util.PSQLException: FATAL: the database system is shutting down at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.jdbc.PgConnection.(PgConnection.java:195) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.Driver.makeConnection(Driver.java:454) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.Driver.connect(Driver.java:256) ~[postgresql-42.2.5.jar!/:42.2.5] at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.PooledConnection.reconnect(PooledConnection.java:372) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:822) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:652) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$ConnectionProviderSelector$1.getConnection(SchemaBasedMultiTenantConnectionProviderImpl.java:60) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$Retryable.runWithRetry(SchemaBasedMultiTenantConnectionProviderImpl.java:487) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$Retryable.runWithRetry(SchemaBasedMultiTenantConnectionProviderImpl.java:479) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl.getConnection(SchemaBasedMultiTenantConnectionProviderImpl.java:357) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at org.hibernate.internal.ContextualJdbcConnectionAccess.obtainConnection(ContextualJdbcConnectionAccess.java:43) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1984) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1914) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:937) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doList(Loader.java:2689) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doList(Loader.java:2672) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.list(Loader.java:2501) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.internal.StatelessSessionImpl.list(StatelessSessionImpl.java:472) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at com.sag.aris.cip.impl.hib.MutationSessionCleaner.getOverDueMutationSessions(MutationSessionCleaner.java:145) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.MutationSessionCleaner.cleanUpMutationSessions(MutationSessionCleaner.java:75) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.MutationSessionCleaner.lambda$startCleanUpLoop$0(MutationSessionCleaner.java:54) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_202] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] 2019-11-07T11:06:08,173|ERROR|abs0000000000|||0000000000|MutationSessionCleaner-cleanUp-0|MutationSessionCleaner - could not clean up mutation sessions for tenant default com.sag.aris.cip.api.CipException: could not get a db connection at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl.getConnection(SchemaBasedMultiTenantConnectionProviderImpl.java:365) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at org.hibernate.internal.ContextualJdbcConnectionAccess.obtainConnection(ContextualJdbcConnectionAccess.java:43) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1984) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1914) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:937) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doList(Loader.java:2689) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doList(Loader.java:2672) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.list(Loader.java:2501) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.internal.StatelessSessionImpl.list(StatelessSessionImpl.java:472) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at com.sag.aris.cip.impl.hib.MutationSessionCleaner.getOverDueMutationSessions(MutationSessionCleaner.java:145) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.MutationSessionCleaner.cleanUpMutationSessions(MutationSessionCleaner.java:75) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.MutationSessionCleaner.lambda$startCleanUpLoop$0(MutationSessionCleaner.java:54) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_202] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] Caused by: java.lang.InterruptedException: sleep interrupted at java.lang.Thread.sleep(Native Method) ~[?:1.8.0_202] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$Retryable.runWithRetry(SchemaBasedMultiTenantConnectionProviderImpl.java:501) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$Retryable.runWithRetry(SchemaBasedMultiTenantConnectionProviderImpl.java:479) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl.getConnection(SchemaBasedMultiTenantConnectionProviderImpl.java:357) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] ... 32 more 2019-11-07T11:32:25,830|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver name: PostgreSQL JDBC Driver 2019-11-07T11:32:25,848|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver version: 42.2.5 2019-11-07T11:32:25,848|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product name: PostgreSQL 2019-11-07T11:32:25,848|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product version: 11.0 2019-11-07T11:32:25,848|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - Hibernate version: 5.3.7.Final 2019-11-07T11:34:22,432|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-11-07T11:34:22,450|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:ardb:internalClanId=1) 2019-11-07T11:34:27,069|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:ardb:internalClanId=1) 2019-11-07T11:34:27,069|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-11-07T11:34:30,435|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-11-07T11:34:30,435|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:alsdb:internalClanId=2) 2019-11-07T11:34:32,048|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:alsdb:internalClanId=2) 2019-11-07T11:34:32,048|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-11-07T11:41:36,386|WARN |abs0000000000|default|4WXI7yJ7RU|0000000019|Tomcat-ajp-10|HibReplayer - Starting replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000 2019-11-07T11:41:36,440|WARN |abs0000000000|default|4WXI7yJ7RU|0000000019|Tomcat-ajp-10|HibReplayer - Finished replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000replayPacketsCnt=2 obliteratPacktsCnt=0 2019-11-07T11:41:36,494|WARN |abs0000000000|default|4WXI7yJ7RU|0000000017|Tomcat-ajp-15|HibReplayer - Starting replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000 2019-11-07T11:41:36,519|WARN |abs0000000000|default|4WXI7yJ7RU|0000000017|Tomcat-ajp-15|HibReplayer - Finished replay for (?:aris:internalClanId=12) on tenant default @CloudSearchID=CS#rs0000000000replayPacketsCnt=2 obliteratPacktsCnt=0 2019-11-14T15:15:36,378|WARN |abs0000000000|||0000000000|reportscheduler-1|SchemaBasedMultiTenantConnectionProviderImpl$Retryable - retryable action failed. will keep on trying (0/3000) org.postgresql.util.PSQLException: Connection to Yiannis-TOSH.lan:14240 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:280) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.jdbc.PgConnection.(PgConnection.java:195) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.Driver.makeConnection(Driver.java:454) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.Driver.connect(Driver.java:256) ~[postgresql-42.2.5.jar!/:42.2.5] at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:319) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.PooledConnection.reconnect(PooledConnection.java:372) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:822) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:652) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) ~[tomcat-jdbc-8.5.32.jar!/:?] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$ConnectionProviderSelector$1.getConnection(SchemaBasedMultiTenantConnectionProviderImpl.java:60) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$Retryable.runWithRetry(SchemaBasedMultiTenantConnectionProviderImpl.java:487) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl$Retryable.runWithRetry(SchemaBasedMultiTenantConnectionProviderImpl.java:479) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.hibernate.SchemaBasedMultiTenantConnectionProviderImpl.getConnection(SchemaBasedMultiTenantConnectionProviderImpl.java:357) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at org.hibernate.internal.ContextualJdbcConnectionAccess.obtainConnection(ContextualJdbcConnectionAccess.java:43) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1984) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1914) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:937) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doList(Loader.java:2689) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.doList(Loader.java:2672) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.Loader.list(Loader.java:2501) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.internal.StatelessSessionImpl.list(StatelessSessionImpl.java:472) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505) ~[hibernate-core-5.3.7.Final.jar!/:5.3.7.Final] at com.sag.aris.cip.impl.hib.hibernate.HibQueryExecutor.executeQuery(HibQueryExecutor.java:30) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.HibClanInfoProvider.getClanInfo(HibClanInfoProvider.java:84) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.HibDataReader.search(HibDataReader.java:719) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.sag.aris.cip.impl.hib.RSQuery.execute(RSQuery.java:30) ~[y-cip-impl-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.dao.arissystemdb.scriptservice.impl.cipbased.AScriptServiceDAO.getCategory(AScriptServiceDAO.java:83) ~[y-aris-server-dao-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.dao.arissystemdb.scriptservice.impl.cipbased.aspects.AClanCreationScriptServiceDAO.lambda$getCategory$4(AClanCreationScriptServiceDAO.java:46) ~[y-aris-server-dao-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.dao.AClanCreationAspectBase.safeCall(AClanCreationAspectBase.java:68) [y-aris-server-dao-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.dao.arissystemdb.impl.cipbased.aspects.AClanCreationBaseDAO.safeCall(AClanCreationBaseDAO.java:28) [y-aris-server-dao-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.dao.arissystemdb.scriptservice.impl.cipbased.aspects.AClanCreationScriptServiceDAO.getCategory(AClanCreationScriptServiceDAO.java:46) [y-aris-server-dao-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.services.scriptservice.impl.ASchedulerScriptHandler.getOrCreateCategory(ASchedulerScriptHandler.java:44) [y-aris-server-services-core-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.services.scriptservice.impl.AScriptServiceSchedulerOperations.getAdministrativeFile(AScriptServiceSchedulerOperations.java:374) [y-aris-server-services-core-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.bl.components.reportscheduler.AReportSchedulerBLComponent.getAdministrativeFile(AReportSchedulerBLComponent.java:247) [y-aris-server-bl-core-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.bl.components.reportscheduler.logic.AConcurrentScheduler.checkDeletedTasks(AConcurrentScheduler.java:470) [y-aris-server-bl-core-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.bl.components.reportscheduler.logic.AConcurrentScheduler.access$800(AConcurrentScheduler.java:31) [y-aris-server-bl-core-10.0.9.0.jar!/:10.0.9.0.1310439] at com.aris.modeling.server.bl.components.reportscheduler.logic.AConcurrentScheduler$CheckForSchedulerServerInstance.run(AConcurrentScheduler.java:221) [y-aris-server-bl-core-10.0.9.0.jar!/:10.0.9.0.1310439] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_202] at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_202] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_202] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_202] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202] Caused by: java.net.ConnectException: Connection refused: connect at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) ~[?:1.8.0_202] at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85) ~[?:1.8.0_202] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0_202] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_202] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_202] at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) ~[?:1.8.0_202] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_202] at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0_202] at org.postgresql.core.PGStream.(PGStream.java:70) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91) ~[postgresql-42.2.5.jar!/:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192) ~[postgresql-42.2.5.jar!/:42.2.5] ... 60 more 2019-11-14T15:23:39,933|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver name: PostgreSQL JDBC Driver 2019-11-14T15:23:39,934|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - JDBC driver version: 42.2.5 2019-11-14T15:23:39,934|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product name: PostgreSQL 2019-11-14T15:23:39,935|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - database product version: 11.0 2019-11-14T15:23:39,935|INFO |abs0000000000|||0000000000|main|HibConfigurationHelper - Hibernate version: 5.3.7.Final 2019-11-14T15:25:32,089|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-11-14T15:25:32,090|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:ardb:internalClanId=1) 2019-11-14T15:25:34,277|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:ardb:internalClanId=1) 2019-11-14T15:25:34,277|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:ardb:internalClanId=1) on tenant default @CloudSearchID=rs0000000000 2019-11-14T15:25:36,464|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000 2019-11-14T15:25:36,464|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Starting reindex of (?:alsdb:internalClanId=2) 2019-11-14T15:25:37,282|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished reindex of (?:alsdb:internalClanId=2) 2019-11-14T15:25:37,282|WARN |abs0000000000|default||0000000000|leader-DbSessionCleaner|ReindexSingleCloudSearchOperation - Finished single cloudsearch reindex of (?:alsdb:internalClanId=2) on tenant default @CloudSearchID=rs0000000000