AnsweredAssumed Answered

Deadlock exceptions

Question asked by jorell on Aug 4, 2014
Latest reply on Aug 11, 2014 by frederikheremans1
I've been seeing a lot of the below exceptions in my logs. I am running 5.15 with multiple servers running on a single database. Not sure what the cause is or how to debug this. Any idea?


Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction\n### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.updateVariableInstance-Inline\n### The error occurred while setting parameters\n### SQL: update ACT_RU_VARIABLE     set     REV_ = ?,     EXECUTION_ID_ = ?,     BYTEARRAY_ID_ = ?,     TYPE_ =  ?,     DOUBLE_ = ?,     LONG_ = ?,     TEXT_ = ?,     TEXT2_ = ?     where ID_ = ?     and REV_ = ?\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction">,log_context <key: "/log/throwable",value <proto <type_name: "com.google.common.logging.ThrowableProto",data: "\n\ufffd\017\n1org.apache.ibatis.exceptions.PersistenceException\022\ufffd\005\n### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction\n### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.updateVariableInstance-Inline\n### The error occurred while setting parameters\n### SQL: update ACT_RU_VARIABLE     set     REV_ = ?,     EXECUTION_ID_ = ?,     BYTEARRAY_ID_ = ?,     TYPE_ =  ?,     DOUBLE_ = ?,     LONG_ = ?,     TEXT_ = ?,     TEXT2_ = ?     where ID_ = ?     and REV_ = ?

Outcomes