ActivitiOptimisticLockingException in Cluster Setup

[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

[trademak]

Under heavy load an optimistic lock exception on the db identifiers is possible. You could use the UUID database generator instead or add retry logic around the action where you get this exception.

Best regards,

[sakumar1]

Thanks for the response. Are you mentioning about StrongUuidGenerator ? Can you please explain more about UUID database generator ?

[jbarrez]

http://activiti.org/userguide/index.html#advanced.uuid.generator