[jboss-user] [jBPM] New message: "JBPM4.3 jobExecutor threads cause database deadlock exception"

[Zengping Tian]

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