topic Re: Back to back Service task doesn't work in Alfresco Forum

Back to back Service task doesn't work

ami — Tue, 09 May 2017 13:27:29 GMT

Hi,We have a design like One Service Task is followed by next Service Task. Here it throws below error when the second Service task is initiated:2017-05-09 15:50:16,341 DEBUG [org.activiti.engine.impl.db.DbSqlSession] (pool-5-thread-2) executing: delete ConcurrentExecution[2119210]2017-05-09 15:50:1

Re: Back to back Service task doesn't work

cjose — Tue, 09 May 2017 23:55:55 GMT

Hi Ami,

Do you always get this error "ActivitiOptimisticLockingException" from the second service task? Is it easy to reproduce this error in a unit test and share it?

Ciju

Re: Back to back Service task doesn't work

ami — Wed, 10 May 2017 06:03:12 GMT

Hi Ciju,

Thanks for reply. I am always persistently getting the same exception all the time when second Service task tried to update in activiti db, and during that I don't whom's but some other task's transaction is updating in db(whose transaction might not be yet committed).

Scenario is like, out of 10, one Design is stuck at the second service task, due to this issue, all 9 gets completed successfully.

For User task, we call TaskService.complete method to complete the user task which initiates the flow of Service task, So I doubt that the complete method of Activiti's class-TaskService, might return back the call without committing the transaction. Is it so?

QUESTION:Then how can I ensure that the transaction of user task is committed or not?which class should I use for that assurance?

Because I'm damn sure for Service task, we ensure that afterCommit() method is used and then next waiting task gets lock.

It would not be easy to create Unit test for whole Design that I have shared in the image attached.

Any help would be appreciated.

Thanks,

Ami

Re: Back to back Service task doesn't work

gdharley — Wed, 10 May 2017 13:36:30 GMT

Have you attempted to make the second service task "asynchronous".

This should push it onto the job queue which will permit the original thread to release and commit the transaction.

Pretty standard issue, optimistic locking issues should be resolved in the version 6 engine (that was a design goal).

Greg

‌

Re: Back to back Service task doesn't work

ami — Wed, 10 May 2017 13:46:05 GMT

Hi Greg,

By default our all service tasks are "asynchronous" and hence both gets pushed into job queue.
So do you think we need to make any changes out here to make this scenario work?

Suggest me some approach.

Thanks,

Ami

Re: Back to back Service task doesn't work

gdharley — Wed, 10 May 2017 13:53:48 GMT

Ok, so I can't be certain without seeing a thread dump but it's possible that with both service tasks on the queue they are being picked up in the same scheduler "scan" and so the services are being completed at the same time.

Just for testing purposes and to see if behavior changes, try making Service Task 1 synchronous (so it is executed on the servlet thread that processed the user task).

Not saying this will absolutely work since the error is coming out of the database and we essentially have a race condition. But worth a try.

Greg

‌

Re: Back to back Service task doesn't work

ami — Thu, 11 May 2017 12:54:38 GMT

Hi Greg,

I have tried the stated solution, but didn't worked. Still getting ActivitiOptimisticLockingException.

Thanks,

Ami

Re: Back to back Service task doesn't work

gdharley — Thu, 11 May 2017 15:44:12 GMT

Yeah, no real surprise.

Can you not combine the two services into a single service call?