Cluster manager failed to expire XAS instance

0
We have a production application that runs on an AWS environment (Mendix version 8.6.9). Every (about) 6 minutes, we get the following error:   INFO - Core: XAS instance {0df47a9d-744a-4096-ad76-d9196843d072} expired, removing this instance now WARNING - ConnectionBus_Queries: Query executed in 30 seconds and 41 milliseconds: DELETE FROM "system$scheduledeventinformation_xasinstance" WHERE "system$xasinstanceid" = ? ERROR - Core: Cluster manager failed to expire XAS instance '0df47a9d-744a-4096-ad76-d9196843d072', probably caused by a lock or running transaction on the database. ERROR - Core: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while deleting data. (SQL State: 57014, Error Code: 0) at com.mendix.basis.actionmanagement.ActionManagerBase.executeInTransactionSync(ActionManagerBase.java:123) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while deleting data. (SQL State: 57014, Error Code: 0) at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:156) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while deleting data. (SQL State: 57014, Error Code: 0) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while deleting data. (SQL State: 57014, Error Code: 0) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getCorrectException(JdbcDataStore.java:729) Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.doModification(JdbcDataStoreBase.scala:382) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.doDelete(JdbcDataStoreBase.scala:327) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$execDeleteQueries$2(JdbcDataStoreBase.scala:299) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$execDeleteQueries$2$adapted(JdbcDataStoreBase.scala:299) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$execModificationQueries$2(JdbcDataStoreBase.scala:343) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$execModificationQueries$2$adapted(JdbcDataStoreBase.scala:343) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$executeWithUcViolationHandling$2(JdbcDataStoreBase.scala:511) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$executeWithUcViolationHandling$2$adapted(JdbcDataStoreBase.scala:511) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.withPreparedStatement(JdbcDataStoreBase.scala:569) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$execModificationQueries$1(JdbcDataStoreBase.scala:342) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$execModificationQueries$1$adapted(JdbcDataStoreBase.scala:342) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.$anonfun$executeWithUcViolationHandling$1(JdbcDataStoreBase.scala:511) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at scala.util.Try$.apply(Try.scala:213) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.executeWithUcViolationHandling(JdbcDataStoreBase.scala:511) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.doModificationQueries$1(JdbcDataStoreBase.scala:345) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.execModificationQueries(JdbcDataStoreBase.scala:355) at com.mendix.connectionbus.connections.jdbc.JdbcDataStoreBase.execDeleteQueries(JdbcDataStoreBase.scala:299) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.store(JdbcDataStore.java:492) at com.mendix.connectionbus.store.EntityStorer.storeDataSetInstance(EntityStorer.java:249) at com.mendix.connectionbus.store.EntityStorer.handleDeleteRequest(EntityStorer.java:226) at com.mendix.connectionbus.store.EntityStorer.handleRequest(EntityStorer.java:148) at com.mendix.connectionbus.store.EntityStorer.store(EntityStorer.java:70) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:77) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:549) at com.mendix.basis.action.user.DeleteAction.deleteFromDatabase(DeleteAction.scala:86) at com.mendix.basis.action.user.DeleteAction.executeAction(DeleteAction.scala:49) at com.mendix.basis.action.user.DeleteAction.executeAction(DeleteAction.scala:23) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54) at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152) at com.mendix.basis.actionmanagement.ActionManagerBase.executeInTransactionSync(ActionManagerBase.java:116) at com.mendix.basis.component.InternalCoreBase.delete(InternalCoreBase.java:254) at com.mendix.basis.action.system.ClusterLeaderManagementAction.$anonfun$checkXASInstancesTimeout$1(ClusterLeaderManagementAction.scala:79) at scala.Function2.$anonfun$tupled$1(Function2.scala:53) at scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62) at scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55) at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49) at com.mendix.basis.action.system.ClusterLeaderManagementAction.checkXASInstancesTimeout(ClusterLeaderManagementAction.scala:99) at com.mendix.basis.action.system.ClusterLeaderManagementAction.execute(ClusterLeaderManagementAction.scala:42) at com.mendix.basis.action.system.ClusterLeaderManagementAction.execute(ClusterLeaderManagementAction.scala:28) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:49) at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:54) at com.mendix.basis.actionmanagement.ActionManagerBase$1.execute(ActionManagerBase.java:147) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:152) at com.mendix.basis.actionmanagement.SystemScheduledAction.executeScheduledAction(SystemScheduledAction.scala:23) at com.mendix.basis.actionmanagement.ScheduledAction$ScheduledRun.$anonfun$run$1(ScheduledAction.scala:26) at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.basis.actionmanagement.IMonitoredAction.monitor(IMonitoredAction.scala:49) at com.mendix.basis.actionmanagement.IMonitoredAction.monitor$(IMonitoredAction.scala:25) at com.mendix.basis.actionmanagement.ScheduledAction$ScheduledRun.monitor(ScheduledAction.scala:14) at com.mendix.basis.actionmanagement.ScheduledAction$ScheduledRun.run(ScheduledAction.scala:26) at com.mendix.basis.actionmanagement.ScheduledAction.execute(ScheduledAction.scala:67) at com.mendix.basis.actionmanagement.ScheduledAction.run(ScheduledAction.scala:47) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) 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)   Does anyone know how to resolve this issue? Many thanks!
asked
0 answers