topic ActivitiOptimisticException with single JobExecutor in Alfresco Archive

ActivitiOptimisticException with single JobExecutor

sushantmahajan — Tue, 10 Feb 2015 10:31:30 GMT

We have written a custom code overriding Locking for jobs in acquireJobCmd. The application uses Hibernate for database connection. Sometimes we experience ActivitiOptimisticLockingException for a job and that job gets stuck with a lock owner till it reaches lock expiration time. The exception that

Re: ActivitiOptimisticException with single JobExecutor

jbarrez — Wed, 18 Feb 2015 11:57:57 GMT

If you are on single node, you shouldn't see this. Are you changing data of the job yourself when the job is being executed? That could explain the optimistic locking problem.

Re: ActivitiOptimisticException with single JobExecutor

sushantmahajan — Tue, 24 Feb 2015 05:56:13 GMT

We are experiencing ActivitOptimisticexception two cases on single server.

1. When we try to delete a running job. Please suggest how to carefully wait before calling runTimeService.deleteProcessInstance(String processInstanceId, String deleteReason).

2. We have customised AcquiredJobCommand, that in execute method we set its lock owner, lock expiration time and retries and then add the job to AcquiredJobs. What among these be a reason for this exception? Please suggest.

Re: ActivitiOptimisticException with single JobExecutor

trademak — Tue, 24 Feb 2015 19:31:56 GMT

1. What's the reason for wanting to delete a process instance while the job is running? The logic being executed in the job will remain running anyways, so it's best to delete the process instance after the job has stopped running.

2. Can you explain the reasoning behing changing the command? Are you using the new async job executor or the other job executor? When do you see the ActivitiOptimisticLockException occurring?

Best regards,