topic org.activiti.engine.ActivitiOptimisticLockingException: JobEntity in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-activitioptimisticlockingexception-jobentity/m-p/219161#M172291 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have 2 Activiti (v5.18) engines instances pointed to the same database. I have a java delegate serviceTask that has async='true'.&nbsp; The java delegate is straighforward as it just inserts a row to an application table. When I test will higher message count, I see this exception below.</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />org.activiti.engine.ActivitiOptimisticLockingException: JobEntity [id=45926] was updated by another transaction concurrently<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession$CheckedDeleteOperation.execute(DbSqlSession.java:294)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushRegularDeletes(DbSqlSession.java:921)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushDeletes(DbSqlSession.java:887)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:612)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:211)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:137)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:66)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.asyncexecutor.ExecuteAsyncRunnable.run(ExecuteAsyncRunnable.java:69)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:745)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I understand the async step creates a job and the job is executed on a separate thread, but this is causing duplicate insertions into the app table. For example when I test with 50 messages, I see this exception in the log and sometimes 62 rows in the app table. The count on the ACT_HI_PROCINST is still 50 though. Can someone please explain what is going on and how to handle this?</SPAN><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>Clement</SPAN><BR /></BODY></HTML> Tue, 08 Dec 2015 22:54:30 GMT soaguy 2015-12-08T22:54:30Z org.activiti.engine.ActivitiOptimisticLockingException: JobEntity https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-activitioptimisticlockingexception-jobentity/m-p/219161#M172291 Hi all,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have 2 Activiti (v5.18) engines instances pointed to the same database. I have a java delegate serviceTask that has async='true'.&nbsp; The java delegate is straighforward as it just inserts a row to an application table. When I test will higher message count, I see this exception below Tue, 08 Dec 2015 22:54:30 GMT https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-activitioptimisticlockingexception-jobentity/m-p/219161#M172291 soaguy 2015-12-08T22:54:30Z Re: org.activiti.engine.ActivitiOptimisticLockingException: JobEntity https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-activitioptimisticlockingexception-jobentity/m-p/219162#M172292 <HTML><HEAD></HEAD><BODY><SPAN>That probably means the javadelegate logic you have is not transactional?</SPAN><BR /><SPAN>When an exception occurs, Activiti does a roll back of the transaction, if your jdbc code is not part of that transaction, then it doesn't know it has to roll back.</SPAN></BODY></HTML> Thu, 10 Dec 2015 18:19:04 GMT https://connect.hyland.com/t5/alfresco-archive/org-activiti-engine-activitioptimisticlockingexception-jobentity/m-p/219162#M172292 jbarrez 2015-12-10T18:19:04Z