Loading...

XML

Word

Printable

Type: Bug Report
Resolution: Duplicate
Priority: L3 - Default
Fix Version/s: None
Affects Version/s: None
Component/s: cmmn model api
Labels:
None

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

This is the controller panel for Smart Panels app

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List
  - Download All

loan_qualification_lrc.cmmn
18 kB
20/Jun/18 11:07 PM

Assignee:: Unassigned

Reporter:: Clay Rowland

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Created:: 20/Jun/18 11:22 PM

Updated:: 21/Jun/18 10:18 PM

Resolved:: 21/Jun/18 10:18 PM

Details

Description

mgm-controller-panel

This is the controller panel for Smart Panels app

Attachments

Attachments

Activity

People

Dates

Salesforce