Details
-
Bug Report
-
Resolution: Duplicate
-
L3 - Default
-
None
-
7.8.4
-
None
-
Camunda 7.8.4
Wildfly 10
SQL Server 2016 (SNAPSHOT ISOLATION enabled)
Description
I am experiencing database errors when load testing a CMMN model. It works fine when interacting with the model in a single threaded test. However, as soon as I add another thread to the test, I start to experience deadlocks in the database.
Each thread should interact with a single case model. So it is strange to me that this would cause deadlocks given there should be no collisions on individual database rows.
The errors are occurring after triggering the case to re-evaluate the stage sentry criteria by updating the process variables on the case:
caseService.setVariables(caseInstance.getId(), updateVariables);
Camunda version: 7.8.4-ee
Widlfly version: 10
Database: SQL Server 2017 w/ SNAPSHOT ISOLATION enabled
The stack trace is below. This is from an attempt to mitigate by turning off batch mode. But I get similar exceptions with batch mode on and off.
16:32:17,935 ERROR [org.camunda.bpm.engine.context] (default task-4) ENGINE-16004 Exception while closing command context: ENGINE-03004 Exception while executing Database Operation 'DELETE CaseExecutionEntity[0011b94a-74c9-11e8-a375-f8cab804730f]' with message ' ### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. ### The error may involve org.camunda.bpm.engine.impl.cmmn.entity.runtime.CaseExecutionEntity.deleteCaseExecution-Inline ### The error occurred while setting parameters ### SQL: delete from ACT_RU_CASE_EXECUTION where ID_ = ? and REV_ = ? ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.'. Flush summary: [ INSERT ByteArrayEntity[02d6f364-74c9-11e8-a375-f8cab804730f] INSERT VariableInstanceEntity[022e3071-74c9-11e8-a375-f8cab804730f] INSERT VariableInstanceEntity[023905ec-74c9-11e8-a375-f8cab804730f] UPDATE CaseSentryPartEntity[ff552051-74c8-11e8-a375-f8cab804730f] UPDATE CaseSentryPartEntity[ff552053-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[0003af6a-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[000472ca-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[0004e804-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[004c9faa-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[0080f59d-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff4149f9-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff489cff-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff489d01-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff491236-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff49605a-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff49876c-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff50da78-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff526127-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff526129-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff52883b-74c8-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[004c9fa9-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[004c9fad-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[00713e02-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[00713e05-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007ab3fc-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007adb0f-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007eaba2-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007eaba5-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[0080f59c-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[00811cb0-74c9-11e8-a375-f8cab804730f] UPDATE CaseExecutionEntity[ff3737d2-74c8-11e8-a375-f8cab804730f] DELETE CaseExecutionEntity[0011b94a-74c9-11e8-a375-f8cab804730f] DELETE CaseExecutionEntity[ff8fde71-74c8-11e8-a375-f8cab804730f] UPDATE HistoricCaseActivityInstanceEventEntity[0011b94a-74c9-11e8-a375-f8cab804730f] UPDATE HistoricCaseActivityInstanceEventEntity[ff8fde71-74c8-11e8-a375-f8cab804730f] DELETE_BULK deleteAuthorizationsForResourceId {resourceId=0251970d-74c9-11e8-a375-f8cab804730f, resourceType=8} DELETE_BULK deleteAuthorizationsForResourceId {resourceId=025cbaa5-74c9-11e8-a375-f8cab804730f, resourceType=8} DELETE_BULK deleteAuthorizationsForResourceId {resourceId=02a8698d-74c9-11e8-a375-f8cab804730f, resourceType=8} UPDATE HistoricVariableInstanceEntity[004c9faa-74c9-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[0080f59d-74c9-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[ff4149f9-74c8-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[ff491236-74c8-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[ff50da78-74c8-11e8-a375-f8cab804730f] ]: org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation 'DELETE CaseExecutionEntity[0011b94a-74c9-11e8-a375-f8cab804730f]' with message ' ### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. ### The error may involve org.camunda.bpm.engine.impl.cmmn.entity.runtime.CaseExecutionEntity.deleteCaseExecution-Inline ### The error occurred while setting parameters ### SQL: delete from ACT_RU_CASE_EXECUTION where ID_ = ? and REV_ = ? ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.'. Flush summary: [ INSERT ByteArrayEntity[02d6f364-74c9-11e8-a375-f8cab804730f] INSERT VariableInstanceEntity[022e3071-74c9-11e8-a375-f8cab804730f] INSERT VariableInstanceEntity[023905ec-74c9-11e8-a375-f8cab804730f] UPDATE CaseSentryPartEntity[ff552051-74c8-11e8-a375-f8cab804730f] UPDATE CaseSentryPartEntity[ff552053-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[0003af6a-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[000472ca-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[0004e804-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[004c9faa-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[0080f59d-74c9-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff4149f9-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff489cff-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff489d01-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff491236-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff49605a-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff49876c-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff50da78-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff526127-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff526129-74c8-11e8-a375-f8cab804730f] UPDATE VariableInstanceEntity[ff52883b-74c8-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[004c9fa9-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[004c9fad-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[00713e02-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[00713e05-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007ab3fc-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007adb0f-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007eaba2-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[007eaba5-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[0080f59c-74c9-11e8-a375-f8cab804730f] DELETE ByteArrayEntity[00811cb0-74c9-11e8-a375-f8cab804730f] UPDATE CaseExecutionEntity[ff3737d2-74c8-11e8-a375-f8cab804730f] DELETE CaseExecutionEntity[0011b94a-74c9-11e8-a375-f8cab804730f] DELETE CaseExecutionEntity[ff8fde71-74c8-11e8-a375-f8cab804730f] UPDATE HistoricCaseActivityInstanceEventEntity[0011b94a-74c9-11e8-a375-f8cab804730f] UPDATE HistoricCaseActivityInstanceEventEntity[ff8fde71-74c8-11e8-a375-f8cab804730f] DELETE_BULK deleteAuthorizationsForResourceId {resourceId=0251970d-74c9-11e8-a375-f8cab804730f, resourceType=8} DELETE_BULK deleteAuthorizationsForResourceId {resourceId=025cbaa5-74c9-11e8-a375-f8cab804730f, resourceType=8} DELETE_BULK deleteAuthorizationsForResourceId {resourceId=02a8698d-74c9-11e8-a375-f8cab804730f, resourceType=8} UPDATE HistoricVariableInstanceEntity[004c9faa-74c9-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[0080f59d-74c9-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[ff4149f9-74c8-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[ff491236-74c8-11e8-a375-f8cab804730f] UPDATE HistoricVariableInstanceEntity[ff50da78-74c8-11e8-a375-f8cab804730f] ] at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:128) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:338) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:318) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:290) at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:203) at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:132) at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:113) at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:58) at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:66) at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) at org.camunda.bpm.engine.impl.cmmn.CaseExecutionCommandBuilderImpl.executeCommand(CaseExecutionCommandBuilderImpl.java:230) at org.camunda.bpm.engine.impl.cmmn.CaseExecutionCommandBuilderImpl.execute(CaseExecutionCommandBuilderImpl.java:194) at org.camunda.bpm.engine.impl.cmmn.CaseServiceImpl.setVariables(CaseServiceImpl.java:165) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.jboss.weld.bean.proxy.AbstractBeanInstance.invoke(AbstractBeanInstance.java:38) at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100) at org.camunda.bpm.engine.CaseService$348906316$Proxy$_$$_WeldClientProxy.setVariables(Unknown Source) at com.quickenloans.liftoff.service.CamundaLoanApplicationServiceImpl.updateApplicationById(CamundaLoanApplicationServiceImpl.java:334) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.delegateInterception(Jsr299BindingsInterceptor.java:70) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:80) at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:103) at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:58) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437) at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64) at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356) at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:636) at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356) at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198) at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73) at com.quickenloans.liftoff.service.ILoanApplicationService$$$view1.updateApplicationById(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:433) at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:128) at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56) at org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:67) at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100) at com.quickenloans.liftoff.service.ILoanApplicationService$233604940$Proxy$_$$_Weld$EnterpriseProxy$.updateApplicationById(Unknown Source) at com.quickenloans.liftoff.controller.ConversationControllerInbound.saveTopic(ConversationControllerInbound.java:91) at com.quickenloans.liftoff.controller.ConversationControllerInbound.saveTopics(ConversationControllerInbound.java:62) at com.quickenloans.liftoff.controller.ConversationControllerInbound$Proxy$_$$_WeldClientProxy.saveTopics(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:139) at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:295) at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:249) at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:236) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:402) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:209) at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:805) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. ### The error may involve org.camunda.bpm.engine.impl.cmmn.entity.runtime.CaseExecutionEntity.deleteCaseExecution-Inline ### The error occurred while setting parameters ### SQL: delete from ACT_RU_CASE_EXECUTION where ID_ = ? and REV_ = ? ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200) at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:213) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.executeDelete(DbSqlSession.java:199) at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.deleteEntity(DbSqlSession.java:184) at org.camunda.bpm.engine.impl.db.AbstractPersistenceSession.executeDbOperation(AbstractPersistenceSession.java:45) at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:334) ... 148 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:548) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:479) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7344) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2713) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:463) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198) ... 153 more