com.mendix.core.CoreRuntimeException: Failed to commit how to proceed ?
0
We encountered the following error when initializing data using Mendix external DataMonnector to connect MS SQL SERVER 2019. ERROR - ConnectionBus: Error on set transaction mode off. (conn=160471) Connection is closedcom.mendix.core.CoreRuntimeException: Failed to commit at com.mendix.basis.component.TransactionCore.doCommit(TransactionCore.scala:164)Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"before":[{}],"action":{"type":"CommitAction"},"after":[],"type":"EventExtendedAction"}', 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 '{"before":[{}],"action":{"type":"CommitAction"},"after":[],"type":"EventExtendedAction"}', 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 '{"before":[{}],"action":{"type":"CommitAction"},"after":[],"type":"EventExtendedAction"}', all database changes executed by this action were rolled back at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.processErrorState(CoreActionHandlerImpl.scala:153)Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while updating data. (SQL State: 08000, Error Code: 1220) at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.scala:30)Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while updating data. (SQL State: 08000, Error Code: 1220) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:109)Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while updating data. (SQL State: 08000, Error Code: 1220) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23)Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while updating data. (SQL State: 08000, Error Code: 1220) at com.mendix.connectionbus.util.SqlExceptionUtils$.getDetailedException(SqlExceptionUtils.scala:18)Caused by: java.sql.SQLNonTransientConnectionException: (conn=160471) Connection is closed at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:300) at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:378) at org.mariadb.jdbc.Connection.checkNotClosed(Connection.java:698) at org.mariadb.jdbc.Connection.prepareInternal(Connection.java:160) at org.mariadb.jdbc.Connection.prepareStatement(Connection.java:134) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713) at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:713) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.withPreparedStatement(JdbcDataStore.scala:1104) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$execModificationQueries$1(JdbcDataStore.scala:873) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$execModificationQueries$1$adapted(JdbcDataStore.scala:873) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$executeWithUcViolationHandling$1(JdbcDataStore.scala:1040) at scala.runtime.java8.JFunction0$mcZ$sp.apply(JFunction0$mcZ$sp.scala:17) at scala.util.Try$.apply(Try.scala:217) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.executeWithUcViolationHandling(JdbcDataStore.scala:1040) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.doModificationQueries$1(JdbcDataStore.scala:876) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$execModificationQueries$3(JdbcDataStore.scala:879) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.executeWithRetry(JdbcDataStore.scala:898) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execModificationQueries(JdbcDataStore.scala:879) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execUpdateQueries(JdbcDataStore.scala:805) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$store$1(JdbcDataStore.scala:365) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.$anonfun$store$1$adapted(JdbcDataStore.scala:362) at scala.collection.immutable.List.map(List.scala:247) at scala.collection.immutable.List.map(List.scala:79) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.store(JdbcDataStore.scala:362) at com.mendix.connectionbus.store.EntityStorer.storeDataSetInstance(EntityStorer.scala:178) at com.mendix.connectionbus.store.EntityStorer.handleUpdateRequest(EntityStorer.scala:154) at com.mendix.connectionbus.store.EntityStorer.handleRequest(EntityStorer.scala:115) at com.mendix.connectionbus.store.EntityStorer.store(EntityStorer.scala:40) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:45) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.scala:473) at com.mendix.basis.action.user.CommitAction.commit(CommitAction.scala:155) at com.mendix.basis.action.user.CommitAction.$anonfun$commitPersistableObjects$5(CommitAction.scala:113) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18) at scala.util.Try$.apply(Try.scala:217) at com.mendix.basis.action.user.CommitAction.commitPersistableObjects(CommitAction.scala:113) at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:59) at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:31) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:105) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:104) at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.scala:27) at com.mendix.basis.actionmanagement.EventExtendedAction.execute(EventExtendedAction.scala:60) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:46) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:106) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:104) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeInTransactionSync$1(ActionManager.scala:116) at scala.util.Try$.apply(Try.scala:217) at com.mendix.basis.actionmanagement.ActionManager.executeInTransactionSync(ActionManager.scala:116) at com.mendix.basis.component.TransactionCore.doStore$1(TransactionCore.scala:206) at com.mendix.basis.component.TransactionCore.storeObjectsAndAutoCommittedObjects(TransactionCore.scala:214) at com.mendix.basis.component.TransactionCore.doCommit(TransactionCore.scala:143) at com.mendix.basis.component.TransactionCore.commit(TransactionCore.scala:116) at com.mendix.basis.component.TransactionCore.commit$(TransactionCore.scala:110) at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:24) at com.mendix.basis.component.TransactionCore.commitWithEvents(TransactionCore.scala:66) at com.mendix.basis.component.TransactionCore.commit(TransactionCore.scala:25) at com.mendix.basis.component.TransactionCore.commit$(TransactionCore.scala:24) at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:24) at com.mendix.basis.component.TransactionCore.commit(TransactionCore.scala:20) at com.mendix.basis.component.TransactionCore.commit$(TransactionCore.scala:20) at com.mendix.basis.component.InternalCore.commit(InternalCore.scala:24) at com.mendix.webui.actions.client.AsyncActionResultStore.$anonfun$runWithStore$1(StoredAsyncActionRunner.scala:136) at scala.util.Success.foreach(Try.scala:268) at scala.concurrent.impl.Promise$Transformation.run(Promise.scala:481) at java.base/java.util.concurrent.ForkJoinTask$RunnableExecuteAction.exec(ForkJoinTask.java:1426) at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183)INFO: MENDIX-LOGGING-HEARTBEAT: Heartbeat number 2INFO: MENDIX-LOGGING-HEARTBEAT: Heartbeat number 3WARNING - org.mariadb.jdbc.message.server.ErrorPacket: Error: 1213-40001: Deadlock found when trying to get lock; try restarting transactionWARNING - org.mariadb.jdbc.message.server.ErrorPacket: Error: 1305-42000: SAVEPOINT _jid_4 does not existWARNING - TaskQueue: Cannot move task 'ClusterManagement-MigrateOldFiles()' from task queue 'System.ScheduledEventsQueue' with id 33495522327695604 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=162104) SAVEPOINT _jid_4 does not exist at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.rollbackSavepoint(TransactionConnectionManagerAction.scala:108) Caused by: java.sql.SQLSyntaxErrorException: (conn=162104) SAVEPOINT _jid_4 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.client.impl.StandardClient.readResponse(StandardClient.java:1092) at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:1016) at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:872) at org.mariadb.jdbc.Connection.rollback(Connection.java:594) at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:808) at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:808) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.$anonfun$rollbackSavepoint$1(TransactionConnectionManagerAction.scala:104) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.$anonfun$rollbackSavepoint$1$adapted(TransactionConnectionManagerAction.scala:104) at scala.Option.foreach(Option.scala:437) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManagerAction.rollbackSavepoint(TransactionConnectionManagerAction.scala:104) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.$anonfun$rollbackSavepoint$1(TransactionConnectionManager.scala:62) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.$anonfun$rollbackSavepoint$1$adapted(TransactionConnectionManager.scala:62) at scala.Option.foreach(Option.scala:437) at com.mendix.connectionbus.connections.jdbc.TransactionConnectionManager.rollbackSavepoint(TransactionConnectionManager.scala:62) at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.rollbackSavepoint(JdbcDataStore.scala:555) at com.mendix.connectionbus.ConnectionBusImpl.rollbackSavepoint(ConnectionBusImpl.scala:570) at com.mendix.basis.action.RequestScope.popSavepointForRollback(RequestScope.scala:219) at com.mendix.basis.action.RequestScope.$anonfun$rollbackTransaction$1(RequestScope.scala:137) at com.mendix.basis.action.RequestScope.$anonfun$rollbackTransaction$1$adapted(RequestScope.scala:136) at scala.Option.foreach(Option.scala:437) at com.mendix.basis.action.RequestScope.rollbackTransaction(RequestScope.scala:136) at com.mendix.basis.action.ContextImpl.rollbackTransaction(ContextImpl.scala:75) at com.mendix.basis.action.user.DeleteAction.executeAction(DeleteAction.scala:94) at com.mendix.basis.action.user.DeleteAction.executeAction(DeleteAction.scala:34) at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.$anonfun$runMonitoredAction$1(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:52) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:52) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.runMonitoredAction(CoreActionHandlerImpl.scala:59) at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:46) at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:57) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:105) at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20) at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:104) at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeInTransactionSync$1(ActionManager.scala:116) at scala.util.Try$.apply(Try.scala:217) at com.mendix.basis.actionmanagement.ActionManager.executeInTransactionSync(ActionManager.scala:116) at com.mendix.basis.component.ObjectManagementCore.$anonfun$deleteVarargs$3(ObjectManagementCore.scala:59) at com.mendix.basis.component.ObjectManagementCore.$anonfun$deleteVarargs$3$adapted(ObjectManagementCore.scala:58) at scala.collection.LinearSeqOps.foldLeft(LinearSeq.scala:183) at scala.collection.LinearSeqOps.foldLeft$(LinearSeq.scala:179) at scala.collection.immutable.List.foldLeft(List.scala:79) at com.mendix.basis.component.ObjectManagementCore.deleteVarargs(ObjectManagementCore.scala:58) at com.mendix.basis.component.ObjectManagementCore.deleteVarargs(ObjectManagementCore.scala:49) at com.mendix.basis.component.ObjectManagementCore.deleteVarargs$(ObjectManagementCore.scala:48) at com.mendix.basis.component.InternalCore.deleteVarargs(InternalCore.scala:24) at com.mendix.basis.component.InternalCoreVarargs.delete(InternalCoreVarargs.java:22) at com.mendix.modules.queue.TaskQueue.$anonfun$moveToProcessedTasks$2(TaskQueue.scala:376) at scala.runtime.java8.JFunction0$mcZ$sp.apply(JFunction0$mcZ$sp.scala:17) at scala.util.Try$.apply(Try.scala:217) at com.mendix.modules.queue.TaskQueue.$anonfun$moveToProcessedTasks$1(TaskQueue.scala:376) at scala.util.Success.flatMap(Try.scala:266) at com.mendix.modules.queue.TaskQueue.moveToProcessedTasks(TaskQueue.scala:375) at com.mendix.modules.queue.TaskQueue.$anonfun$doRemove$2(TaskQueue.scala:205) at scala.util.Success.flatMap(Try.scala:266) at com.mendix.modules.queue.TaskQueue.$anonfun$doRemove$1(TaskQueue.scala:205) at com.mendix.util.ContextUtil$RichContext$.withTransaction$extension(ContextUtil.scala:17) at com.mendix.modules.queue.TaskQueue.doRemove(TaskQueue.scala:205) at com.mendix.modules.queue.TaskQueue.tryRemove$1(TaskQueue.scala:178) at com.mendix.modules.queue.TaskQueue.remove(TaskQueue.scala:190) at com.mendix.modules.queue.TaskDispatcher.executeTask(TaskDispatcher.scala:238) at com.mendix.modules.queue.TaskDispatcher.$anonfun$dispatchTask$2(TaskDispatcher.scala:212) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18) at com.mendix.modules.queue.MendixTaskQueueMetrics$QueueBasedMetricsImpl.$anonfun$timeTaskExecution$1(TaskQueueMetrics.scala:44) at io.micrometer.core.instrument.composite.CompositeTimer.record(CompositeTimer.java:69) at com.mendix.metrics.micrometer.MicrometerTimer.record(MicrometerTimer.scala:29) at com.mendix.modules.queue.MendixTaskQueueMetrics$QueueBasedMetricsImpl.timeTaskExecution(TaskQueueMetrics.scala:44) at com.mendix.modules.queue.TaskDispatcher.$anonfun$dispatchTask$1(TaskDispatcher.scala:212) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)