PropertyEntity[next.dbid] was updated by another transaction

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

erensimsek

Hi everyone,

We have an application that, it has 8 instance.. of course they includes theirself proccessengine.

When we run

runtimeService.startProcessInstanceByKey("ReceiveTaskTimerTest")


we get this error.


SEVERE: Error while closing command context
org.activiti.engine.ActivitiOptimisticLockingException: PropertyEntity[next.dbid] was updated by another transaction concurrently
        at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:435)
        at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:348)

How can we resolve this problem.?

Thank you?

erensimsek

Hi again,

When call

runtimeService.startProcessInstanceByKey("ReceiveTaskTimerTest")

activiti execute this query:

select * from ACT_GE_PROPERTY where NAME_ = 'next.dbid'

if query result that: 'next.dbid',1,1

and after execute this query:

update ACT_GE_PROPERTY SET REV_ = 2, VALUE_ = (1+idBlockSize) where NAME_ = 'next.dbid' and REV_ = 1

So, when we executing the last query concurrently, we will get optimisticlockException.

As a result we want to update the first query for oracle like that:
select * from ACT_GE_PROPERTY where NAME_ = 'next.dbid'  for update

is it dangerous for activiti procces engine and their components..?

thank you.