topic Re: ServiceTask async join problem on MySQL in Alfresco Archive

ServiceTask async join problem on MySQL

huksley — Tue, 14 Jul 2015 12:00:50 GMT

I am experiencing problem with simple process:[start] -> [excl-gateway] -> [user task] -> [excl-gateway] -> [end] -> [async svctask] -^‍‍‍‍the problem is, when async svc task finishesit is still in list of executors and msg in logorg.activiti.engine.impl

Re: ServiceTask async join problem on MySQL

jbarrez — Tue, 14 Jul 2015 19:51:38 GMT

I don't seem to be able to run your project. For example the pom.xml has 5.15 as Activiti version, while the async executor was introduced later. Also got a Spring error. Could you check if the project runs for you?

Secondly, from your logging it seems like two process engines are booting up? That would explain the concurrent transaction exception …

Re: ServiceTask async join problem on MySQL

huksley — Wed, 15 Jul 2015 05:24:47 GMT

Fixed maven config - upgraded Activiti version, added MySQL connector as artefact.
After running mvn compile; mvn test - error persists on Mac OS - Java 1.6.0_65, MySQL 5.5.28

You might need to change src/test/resources/activiti.cfg.xml to suit your environment.

About two instances… I follow unittest template. Running single test instance. No other process access database.

Thanks in advance!

Re: ServiceTask async join problem on MySQL

huksley — Wed, 15 Jul 2015 11:06:39 GMT

Tried on MySQL 5.6.25 on Windows - same error.
Tried on H2 Server mode, using url jdbc:h2:tcp://localhost/~/activiti - NO ERROR

Re: ServiceTask async join problem on MySQL

huksley — Wed, 22 Jul 2015 15:25:50 GMT

Fixed project. Maybe my process definition is incorrect?

Re: ServiceTask async join problem on MySQL

jbarrez — Thu, 23 Jul 2015 12:30:14 GMT

Ok, perfect, now I could run it straight away without any problem, thanks.

What happens is that, after the process instance is started, both the 'task complete' and the 'async service task happen at the same time, in two different threads. One of the two will 'win', as they both need to join in the joining parallel gateway. In this case, the async job often loses (you see an optimistic locking exception in the log), and the task complete wins. At that point, the due date is recalculated (+ 5 minutes) to retry later.

A workaround for this pattern is to make the joining parallel gateway async and exclusive:

<code>
<parallelGateway id="parallelgateway2" activiti:async="true" activiti:exclusive="true"></parallelGateway>
</code>

Re: ServiceTask async join problem on MySQL

huksley — Thu, 23 Jul 2015 15:46:20 GMT

Thanks for information and help. Is there any best practices on this? What I try to accomplish is to make in parallel user reviewing loan request and automatic security checking. Maybe I better use messaging/signaling?

Re: ServiceTask async join problem on MySQL

jbarrez — Tue, 28 Jul 2015 11:35:27 GMT

Making the joining gateway async and exclusive is a good idea anyway for this pattern, that avoids having concurrent joins (which is the issue here).

What do you mean with messaging/signalling? It can mean a lot of things 🙂