Hello Guys,
In my previous question i asked related to Broken pipe issue. But this time we are getting below errors while completing the task in the camunda. We have completed around 12223 processInstanceIds out of which 2 got the same exception.
Environment Details : PCF cloud
DB : Maria DB 10.1.31-MariaDB
Camunda : 7.9.0
Spring boot: 2.0.1.RELEASE
I am not able to find out the root cause of the same. Could anyone please help me out to resolve this issue?
@Yana, @MichiDahm Your prompt help will be highly appreciable .
Below logs are printed in descending order.
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
ab4df890-2df3-46b7-bee7-85251518533f OUT INSERT HistoricActivityInstanceEventEntity[ExclusiveGateway_0ba5chb:69a57dee-4977-11e9-8b2f-eeee0affd70d]
ab4df890-2df3-46b7-bee7-85251518533f OUT INSERT HistoricActivityInstanceEventEntity[ServiceTask_16hzz7z:69a5cc0f-4977-11e9-8b2f-eeee0affd70d]
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
ab4df890-2df3-46b7-bee7-85251518533f OUT UPDATE HistoricProcessInstanceEventEntity[4648d32d-3977-11e9-a27d-eeee0aff02da]
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT [
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:84)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
ab4df890-2df3-46b7-bee7-85251518533f OUT java.sql.SQLException: Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT '. Flush summary:
ab4df890-2df3-46b7-bee7-85251518533f OUT INSERT HistoricActivityInstanceEventEntity[EndEvent:76428e90-4977-11e9-8b2f-eeee0affd70d]
ab4df890-2df3-46b7-bee7-85251518533f OUT DELETE VariableInstanceEntity[4648d32e-3977-11e9-a27d-eeee0aff02da]
ab4df890-2df3-46b7-bee7-85251518533f OUT DELETE VariableInstanceEntity[4648d330-3977-11e9-a27d-eeee0aff02da]
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilter(SecurityFilter.java:51)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.spring.boot.starter.webapp.filter.LazyDelegateFilter.doFilter(LazyDelegateFilter.java:44)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
ab4df890-2df3-46b7-bee7-85251518533f OUT DELETE ExecutionEntity[4648d32d-3977-11e9-a27d-eeee0aff02da]
ab4df890-2df3-46b7-bee7-85251518533f OUT UPDATE HistoricTaskInstanceEventEntity[ff9d2b95-46c6-11e9-bf7b-eeee0aff78fe]
ab4df890-2df3-46b7-bee7-85251518533f OUT ]
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.services.WorkflowActionService$$EnhancerBySpringCGLIB$$6e68a3f3.completeTask()
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.controllers.WorkflowController.completeTask(WorkflowController.java:73)
ab4df890-2df3-46b7-bee7-85251518533f OUT at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.webapp.impl.security.filter.SecurityFilter.doFilterSecure(SecurityFilter.java:67)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:56)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:126)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:111)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.config.security.SimpleCorsFilter.doFilter(SimpleCorsFilter.java:51)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:176)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.cloudfoundry.router.ClientCertificateMapper.doFilter(ClientCertificateMapper.java:77)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.services.WorkflowActionService.completeTask(WorkflowActionService.java:356)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #4) failed. 3 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn=289504) Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
ab4df890-2df3-46b7-bee7-85251518533f OUT at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #4) failed. 3 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn=289504) Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT UPDATE HistoricActivityInstanceEventEntity[Task_KIV_Approval:ff9d0484-46c6-11e9-bf7b-eeee0aff78fe]
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.services.WorkflowActionService$$FastClassBySpringCGLIB$$c20fa755.invoke()
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
ab4df890-2df3-46b7-bee7-85251518533f OUT 12:15:04.668 [http-nio-8080-exec-10] ERROR c.d.c.e.WorkbenchExceptionHandler - IllegalStateException
ab4df890-2df3-46b7-bee7-85251518533f OUT java.lang.IllegalStateException: ENGINE-03083 Exception while executing Batch Database Operations with message ’
ab4df890-2df3-46b7-bee7-85251518533f OUT java.sql.SQLIntegrityConstraintViolationException: (conn=289504) Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT DELETE VariableInstanceEntity[4648d32f-3977-11e9-a27d-eeee0aff02da]
ab4df890-2df3-46b7-bee7-85251518533f OUT DELETE TaskEntity[ff9d2b95-46c6-11e9-bf7b-eeee0aff78fe]
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.services.WorkflowActionService.processWorkflow(WorkflowActionService.java:642)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:747)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
ab4df890-2df3-46b7-bee7-85251518533f OUT at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.lang.reflect.Method.invoke(Method.java:498)
ab4df890-2df3-46b7-bee7-85251518533f OUT at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter$1.execute(AuthenticationFilter.java:58)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.webapp.impl.security.SecurityActions.runWithAuthentications(SecurityActions.java:40)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.lang.Thread.run(Thread.java:748)
ab4df890-2df3-46b7-bee7-85251518533f OUT java.sql.BatchUpdateException: (conn=289504) Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
ab4df890-2df3-46b7-bee7-85251518533f OUT at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.webapp.impl.security.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:56)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:158)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.controllers.WorkflowController.completeTask(WorkflowController.java:73)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:122)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1453)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.oauth2.provider.authentication.OAuth2AuthenticationProcessingFilter.doFilter(OAuth2AuthenticationProcessingFilter.java:176)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:126)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:253)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.cloudfoundry.router.ClientCertificateMapper.doFilter(ClientCertificateMapper.java:77)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
ab4df890-2df3-46b7-bee7-85251518533f OUT at java.lang.Thread.run(Thread.java:748)
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: org.apache.ibatis.exceptions.PersistenceException:
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #4) failed. 3 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn=289504) Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT ### Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.deleteExecution (batch index #4) failed. 3 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: (conn=289504) Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:255)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.services.WorkflowActionService$$EnhancerBySpringCGLIB$$6e68a3f3.completeTask()
ab4df890-2df3-46b7-bee7-85251518533f OUT at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
ab4df890-2df3-46b7-bee7-85251518533f OUT at com.dbs.crui.config.security.SimpleCorsFilter.doFilter(SimpleCorsFilter.java:51)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushOperations(DbSqlSession.java:88)
ab4df890-2df3-46b7-bee7-85251518533f OUT at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114)
ab4df890-2df3-46b7-bee7-85251518533f OUT … 140 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT … 144 common frames omitted
ab4df890-2df3-46b7-bee7-85251518533f OUT Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=289504) Cannot delete or update a parent row: a foreign key constraint fails (cruicamdb.act_ru_variable, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES act_ru_execution (ID_))
ab4df890-2df3-46b7-bee7-85251518533f OUT … 148 common frames omitted