topic getVariables with ActivitiOptimisticLockingException in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/getvariables-with-activitioptimisticlockingexception/m-p/158923#M112984 <HTML><HEAD></HEAD><BODY><SPAN>HI, if I doing heavy read and write operations on a process it happen sometimes that I get this exception:</SPAN><BR /><BR /><SPAN>&lt;code&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:560)[141<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:442)[141<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:169)[141<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:116)[141<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:70)[141<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)[144:wrap_mvn_org.activiti_activiti-spring_5.13:0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)[102<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.springframework.transaction:3.1.4.RELEASE]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)[144:wrap_mvn_org.activiti_activiti-spring_5.13:0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)[141<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.RuntimeServiceImpl.getVariables(RuntimeServiceImpl.java:103)[141<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]</SPAN><BR /><SPAN>&lt;code&gt;</SPAN><BR /><BR /><SPAN>Does anyone know why a *read* execute an database update? Is this maybe the cache which is implemented in the session? To avoid such an error I can work with synchronize for reading and writing but I think this would slow down my application. Know anyone maybe a better solution?</SPAN><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>Michael</SPAN></BODY></HTML> Fri, 04 Oct 2013 12:41:14 GMT mpriess 2013-10-04T12:41:14Z getVariables with ActivitiOptimisticLockingException https://connect.hyland.com/t5/alfresco-archive/getvariables-with-activitioptimisticlockingexception/m-p/158923#M112984 HI, if I doing heavy read and write operations on a process it happen sometimes that I get this exception:&lt;code&gt;&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:560)[141<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.activiti.engine:5.13.0]&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.ja Fri, 04 Oct 2013 12:41:14 GMT https://connect.hyland.com/t5/alfresco-archive/getvariables-with-activitioptimisticlockingexception/m-p/158923#M112984 mpriess 2013-10-04T12:41:14Z Re: getVariables with ActivitiOptimisticLockingException https://connect.hyland.com/t5/alfresco-archive/getvariables-with-activitioptimisticlockingexception/m-p/158924#M112985 <HTML><HEAD></HEAD><BODY><SPAN>btw. actually I'm using Activiti 5.13 and why can I not edit my post?</SPAN></BODY></HTML> Tue, 08 Oct 2013 09:24:02 GMT https://connect.hyland.com/t5/alfresco-archive/getvariables-with-activitioptimisticlockingexception/m-p/158924#M112985 mpriess 2013-10-08T09:24:02Z Re: getVariables with ActivitiOptimisticLockingException https://connect.hyland.com/t5/alfresco-archive/getvariables-with-activitioptimisticlockingexception/m-p/158925#M112986 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>A little bit of code would help. Can you reproduce this in a unit test?</SPAN><BR /><SPAN>Hmm strange, that you can't edit the post. I'll see if I can change that setting in the forum administration.</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Wed, 09 Oct 2013 09:14:05 GMT https://connect.hyland.com/t5/alfresco-archive/getvariables-with-activitioptimisticlockingexception/m-p/158925#M112986 trademak 2013-10-09T09:14:05Z