[jboss-user] [JBoss jBPM] - deadlock cycle

[ppc]

I'm running jbpm 3.1.4 on jboss 4.2.0.GA the persistence is provided by Derby, a Deadlock arise when I configure more than one MDB to process the messages, 
the deadlock is on this code  findTaskInstancesByProcessInstance


  | @Stateless
  | public class ProcessManagerSession .....{
  | ...
  | 
  |  public Collection<TaskInstance> getActiveTasksByProcessInstance2(Long processId) {
  |         
  | 
  |         List<TaskInstance> taskList = null;
  |         
  |          JbpmContext jbpmContext = JbpmConfiguration.getInstance().createJbpmContext();
  |         try {
  |             ProcessInstance processInstance = jbpmContext.getProcessInstance(processId);
  |             taskList = jbpmContext.getTaskMgmtSession().findTaskInstancesByProcessInstance(processInstance);
  |             
  |         } catch (Exception e) {
  |             logger.error(e);
  |             throw new ProcessException("Could not get active tasks  ");
  |         } finally {
  |             jbpmContext.close();
  |         }
  | 
  | ...
  | ...
  | 

Can somebody could give me some pointer to solve this issue ?

anonymous wrote : 
  | 07:39:51,003 ERROR (WorkManager(2)-18:)  [JDBCExceptionReporter] A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
  | Lock : ROW, JBPM_TASKINSTANCE, (20,6)
  |   Waiting XID : {3770, S} , SA, select taskinstan0_.ID_ as ID1_180_, taskinstan0_.NAME_ as NAME3_180_, taskinstan0_.DESCRIPTION_ as DESCRIPT4_180_, taskinstan0_.ACTORID_ as ACTORID5_180_, taskinstan0_.CREATE_ as CREATE6_180_, taskinstan0_.START_ as START7_180_, taskinstan0_.END_ as END8_180_, taskinstan0_.DUEDATE_ as DUEDATE9_180_, taskinstan0_.PRIORITY_ as PRIORITY10_180_, taskinstan0_.ISCANCELLED_ as ISCANCE11_180_, taskinstan0_.ISSUSPENDED_ as ISSUSPE12_180_, taskinstan0_.ISOPEN_ as ISOPEN13_180_, taskinstan0_.ISSIGNALLING_ as ISSIGNA14_180_, taskinstan0_.ISBLOCKING_ as ISBLOCKING15_180_, taskinstan0_.TASK_ as TASK16_180_, taskinstan0_.TOKEN_ as TOKEN17_180_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN18_180_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM19_180_ from JBPM_TASKINSTANCE taskinstan0_, JBPM_TOKEN token1_ where taskinstan0_.TOKEN_=token1_.ID_ and token1_.PROCESSINSTANCE_=? and taskinstan0_.ISSUSPENDED_<>1 and taskinstan0_.ISOPEN_=1
  |   Granted XID : {3769, X} 
  | Lock : ROW, JBPM_TASKINSTANCE, (21,6)
  |   Waiting XID : {3769, S} , SA, select taskinstan0_.ID_ as ID1_180_, taskinstan0_.NAME_ as NAME3_180_, taskinstan0_.DESCRIPTION_ as DESCRIPT4_180_, taskinstan0_.ACTORID_ as ACTORID5_180_, taskinstan0_.CREATE_ as CREATE6_180_, taskinstan0_.START_ as START7_180_, taskinstan0_.END_ as END8_180_, taskinstan0_.DUEDATE_ as DUEDATE9_180_, taskinstan0_.PRIORITY_ as PRIORITY10_180_, taskinstan0_.ISCANCELLED_ as ISCANCE11_180_, taskinstan0_.ISSUSPENDED_ as ISSUSPE12_180_, taskinstan0_.ISOPEN_ as ISOPEN13_180_, taskinstan0_.ISSIGNALLING_ as ISSIGNA14_180_, taskinstan0_.ISBLOCKING_ as ISBLOCKING15_180_, taskinstan0_.TASK_ as TASK16_180_, taskinstan0_.TOKEN_ as TOKEN17_180_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN18_180_, taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM19_180_ from JBPM_TASKINSTANCE taskinstan0_, JBPM_TOKEN token1_ where taskinstan0_.TOKEN_=token1_.ID_ and token1_.PROCESSINSTANCE_=? and taskinstan0_.ISSUSPENDED_<>1 and taskinstan0_.ISOPEN_=1
  |   Granted XID : {3770, X} 
  | . The selected victim is XID : 3770.
  | 07:39:51,005 ERROR (WorkManager(2)-18:)  [TaskMgmtSession] org.hibernate.exception.LockAcquisitionException: could not execute query
  | 
  | 



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4177859#4177859

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4177859