User development, A new message was posted in the thread "JBPM4.3 jobExecutor threads cause database deadlock exception": http://community.jboss.org/message/521161#521161 Author : Zengping Tian Profile : http://community.jboss.org/people/zptian Message: -------------------------------------------------------------- Hi   We're trying to run jbpm4.3 + db2, but jobExecutor threads cause database deadlock exception   Any one has similar experience?   Thanks in advice     8:37:17,310 SEV                 | [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.LockAcquisitionException: pool-1-thread-1: could not update: [org.jbpm.pvm.internal.model.ExecutionImpl#69] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2466) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2340) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2653) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028) at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:342) at $Proxy0.flush(Unknown Source) at org.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:56) at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:107) at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:64) at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53) at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55) at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43) at org.jbpm.pvm.internal.jobexecutor.JobParcel.run(JobParcel.java:48) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907) at java.lang.Thread.run(Thread.java:619) Caused by: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2 at com.ibm.db2.jcc.a.lg.e(lg.java:1600) at com.ibm.db2.jcc.b.gb.s(gb.java:859) at com.ibm.db2.jcc.b.gb.k(gb.java:387) at com.ibm.db2.jcc.b.gb.a(gb.java:60) at com.ibm.db2.jcc.b.w.a(w.java:52) at com.ibm.db2.jcc.b.wb.b(wb.java:202) at com.ibm.db2.jcc.a.mg.ab(mg.java:1794) at com.ibm.db2.jcc.a.mg.d(mg.java:2342) at com.ibm.db2.jcc.a.mg.W(mg.java:463) at com.ibm.db2.jcc.a.mg.executeUpdate(mg.java:446) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2448) ... 29 more -------------------------------------------------------------- To reply to this message visit the message page: http://community.jboss.org/message/521161#521161