0

Hi all; Sometime I got issue , I couldn’t use my application, it will be auto refresh when I click link or button action . In my application log I got messages as logs below How can I fix? Maybe I re-deploy . It’s ok sometimes it can’t work for re-deploy.   INFO - Core: Configured storage service started. 2021/07/15 15:27:49 [error] 13#0: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 10.201.0.1, server: _, request: "POST /xas/ HTTP/1.1", upstream: "http://127.0.0.1:8081/xas/", host: "myhost.com", referrer: "http://myhost.com/index.html" 2021/07/15 15:27:52 [error] 13#0: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 10.201.0.1, server: _, request: "POST /xas/ HTTP/1.1", upstream: "http://127.0.0.1:8081/xas/", host: "myhost.com", referrer: "http://myhost.com/login.html" 2021/07/15 15:28:34 [error] 13#0: *4 connect() failed (111: Connection refused) while connecting to upstream, client: 10.201.0.1, server: _, request: "GET /login.html HTTP/1.1", upstream: "http://127.0.0.1:8081/login.html", host: "myhost.com" 2021/07/15 15:29:03 [error] 13#0: *6 connect() failed (111: Connection refused) while connecting to upstream, client: 10.201.0.1, server: _, request: "GET /login.html HTTP/1.1", upstream: "http://127.0.0.1:8081/login.html", host: "myhost.com", referrer: "http://myhost.com/index.html" 2021/07/15 15:29:04 [error] 13#0: *6 connect() failed (111: Connection refused) while connecting to upstream, client: 10.201.0.1, server: _, request: "GET /login.html HTTP/1.1", upstream: "http://127.0.0.1:8081/login.html", host: "myhost.com", referrer: "http://myhost.com/index.html" 2021/07/15 15:29:05 [error] 13#0: *6 connect() failed (111: Connection refused) while connecting to upstream, client: 10.201.0.1, server: _, request: "GET /login.html HTTP/1.1", upstream: "http://127.0.0.1:8081/login.html", host: "myhost.com", referrer: "http://myhost.com/index.html" 2021/07/15 15:29:05 [error] 13#0: *6 connect() failed (111: Connection refused) while connecting to upstream, client: 10.201.0.1, server: _, request: "GET /login.html HTTP/1.1", upstream: "http://127.0.0.1:8081/login.html", host: "myhost.com", referrer: "http://myhost.com/index.html" INFO - Core: Initializing license... WARNING - Core: The runtime has been started using a trial license, the framework will be terminated when the maximum time is exceeded! INFO - Core: Initialized license. Jul 15, 2021 3:29:11 PM java.util.prefs.FileSystemPreferences$6 run WARNING: Prefs file removed in background /opt/mendix/build/.java/.userPrefs/com/mendix/core/prefs.xml INFO - TaskQueue: Initializing task queue manager with configuration: System.MendixWorkflows-WorkflowExecution(e8867968-3948-4226-91f8-565901e316b2) -> parallelism: 5, System.MendixWorkflows-DefaultTaskExecution(48443286-dadf-4505-b42c-ffa7fcf22cef) -> parallelism: 3. INFO - TaskQueue: Initializing task queue 'System.MendixWorkflows-WorkflowExecution'. INFO - TaskQueue: Initializing task queue 'System.MendixWorkflows-DefaultTaskExecution'. INFO - Workflow Engine: Initializing Workflow Engine... INFO - Workflow Engine: Workflow Engine is initialized. INFO - ActionManager: Scheduling CBOMxDocumentary.Evt_PurgeTempData every 1 day, starting from 2021-05-29 00:00:00 (SERVER) INFO - ActionManager: Scheduling EmailTemplate.SendQueuedEmails every 1 minute, starting from 2015-04-10 00:00:00 (UTC) INFO - ActionManager: Scheduling MendixSSO.SE_CleanupAuthRequest every 1 hour, starting from 2018-11-01 00:00:00 (UTC) INFO - ActionManager: Scheduling DeepLink.CleanUp every 1 day, starting from 2010-04-20 00:00:00 (UTC) INFO - ActionManager: Scheduling CBOWFEngine.SCH_CallDelegation_ChangeStatus every 1 day, starting from 2021-03-18 01:00:00 (SERVER) INFO - ActionManager: Scheduling EmailTemplate.Cleanup every 1 week, starting from 2015-04-10 01:00:00 (UTC) INFO - ActionManager: Scheduling CBOWF_Utils.SCH_Overdue every 30 seconds, starting from 2020-04-08 09:28:14 (SERVER) INFO - ActionManager: Scheduling MendixSSO.DeleteExpiredTokens every 1 hour, starting from 2019-01-01 00:00:00 (UTC) INFO - Core: Mendix Runtime successfully started, the application is now available. INFO: The Mendix runtime has been fully started INFO: Ensuring admin user credentials WARNING - ConnectionBus: Database connections: 3 active, 2 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) WARNING - ConnectionBus: Database connections: 3 active, 2 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) WARNING - ConnectionBus: Database connections: 3 active, 2 idle. WARNING - ConnectionBus: Database connections: 3 active, 2 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) WARNING - ConnectionBus: Database connections: 3 active, 2 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(2/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(2/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(2/4) ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(2/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) WARNING - ConnectionBus_Queries: Query executed in 11 seconds and 707 milliseconds: SELECT "system$queuedtask"."id", "system$queuedtask"."status", "system$queuedtask"."microflowname", "system$queuedtask"."useractionname", "system$queuedtask"."started", "system$queuedtask"."xasid", "system$queuedtask"."threadid", "system$queuedtask"."retried", "system$queuedtask"."arguments", "system$queuedtask"."queueid", "system$queuedtask"."sequence", "system$queuedtask"."queuename", "system$queuedtask"."created" FROM "system$queuedtask" WHERE "system$queuedtask"."queueid" = ? AND "system$queuedtask"."status" = ? AND "system$queuedtask"."threadid" IS NULL ORDER BY "system$queuedtask"."sequence" ASC, "system$queuedtask"."id" ASC LIMIT ? FOR UPDATE SKIP LOCKED WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(2/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(3/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(3/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(3/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(3/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(3/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out., giving up...(4/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out., giving up...(4/4) WARNING - ConnectionBus: Database connections: 5 active, 0 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out., giving up...(4/4) WARNING - ConnectionBus_Queries: Query executed in 15 seconds and 726 milliseconds: SELECT "atj1System$grantableRoles"."system$userroleid1" AS "parent", "atj1System$grantableRoles"."system$userroleid2" AS "child" FROM "system$grantableroles" "atj1System$grantableRoles" WHERE "atj1System$grantableRoles"."system$userroleid1" = 34339947158700033 ERROR - TaskQueue: Failed to retrieve next task from queue 'task queue 'System.MendixWorkflows-DefaultTaskExecution'': An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] ERROR - TaskQueue: com.mendix.basis.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:54) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 08001, Error Code: 0) at com.mendix.connectionbus.util.SqlExceptionUtils$.getDetailedException(SqlExceptionUtils.scala:25) Caused by: org.postgresql.util.PSQLException: Connection attempt timed out. at org.postgresql.Driver$ConnectThread.getResult(Driver.java:429) at org.postgresql.Driver.connect(Driver.java:271) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:103) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:87) at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:83) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.getConnection(TransactionConnectionManagerAction.java:88) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.getConnection(TransactionConnectionManager.java:51) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getConnection(JdbcDataStore.java:447) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.java:149) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:123) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueriesForLocal(QueryRequestExecutor.scala:102) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueries(QueryRequestExecutor.scala:34) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.execute(QueryRequestExecutor.scala:26) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$processOqlGetRequest$1(DataStoreCaller.scala:45) at scala.Option.map(Option.scala:242) at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:42) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:35) at scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:117) at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:104) at scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:33) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:65) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:49) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:516) at com.mendix.modules.queue.DistributedQueue.claimTask(DistributedQueue.scala:205) at com.mendix.modules.queue.DistributedQueue.$anonfun$acquire$1(DistributedQueue.scala:90) at com.mendix.logging.impl.LogManager.suppressLogMessagesInThreadBelow(LogManager.java:62) at com.mendix.modules.queue.DistributedQueue.acquire(DistributedQueue.scala:74) at com.mendix.modules.queue.TaskQueueExecutor.acquireTask(TaskQueueExecutor.scala:58) at com.mendix.modules.queue.TaskQueueExecutor.run(TaskQueueExecutor.scala:34) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) WARNING - ConnectionBus_Queries: Query executed in 15 seconds and 770 milliseconds: SELECT "system$queuedtask"."id", "system$queuedtask"."status", "system$queuedtask"."microflowname", "system$queuedtask"."useractionname", "system$queuedtask"."started", "system$queuedtask"."xasid", "system$queuedtask"."threadid", "system$queuedtask"."retried", "system$queuedtask"."arguments", "system$queuedtask"."queueid", "system$queuedtask"."sequence", "system$queuedtask"."queuename", "system$queuedtask"."created" FROM "system$queuedtask" WHERE "system$queuedtask"."queueid" = ? AND "system$queuedtask"."status" = ? AND "system$queuedtask"."threadid" IS NULL ORDER BY "system$queuedtask"."sequence" ASC, "system$queuedtask"."id" ASC LIMIT ? FOR UPDATE SKIP LOCKED ERROR - TaskQueue: Failed to retrieve next task from queue 'task queue 'System.MendixWorkflows-DefaultTaskExecution'': An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] ERROR - TaskQueue: com.mendix.basis.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:54) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 08001, Error Code: 0) at com.mendix.connectionbus.util.SqlExceptionUtils$.getDetailedException(SqlExceptionUtils.scala:25) Caused by: org.postgresql.util.PSQLException: Connection attempt timed out. at org.postgresql.Driver$ConnectThread.getResult(Driver.java:429) at org.postgresql.Driver.connect(Driver.java:271) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:103) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:87) at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:83) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.getConnection(TransactionConnectionManagerAction.java:88) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.getConnection(TransactionConnectionManager.java:51) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getConnection(JdbcDataStore.java:447) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.java:149) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:123) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueriesForLocal(QueryRequestExecutor.scala:102) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueries(QueryRequestExecutor.scala:34) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.execute(QueryRequestExecutor.scala:26) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$processOqlGetRequest$1(DataStoreCaller.scala:45) at scala.Option.map(Option.scala:242) at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:42) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:35) at scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:117) at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:104) at scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:33) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:65) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:49) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:516) at com.mendix.modules.queue.DistributedQueue.claimTask(DistributedQueue.scala:205) at com.mendix.modules.queue.DistributedQueue.$anonfun$acquire$1(DistributedQueue.scala:90) at com.mendix.logging.impl.LogManager.suppressLogMessagesInThreadBelow(LogManager.java:62) at com.mendix.modules.queue.DistributedQueue.acquire(DistributedQueue.scala:74) at com.mendix.modules.queue.TaskQueueExecutor.acquireTask(TaskQueueExecutor.scala:58) at com.mendix.modules.queue.TaskQueueExecutor.run(TaskQueueExecutor.scala:34) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) WARNING - ConnectionBus: Database connections: 3 active, 2 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out., giving up...(4/4) ERROR - TaskQueue: Failed to retrieve next task from queue 'task queue 'System.MendixWorkflows-WorkflowExecution'': An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] ERROR - TaskQueue: com.mendix.basis.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:54) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 08001, Error Code: 0) at com.mendix.connectionbus.util.SqlExceptionUtils$.getDetailedException(SqlExceptionUtils.scala:25) Caused by: org.postgresql.util.PSQLException: Connection attempt timed out. at org.postgresql.Driver$ConnectThread.getResult(Driver.java:429) at org.postgresql.Driver.connect(Driver.java:271) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:103) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:87) at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:83) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.getConnection(TransactionConnectionManagerAction.java:88) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.getConnection(TransactionConnectionManager.java:51) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getConnection(JdbcDataStore.java:447) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.java:149) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:123) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueriesForLocal(QueryRequestExecutor.scala:102) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueries(QueryRequestExecutor.scala:34) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.execute(QueryRequestExecutor.scala:26) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$processOqlGetRequest$1(DataStoreCaller.scala:45) at scala.Option.map(Option.scala:242) at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:42) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:35) at scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:117) at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:104) at scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:33) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:65) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:49) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:516) at com.mendix.modules.queue.DistributedQueue.claimTask(DistributedQueue.scala:205) at com.mendix.modules.queue.DistributedQueue.$anonfun$acquire$1(DistributedQueue.scala:90) at com.mendix.logging.impl.LogManager.suppressLogMessagesInThreadBelow(LogManager.java:62) at com.mendix.modules.queue.DistributedQueue.acquire(DistributedQueue.scala:74) at com.mendix.modules.queue.TaskQueueExecutor.acquireTask(TaskQueueExecutor.scala:58) at com.mendix.modules.queue.TaskQueueExecutor.run(TaskQueueExecutor.scala:34) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) ERROR - TaskQueue: Failed to retrieve next task from queue 'task queue 'System.MendixWorkflows-WorkflowExecution'': An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] ERROR - TaskQueue: com.mendix.basis.connectionbus.ConnectionBusException: An exception has occurred for the following request(s): InternalXPathTextGetRequest (depth = 0, amount = 1): //System.QueuedTask[QueueId=$queueId and Status='Idle' and ThreadId=empty] at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:54) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 08001, Error Code: 0) at com.mendix.connectionbus.util.SqlExceptionUtils$.getDetailedException(SqlExceptionUtils.scala:25) Caused by: org.postgresql.util.PSQLException: Connection attempt timed out. at org.postgresql.Driver$ConnectThread.getResult(Driver.java:429) at org.postgresql.Driver.connect(Driver.java:271) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:103) at org.postgresql.ds.common.BaseDataSource.getConnection(BaseDataSource.java:87) at org.apache.commons.dbcp2.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:83) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431) at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356) at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134) at com.mendix.connectionbus.connections.jdbc.ConnectionManager.getConnection(ConnectionManager.java:49) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.getConnection(TransactionConnectionManagerAction.java:88) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.getConnection(TransactionConnectionManager.java:51) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getConnection(JdbcDataStore.java:447) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execRetrieveQueries(JdbcDataStore.java:149) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.retrieve(JdbcDataStore.java:123) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueriesForLocal(QueryRequestExecutor.scala:102) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.executeQueries(QueryRequestExecutor.scala:34) at com.mendix.connectionbus.retrieve.QueryRequestExecutor.execute(QueryRequestExecutor.scala:26) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$processOqlGetRequest$1(DataStoreCaller.scala:45) at scala.Option.map(Option.scala:242) at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:42) at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:35) at scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:117) at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:104) at scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:35) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:33) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:65) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:49) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:516) at com.mendix.modules.queue.DistributedQueue.claimTask(DistributedQueue.scala:205) at com.mendix.modules.queue.DistributedQueue.$anonfun$acquire$1(DistributedQueue.scala:90) at com.mendix.logging.impl.LogManager.suppressLogMessagesInThreadBelow(LogManager.java:62) at com.mendix.modules.queue.DistributedQueue.acquire(DistributedQueue.scala:74) at com.mendix.modules.queue.TaskQueueExecutor.acquireTask(TaskQueueExecutor.scala:58) at com.mendix.modules.queue.TaskQueueExecutor.run(TaskQueueExecutor.scala:34) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) INFO - ConnectionBus: Successfully reconnected to database. WARNING - ConnectionBus_Queries: Query executed in 22 seconds and 876 milliseconds: SELECT "system$queuedtask"."id", "system$queuedtask"."status", "system$queuedtask"."microflowname", "system$queuedtask"."useractionname", "system$queuedtask"."started", "system$queuedtask"."xasid", "system$queuedtask"."threadid", "system$queuedtask"."retried", "system$queuedtask"."arguments", "system$queuedtask"."queueid", "system$queuedtask"."sequence", "system$queuedtask"."queuename", "system$queuedtask"."created" FROM "system$queuedtask" WHERE "system$queuedtask"."queueid" = ? AND "system$queuedtask"."status" = ? AND "system$queuedtask"."threadid" IS NULL ORDER BY "system$queuedtask"."sequence" ASC, "system$queuedtask"."id" ASC LIMIT ? FOR UPDATE SKIP LOCKED WARNING - ConnectionBus_Queries: Query executed in 22 seconds and 583 milliseconds: SELECT COUNT(DISTINCT "system$filedocument"."id") AS "x1COUNT" FROM "system$filedocument" WHERE "system$filedocument"."size" = ? INFO: Model version: [unversioned] INFO: MENDIX-INTERNAL: Metrics are disabled. INFO: MENDIX-LOGGING-HEARTBEAT: Heartbeat number 1 INFO - Encryption: Encrypted value is EMPTY! INFO - Encryption: Encrypted value is EMPTY! WARNING - ConnectionBus_Queries: Query executed in 12 seconds and 803 milliseconds: SELECT "system$queuedtask"."id", "system$queuedtask"."status", "system$queuedtask"."microflowname", "system$queuedtask"."useractionname", "system$queuedtask"."started", "system$queuedtask"."xasid", "system$queuedtask"."threadid", "system$queuedtask"."retried", "system$queuedtask"."arguments", "system$queuedtask"."queueid", "system$queuedtask"."sequence", "system$queuedtask"."queuename", "system$queuedtask"."created" FROM "system$queuedtask" WHERE "system$queuedtask"."queueid" = ? AND "system$queuedtask"."status" = ? AND "system$queuedtask"."threadid" IS NULL ORDER BY "system$queuedtask"."sequence" ASC, "system$queuedtask"."id" ASC LIMIT ? FOR UPDATE SKIP LOCKED WARNING - ConnectionBus: Database connections: 7 active, 1 idle. ERROR - ConnectionBus: Opening JDBC connection to Some(10.4.105.51:5433) failed with SQLState: 08001 Error code: 0 Message: Connection attempt timed out. Retrying...(1/4) WARNING - ConnectionBus_Queries: Query executed in 12 seconds and 655 milliseconds: SELECT "system$queuedtask"."id", "system$queuedtask"."status", "system$queuedtask"."microflowname", "system$queuedtask"."useractionname", "system$queuedtask"."started", "system$queuedtask"."xasid", "system$queuedtask"."threadid", "system$queuedtask"."retried", "system$queuedtask"."arguments", "system$queuedtask"."queueid", "system$queuedtask"."sequence", "system$queuedtask"."queuename", "system$queuedtask"."created" FROM "system$queuedtask" WHERE "system$queuedtask"."queueid" = ? AND "system$queuedtask"."status" = ? AND "system$queuedtask"."threadid" IS NULL ORDER BY "system$queuedtask"."sequence" ASC, "system$queuedtask"."id" ASC LIMIT ? FOR UPDATE SKIP LOCKED INFO - Encryption: Encrypted value is EMPTY!        

asked 2021-07-15

1 answers