topic Re: Exception in completeTask in Alfresco Archive

Exception in completeTask

satramalin — Thu, 04 Dec 2014 22:01:01 GMT

Hi,Can you please let me know when this exception happensException Occured in completeTask(): HistoricVariableInstanceEntity[id=1907296, name=request, revision=1, type=serializable, byteArrayValueId=1907297] was updated by another transaction concurrentlyThanks!!

Re: Exception in completeTask

trademak — Fri, 05 Dec 2014 12:29:35 GMT

I would expect that the same variable is changed by multiple transactions at the same time. Would that be possible in your implementation?

Best regards,

Re: Exception in completeTask

satramalin — Sat, 06 Dec 2014 16:09:21 GMT

We don't have that scenario in our implementation. Its a simple test process which has 3 user tasks assigned to the same user. We are checking the load by creating large number of instances in a high speed. When the load increases, we observed this exception. We also observed the below exceptions.

1. Exception Occured in completeTask():"Exception Occured in completeTask():
### Error updating database. Cause: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
### The error may involve org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance-Inline
### The error occurred while setting parameters
### SQL: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ?
### Cause: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource

2. Exception Occured in completeTask(): Cannot find task with id

Thanks

Re: Exception in completeTask

jbarrez — Mon, 08 Dec 2014 13:23:06 GMT

A deadlock is surely something else than the optimisticlocking exception.

What are you testing here exactly? How many instances? What kind of Oracle database?

Re: Exception in completeTask

satramalin — Mon, 08 Dec 2014 13:29:29 GMT

We are performing a load test on Oracle exadata. There are 3500-4000 instances created for a single run. Right now, there are more than 100000 instances in the database. Out of close to 3500 instances in every run, we observed the exceptions for 10-15 instances. Most of the exceptions are with concurrent updates.

Thanks

Re: Exception in completeTask

satramalin — Mon, 08 Dec 2014 20:07:45 GMT

Please find the attached bpmn

Re: Exception in completeTask

hepcibha — Wed, 08 Apr 2015 23:34:42 GMT

Hi, we are having a similar issue in production, did you find a solution for this?

Re: Exception in completeTask

jbarrez — Tue, 14 Apr 2015 12:06:02 GMT

You mean a deadlock? We would need more info about the process and how to reproduce.