topic Don't allow same task to be completed by different user at same time in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/don-t-allow-same-task-to-be-completed-by-different-user-at-same/m-p/244642#M197772 <HTML><HEAD></HEAD><BODY><SPAN>Hey guys,</SPAN><BR /><BR /><SPAN>I want to implement optimistic locking kind of behavior (I know its already been built in), but not sure why this is not working, adding error below. I have a requirement where a task is available in a pool and two users may complete the task at the same time and we need to send error back to the user whose transaction is executed secondly but I get deadlock error rather than task not available or Optmistic locking exception.</SPAN><BR /><BR /><SPAN>Database level isolation level</SPAN><BR /><BR /><SPAN>TX_ISOLATION - REPEATABLE-READ</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />### Error updating database.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction<BR />### The error may involve org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance-Inline<BR />### The error occurred while setting parameters<BR />### SQL: update ACT_HI_TASKINST set&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXECUTION_ID_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PARENT_TASK_ID_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DESCRIPTION_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OWNER_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ASSIGNEE_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CLAIM_TIME_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_TIME_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DURATION_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE_REASON_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TASK_DEF_KEY_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FORM_KEY_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PRIORITY_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DUE_DATE_ = ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CATEGORY_ = ?&nbsp;&nbsp;&nbsp;&nbsp; where ID_ = ?<BR />### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction] with root cause<BR />com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:423)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.getInstance(Util.java:387)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:950)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:870)<BR />&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:611)<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.TaskServiceImpl.claim(TaskServiceImpl.java:167)<BR />&nbsp;&nbsp;&nbsp;at com.shutterfly.eni.service.impl.ActivitiServiceImpl.claimAndCompleteTask(ActivitiServiceImpl.java:73)<BR />&nbsp;&nbsp;&nbsp;at com.shutterfly.eni.service.impl.OrderServiceImpl.submitSbsPlatformOrder(OrderServiceImpl.java:926)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:498)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)<BR /><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>‍</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><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Appreciate, your prompt response.</SPAN><BR /><BR /><SPAN>-Himanshu</SPAN><BR /><BR /></BODY></HTML> Fri, 11 Nov 2016 13:34:13 GMT himanshu_agarwa 2016-11-11T13:34:13Z Don't allow same task to be completed by different user at same time https://connect.hyland.com/t5/alfresco-archive/don-t-allow-same-task-to-be-completed-by-different-user-at-same/m-p/244642#M197772 Hey guys,I want to implement optimistic locking kind of behavior (I know its already been built in), but not sure why this is not working, adding error below. I have a requirement where a task is available in a pool and two users may complete the task at the same time and we need to send error back Fri, 11 Nov 2016 13:34:13 GMT https://connect.hyland.com/t5/alfresco-archive/don-t-allow-same-task-to-be-completed-by-different-user-at-same/m-p/244642#M197772 himanshu_agarwa 2016-11-11T13:34:13Z Re: Don't allow same task to be completed by different user at same time https://connect.hyland.com/t5/alfresco-archive/don-t-allow-same-task-to-be-completed-by-different-user-at-same/m-p/244643#M197773 <HTML><HEAD></HEAD><BODY><SPAN>Hi, </SPAN><BR /><SPAN>I'll try to reproduce and investigate it,</SPAN><BR /><SPAN>could you please provide a unit test for this scenario? it would be very usefull.</SPAN><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Mon, 14 Nov 2016 09:58:46 GMT https://connect.hyland.com/t5/alfresco-archive/don-t-allow-same-task-to-be-completed-by-different-user-at-same/m-p/244643#M197773 vasile_dirla 2016-11-14T09:58:46Z