Camunda 7.16 deployment.lock errors

Camunda 7 Topics
1

Hi Team,

We have Embedded engine spring boot application, we see a behavior after couple of service restarts we see below exception and application fails to start. how to over come this issue if there is lock.

The error occurred while setting parameters

SQL: SELECT VALUE_ FROM ACT_GE_PROPERTY WHERE NAME_ = ‘deployment.lock’ for update

Thanks,
Gowtham

2

SQL: SELECT VALUE_ FROM ACT_GE_PROPERTY WHERE NAME_ = ‘deployment.lock’ for update

Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.6.jar!/:3.5.6]
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.lambda$executeSelectList$1(DbSqlSession.java:111) ~[camunda-engine-7.16.0.jar!/:7.16.0]
at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:254) ~[camunda-engine-7.16.0.jar!/:7.16.0]
… 58 common frames omitted
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction