topic Re: org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[] was updated by another transaction concurrently in Alfresco Archive

org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[] was updated by another transaction concurrently

aman1 — Fri, 02 Aug 2013 13:02:59 GMT

I get a Optimistic lock exception in the scenario where the timer expires i.e. 'waitForUpdate' takes more than 10 seconds.At this stage the workflow continues with the next step defined with boundaryEvent 'setDefaultIfNoDispatchUpdate'.Now the response is received after 20 seconds (say). It signals

Re: org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[] was updated by another transaction concurrently

frederikherema1 — Mon, 05 Aug 2013 08:20:30 GMT

Do you have multiple engines running on the same DB? If so, this can be ignored, as it' one of the 2 job-executors that is getting an exception because the timer is already executed by the other one. If it's not the case, it means that while the timer 'fires', another thread (possibly your app) has completed a task/signalled/… that particular process, before the "timer fire" transaction is committed. The timer-execution is rolled back, so it actually never happened because the process has moved on since.

Re: org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[] was updated by another transaction concurrently

aman1 — Thu, 08 Aug 2013 14:06:35 GMT

<receiveTask id="waitForDispatchUpdate" />
<boundaryEvent attachedToRef="waitForDispatchUpdate"
   id="setDefaultIfNoDispatchUpdate">
   <timerEventDefinition>
    <timeDuration>PT20S</timeDuration>
   </timerEventDefinition>
</boundaryEvent>
<sequenceFlow id="flow3" sourceRef="sendDispatchMessage" targetRef="waitForDispatchUpdate" />

<sequenceFlow id="flow8" sourceRef="setDefaultIfNoDispatchUpdate" targetRef="setColourToPink" />

Thanks for your reply. I do not have multiple engines running.
After the 'sendDispatchMessage' the control comes to RecieveTask and waits there for response . Suppose the response doesn't comes in 20S. Then flow 8 executes and goes thru this breanch setDefaultIfNoDispatchUpdate ->setColourToPink. At this stage i see that the Activiti updates its tables (TimerEntity) which is correct.
Now if the response comes back in java code , we have an api that tries to signal back the workflow bpmn that the response is recieved.
the code snippet to do this is below
Execution execution =runtimeService.createExecutionQuery()
    .processInstanceId(processId).activityId('waitForDispatchUpdate')
    .singleResult();
if (execution != null) {
runtimeService.signal(execution.getId());
}
Should this execution not be null as the 'waitForDispatchUpdate' has already expired now. As it doesn't return null and proceed to execute runtimeService.signal(execution.getId()) , it throws a Optimistic Lock exception on the TimerEntity.
My point is that the execution should have been returnned null as the timer had expired. Please suggest.
Thanks

Re: org.activiti.engine.ActivitiOptimisticLockingException: TimerEntity[] was updated by another transaction concurrently

trademak — Fri, 09 Aug 2013 13:09:18 GMT

With only part of the process definition listed it's difficult to get a full understanding of the issue.
Can you create a unit test showing your problem or include the full process definition and show exactly what Java code you are executing?

Best regards,