Hi
I am facing deadlock issue while completing an user activity.
Is there any special configuration required ?
Camunda version 7.9.0
Ubuntu 18.04.2 LTS (GNU/Linux 5.4.0-1037-aws x86_64)
RAM: 16GB
Mysql version 5.7
JDBC version 5.1.21
bpm-platform.xml
server.xml
I was facing Connection Timeout Issue/Process Engine Exception to resolve the issue i had removed the removeAbandoned = ''true" property from server.xml file.After removing the property the Connection Timeout issue was resolved.
Error:
Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.insertHistoricJobLogEvent (batch index #2) failed. 1 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricJobLogEntity.insertHistoricJobLogEvent (batch index #2) failed. 1 prior sub executor(s) completed successfully, but will be rolled back. Cause: java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
java.sql.BatchUpdateException: Deadlock found when trying to get lock; try restarting transaction
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
'. Flush summary:
[
INSERT HistoricVariableInstanceEntity[7d2cad86-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d2cad88-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d2d22c3-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d305743-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d305745-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d305748-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d30cc81-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d3141ba-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d318fe0-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d327a4f-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d3587c2-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d35d5e8-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d362410-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d37a9ca-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d37f7f0-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d384617-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d3c64d3-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d3c8be8-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d3cb2fd-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d3e60c5-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d3f724e-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d40d1f8-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d40d1fa-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d40f90e-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d40f910-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d412024-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d514cd4-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d51e920-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableInstanceEntity[7d5321b8-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricJobLogEventEntity[7d6486df-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableUpdateEventEntity[7d2c5f61-bf45-11ea-b1c5-0661aded1f3d]
INSERT HistoricVariableUpdateEventEntity[7d2c8672-bf45-11ea-b1c5-0661aded1f3d]
]
at org.camunda.bpm.engine.rest.sub.task.impl.TaskResourceImpl.complete(TaskResourceImpl.java:107)
at sun.reflect.GeneratedMethodAccessor479.invoke(Unknown Source)
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:137)
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:140)
at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:109)
at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:135)
at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:103)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:377)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:200)
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
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:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.camunda.bpm.engine.rest.filter.EmptyBodyFilter.doFilter(EmptyBodyFilter.java:95)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:409)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Please help.
