AnsweredAssumed Answered

ActivitiOptimisticLockingException in Cluster Setup

Question asked by sakumar1 on Oct 30, 2014
Latest reply on Oct 30, 2014 by sakumar1
Hi,

We are facing ActivitiOptimisticLockingException  when we run heavy load in cluster setup . Each thread uses its own process instance, however still we see below execption

org.activiti.engine.ActivitiOptimisticLockingException: PropertyEntity[name=next.dbid, value=96166501] was updated by another transaction concurrently
   at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:562)
   at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:444)
   at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:170)
   at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:117)
   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)
   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
   at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
   at org.activiti.engine.impl.db.DbIdGenerator.getNewBlock(DbIdGenerator.java:43)
   at org.activiti.engine.impl.db.DbIdGenerator.getNextId(DbIdGenerator.java:36)
   at org.activiti.engine.impl.db.DbSqlSession.insert(DbSqlSession.java:111)

Can you please help me in resolving this issue ? Activiti Version we used 5.14.

Regards,
Sampath

Outcomes