ENGINE-16004 Exception while closing command context: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace

Hello. I’m having some challenges here all of the sudden and I am hoping someone can point me in the right direction. We are using Camunda as a spring boot application in AWS and Aurora (MySQL) as the datastore.

I am seeing the following issue in our staging environment and I am not able to replicate it locally, in dev, nor in qa environments.

Here is what I see in the logs

Sine start up info:

Spring-Boot: (v2.6.7)

Camunda Platform: (v7.17.0)

Camunda Platform Spring Boot Starter: (v7.17.0)

Starting PathfinderApplication using Java 11.0.6 on 35ca6b8a89ca with PID 19

HikariPool-1 - Starting…

HikariPool-1 - Start completed.

H2 console available at ‘/h2-console’. Database available at ‘jdbc:mysql://db:3306/camunda?autoReconnect=true&sendFractionalSeconds=false’

STARTER-SB040 Setting up jobExecutor with corePoolSize=3, maxPoolSize:10

Tomcat started on port(s): 8080 (http) with context path ‘’

Started Application in 102.784 seconds (JVM running for 140.1)

ENGINE-14014 Starting up the JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor].

ENGINE-14018 JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor] starting to acquire jobs

The errors

ENGINE-14018 JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor] starting to acquire jobs
ENGINE-16004 Exception while closing command context: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace

“exception”: “An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.”,
“component”: “org.springframework.transaction.support.TransactionTemplate”,
“level_name”: “ERROR”,
“service”: “pathfinder”,
“thread”: “JobExecutor[org.camunda.bpm.engine.spring.components.jobexecutor.SpringJobExecutor]”,
“stack_trace”: [
“org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263)”,
“org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:133)”,
“org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:364)”,
“org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323)”,
“org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295)”,
“org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272)”,
“org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188)”,
“org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119)”,
“org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:72)”,
“org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)”,
“org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:70)”,
“org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)”,
“org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)”,
“org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)”,
“org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.acquireJobs(SequentialJobAcquisitionRunnable.java:164)”,
“org.camunda.bpm.engine.impl.jobexecutor.SequentialJobAcquisitionRunnable.run(SequentialJobAcquisitionRunnable.java:80)”,
“java.base/java.lang.Thread.run(Thread.java:834)”
],
“message”: “Initiating transaction rollback on application exception”,
“asctime”: "2022-10-06T20:48:55.148627Z

Get a bunch of these, then all of the sudden one instance works then its back to the errors above

A bit later, I get this exception after the usual ENGINE-16004 Exception while closing command context: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.

“exception”: “An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.”,
“component”: “org.springframework.transaction.support.TransactionTemplate”,
“level_name”: “ERROR”,
“service”: “pathfinder”,
“thread”: “http-nio-8080-exec-8”,
“stack_trace”: [
“org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263)”,
“org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:133)”,
“org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:364)”,
“org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323)”,
“org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295)”,
“org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272)”,
“org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188)”,
“org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119)”,
“org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:72)”,
“org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)”,
“org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:70)”,
“org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)”,
“org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)”,
“org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)”,
“org.camunda.bpm.engine.impl.ProcessInstantiationBuilderImpl.executeWithVariablesInReturn(ProcessInstantiationBuilderImpl.java:166)”,
“org.camunda.bpm.engine.rest.sub.repository.impl.ProcessDefinitionResourceImpl.startProcessInstanceAtActivities(ProcessDefinitionResourceImpl.java:179)”,
“org.camunda.bpm.engine.rest.sub.repository.impl.ProcessDefinitionResourceImpl.startProcessInstance(ProcessDefinitionResourceImpl.java:129)”,
“java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)”,
“java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)”,
“java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)”,
“java.base/java.lang.reflect.Method.invoke(Method.java:566)”,
“org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)”,
“org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)”,
“org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)”,
“org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)”,
“org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)”,
“org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475)”,
“org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397)”,
“org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)”,
“org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)”,
“org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)”,
“org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)”,
“org.glassfish.jersey.internal.Errors.process(Errors.java:292)”,
“org.glassfish.jersey.internal.Errors.process(Errors.java:274)”,
“org.glassfish.jersey.internal.Errors.process(Errors.java:244)”,
“org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)”,
“org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)”,
“org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)”,
“org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)”,
“org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)”,
“org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)”,
“org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)”,
“org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:45)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.camunda.bpm.engine.rest.filter.EmptyBodyFilter.doFilter(EmptyBodyFilter.java:99)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.camunda.bpm.engine.rest.security.auth.ProcessEngineAuthenticationFilter.doFilter(ProcessEngineAuthenticationFilter.java:155)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)”,
“org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)”,
“org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)”,
“org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)”,
“org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)”,
“org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)”,
“org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)”,
“org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)”,
“org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)”,
“org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)”,
“org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)”,
“org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)”,
“org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)”,
“org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)”,
“org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)”,
“org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)”,
“org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)”,
“org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)”,
“org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)”,
“org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)”,
“org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)”,
“java.base/java.lang.Thread.run(Thread.java:834)”
],
“message”: “Initiating transaction rollback on application exception”,
“asctime”: “2022-10-06T21:48:20.095884Z”

followed by this one

“component”: “org.camunda.bpm.engine.rest.exception”,
“level_name”: “WARN”,
“service”: “pathfinder”,
“thread”: “http-nio-8080-exec-8”,

“message”: “ENGINE-REST-HTTP500 org.camunda.bpm.engine.rest.exception.RestException: Cannot instantiate process definition autoArchiveProcess:1:5e5115b7-4345-11ed-8950-0242ac110004: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
at org.camunda.bpm.engine.rest.sub.repository.impl.ProcessDefinitionResourceImpl.startProcessInstance(ProcessDefinitionResourceImpl.java:135)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81)
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244)
at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
at org.glassfish.jersey.internal.Errors.process(Errors.java:244)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.camunda.bpm.engine.rest.filter.EmptyBodyFilter.doFilter(EmptyBodyFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.camunda.bpm.engine.rest.security.auth.ProcessEngineAuthenticationFilter.doFilter(ProcessEngineAuthenticationFilter.java:155)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer. Please check the server logs for a detailed message and the entire exception stack trace.
at org.camunda.bpm.engine.impl.util.ExceptionUtil.wrapPersistenceException(ExceptionUtil.java:263)
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:133)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:364)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperationManager(DbEntityManager.java:323)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flush(DbEntityManager.java:295)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:272)
at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:188)
at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119)
at org.camunda.bpm.engine.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:72)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:70)
at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)
at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)
at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
at org.camunda.bpm.engine.impl.ProcessInstantiationBuilderImpl.executeWithVariablesInReturn(ProcessInstantiationBuilderImpl.java:166)
at org.camunda.bpm.engine.rest.sub.repository.impl.ProcessDefinitionResourceImpl.startProcessInstanceAtActivities(ProcessDefinitionResourceImpl.java:179)
at org.camunda.bpm.engine.rest.sub.repository.impl.ProcessDefinitionResourceImpl.startProcessInstance(ProcessDefinitionResourceImpl.java:129)
… 68 more
Caused by: org.camunda.bpm.engine.ProcessEngineException: ENGINE-03004 Exception while executing Database Operation ‘INSERT HistoricVariableInstanceEntity[02c18eb7-45c0-11ed-85ca-0242ac110006]’ with message ‘

Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
’. Flush summary:
[
INSERT HistoricVariableInstanceEntity[02c18eb7-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableInstanceEntity[02c18eba-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableInstanceEntity[02c1b5cc-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableInstanceEntity[02c1b5cf-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableInstanceEntity[02c1b5d3-45c0-11ed-85ca-0242ac110006]
INSERT HistoricJobLogEventEntity[02c22b07-45c0-11ed-85ca-0242ac110006]
INSERT UserOperationLogEntryEventEntity[02c22b08-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableUpdateEventEntity[02c18eb9-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableUpdateEventEntity[02c1b5cb-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableUpdateEventEntity[02c1b5cd-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableUpdateEventEntity[02c1b5d1-45c0-11ed-85ca-0242ac110006]
INSERT HistoricVariableUpdateEventEntity[02c1b5d4-45c0-11ed-85ca-0242ac110006]
INSERT HistoricProcessInstanceEventEntity[02c18eb6-45c0-11ed-85ca-0242ac110006]
INSERT HistoricActivityInstanceEventEntity[StartEvent_1:02c1b5d5-45c0-11ed-85ca-0242ac110006]
INSERT ExecutionEntity[02c18eb6-45c0-11ed-85ca-0242ac110006]
INSERT ByteArrayEntity[02c1b5ce-45c0-11ed-85ca-0242ac110006]
INSERT ByteArrayEntity[02c1b5d0-45c0-11ed-85ca-0242ac110006]
INSERT ByteArrayEntity[02c1b5d2-45c0-11ed-85ca-0242ac110006]
INSERT VariableInstanceEntity[02c18eb7-45c0-11ed-85ca-0242ac110006]
INSERT VariableInstanceEntity[02c18eba-45c0-11ed-85ca-0242ac110006]
INSERT VariableInstanceEntity[02c1b5cc-45c0-11ed-85ca-0242ac110006]
INSERT VariableInstanceEntity[02c1b5cf-45c0-11ed-85ca-0242ac110006]
INSERT VariableInstanceEntity[02c1b5d3-45c0-11ed-85ca-0242ac110006]
INSERT MessageEntity[02c22b06-45c0-11ed-85ca-0242ac110006]
]
at org.camunda.bpm.engine.impl.db.EnginePersistenceLogger.flushDbOperationException(EnginePersistenceLogger.java:132)
… 83 more
Caused by: org.apache.ibatis.exceptions.PersistenceException:

Error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

Cause: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:254)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.flushBatchOperations(DbSqlSession.java:444)
at org.camunda.bpm.engine.impl.db.sql.BatchDbSqlSession.executeDbOperations(BatchDbSqlSession.java:74)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.flushDbOperations(DbEntityManager.java:341)
… 82 more

Caused by: org.apache.ibatis.executor.BatchExecutorException: org.camunda.bpm.engine.impl.persistence.entity.HistoricVariableInstanceEntity.insertHistoricVariableInstance (batch index #1) failed. Cause: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:149)
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:129)
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:122)
at org.apache.ibatis.executor.CachingExecutor.flushStatements(CachingExecutor.java:114)
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(DefaultSqlSession.java:252)
… 85 more
Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction
at jdk.internal.reflect.GeneratedConstructorAccessor98.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.cj.util.Util.handleNewInstance(Util.java:192)
at com.mysql.cj.util.Util.getInstance(Util.java:167)
at com.mysql.cj.util.Util.getInstance(Util.java:174)
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:853)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:435)
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:795)
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:123)
… 89 more
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832)
… 94 more
”,