Unexpected error popup appears

0
Hi Reader,   Application has been deployed on AWS private cloud. We encountered some unexpected error popup for only one time. We tried to regenerate but not able to.  We checked the logs and found there was error in task queue ClusterManagement-CleanupSessions(). Here are the logs:  2025-07-03 02:59:07.112 WARNING - org.mariadb.jdbc.message.server.ErrorPacket: Error: 1213-40001: Deadlock found when trying to get lock; try restarting transaction2025-07-03 02:59:07.119 WARNING - org.mariadb.jdbc.message.server.ErrorPacket: Error: 1305-42000: SAVEPOINT _jid_642 does not exist2025-07-03 02:59:07.141 WARNING - TaskQueue: Cannot move task 'ClusterManagement-CleanupSessions()' from task queue 'System.ScheduledEventsQueue' with id 29836347906600005 to processed tasks log. The status is Running. Starting to retry now.com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"type":"DeleteAction"}', all database changes executed by this action were rolled back        at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:109)   Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"type":"DeleteAction"}', all database changes executed by this action were rolled back        at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23)   Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"type":"DeleteAction"}', all database changes executed by this action were rolled back        at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:153)   Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: java.sql.SQLSyntaxErrorException: (conn=78398) SAVEPOINT _jid_642 does not exist        at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.rollbackSavepoint(TransactionConnectionManagerAction.scala:108)   Caused by: java.sql.SQLSyntaxErrorException: (conn=78398) SAVEPOINT _jid_642 does not exist        at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:289)        at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378)        at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:189)        at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:1234)        at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:1173)        at org.mariadb.jdbc.clien     Please provide some suggestions to resolve this.
asked
2 answers
0

Hi Harsha Raj

These kind of errors occur when your task queue is over loaded or it went to a kind of recursion state.

When this occurs, we need to restart the server.

To avoid this 

1. Check your logic in the task queue whether any scenarios for any tasks would be on the queue permanently. If yes need to rewrite that logic.

2. There are task queue overview and cleanup microflows. Provide a screen to check all the pending tasks and also an action to clean those on MxAdmin page. This will eliminate the need of restart of the server.

 

Regards

Ajay

answered
0

Yes Harsha,

We were facing similar issue in our app. 

We have written custom logic to retrieve all the QueuedTasks from app (entity is System.QueuedTask) and provided actions to clean by deleting those tasks.

 

Alternatively you can use this marketplace module

Mendix Marketplace - Task Queue Helpers

 

Regards

Ajay

answered