AnsweredAssumed Answered

Deadlocks on multiserver configuration

Question asked by sushantmahajan on Dec 7, 2015
Latest reply on Dec 10, 2015 by jbarrez
Hi,

I am facing a number of deadlocks issues when executing processes on activiti engine. We have 4 servers working in a cluster, each having an activiti engine instance but working on a common database. This has been done to horizontally scale the system. The database i am using is SQL SERVER 2012.

SQL: update ACT_HI_PROCINST set       PROC_DEF_ID_ = ?,       BUSINESS_KEY_ = ?,       START_TIME_ = ?,       END_TIME_ = ?,       DURATION_ = ?,       END_ACT_ID_ = ?,       DELETE_REASON_ = ?,       NAME_ = ?     where ID_ = ?

   org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
SQL: update ACT_RU_JOB      SET REV_ =  ?,        LOCK_EXP_TIME_ = ?,        LOCK_OWNER_ = ?,        RETRIES_ = ?,        EXCEPTION_STACK_ID_ = ?,        EXCEPTION_MSG_ = ?,        DUEDATE_ = ?      where ID_= ?       and REV_ = ?


Also please suggest if some tuning is required in the Activiti Configuration or at the database level when using large number of servers together in a cluster.

Thanks

Outcomes