Hello, I am using a BPEL process which has a PICK element with <onAlarm for="'PT15M'">. Once process is intiated the BPEL process inserts record to JBPM_TIMER table with appropriate DUEDATE_. Under normal circumstances the process runs fine. But if process in not completed with record still in JBPM_TIMER , and I restart the Jboss application server the next time when the pick wakes up on timer I get the exception from Hibernate saying that deadlock situation in database. I am under impression here the jboss is caching the timer in memory and trying to update two timers.
Here is my environment and exception stackTrace any help is appreciated. JBOSS : 4.0.3 SP1 DB - SYBASE 12.5 JBPM_BPEL -- BETA 2 thank you Afzal Caused by: org.jbpm.graph.def.DelegationException at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:352) at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:346) at org.jbpm.graph.def.GraphElement$$FastClassByCGLIB$$7a7d6aa6.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.raiseException() at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:346) at org.jbpm.graph.def.GraphElement$$FastClassByCGLIB$$7a7d6aa6.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.raiseException() at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:346) at org.jbpm.graph.def.GraphElement$$FastClassByCGLIB$$7a7d6aa6.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.raiseException() at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:346) at org.jbpm.bpel.def.Activity.enter(Activity.java:106) at org.jbpm.bpel.def.Activity$$FastClassByCGLIB$$a89e54a2.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.StructuredActivity$End$$EnhancerByCGLIB$$756f66da.enter() at org.jbpm.graph.def.Transition.take(Transition.java:119) at org.jbpm.graph.def.Node.leave(Node.java:383) at org.jbpm.bpel.def.Activity.leave(Activity.java:171) at org.jbpm.bpel.def.Activity$$FastClassByCGLIB$$a89e54a2.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.StructuredActivity$End$$EnhancerByCGLIB$$756f66da.leave() at org.jbpm.bpel.def.StructuredActivity.leave(StructuredActivity.java:60) at org.jbpm.bpel.def.StructuredActivity$End.execute(StructuredActivity.java:243) at org.jbpm.bpel.def.Activity.enter(Activity.java:101) ... 382 more Caused by: org.jbpm.graph.def.DelegationException at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:352) at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:346) at org.jbpm.graph.def.GraphElement$$FastClassByCGLIB$$7a7d6aa6.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.raiseException() at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:346) at org.jbpm.graph.def.GraphElement$$FastClassByCGLIB$$7a7d6aa6.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.raiseException() at org.jbpm.graph.def.GraphElement.raiseException(GraphElement.java:346) at org.jbpm.bpel.def.Activity.enter(Activity.java:106) at org.jbpm.bpel.def.Activity$$FastClassByCGLIB$$a89e54a2.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.StructuredActivity$End$$EnhancerByCGLIB$$756f66da.enter() at org.jbpm.graph.def.Transition.take(Transition.java:119) at org.jbpm.graph.def.Node.leave(Node.java:383) at org.jbpm.bpel.def.Activity.leave(Activity.java:171) at org.jbpm.bpel.def.Activity$$FastClassByCGLIB$$a89e54a2.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.StructuredActivity$End$$EnhancerByCGLIB$$756f66da.leave() at org.jbpm.bpel.def.StructuredActivity.leave(StructuredActivity.java:60) at org.jbpm.bpel.def.Activity$$FastClassByCGLIB$$a89e54a2.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.leave() at org.jbpm.bpel.def.StructuredActivity$End.execute(StructuredActivity.java:243) at org.jbpm.bpel.def.Activity.enter(Activity.java:101) ... 396 more Caused by: java.lang.NullPointerException at org.jbpm.bpel.exe.ScopeInstance.completed(ScopeInstance.java:89) at org.jbpm.bpel.exe.ScopeInstance$$FastClassByCGLIB$$9f4730a3.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.exe.ScopeInstance$$EnhancerByCGLIB$$4a30b613.completed() at org.jbpm.bpel.def.Activity.leave(Activity.java:180) at org.jbpm.bpel.def.Activity$$FastClassByCGLIB$$a89e54a2.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.StructuredActivity$End$$EnhancerByCGLIB$$756f66da.leave() at org.jbpm.bpel.def.StructuredActivity.leave(StructuredActivity.java:60) at org.jbpm.bpel.def.Activity$$FastClassByCGLIB$$a89e54a2.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.leave() at org.jbpm.bpel.def.StructuredActivity$End.execute(StructuredActivity.java:243) at org.jbpm.bpel.def.Activity.enter(Activity.java:101) ... 414 more 17:47:53,740 WARN [JDBCExceptionReporter] SQL Error: 1205, SQLState: 4000117:47:53,740 ERROR [JDBCExceptionReporter] Your server command (family id #0, process id #541) encountered a deadlock situation. Please re-run your command. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 511, SQLState: ZZZZZ17:47:53,805 ERROR [JDBCExceptionReporter] Attempt to update or insert row failed because resultant row of size 4024 bytes is larger than the maximum size (1961 bytes) allowed for this table. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 3621, SQLState: 01ZZZ 17:47:53,805 ERROR [JDBCExceptionReporter] Command has been aborted. 17:47:53,805 ERROR [SchedulerSession] org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.scheduler.exe.Timer]17:47:53,938 ERROR [AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)org.hibernate.AssertionFailure: null id in org.jbpm.graph.log.NodeLog entry (don't flush the Session after an exception occurs) at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:48) at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:140) at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:97) at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:195) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(Abstrac! tFlushingEventListener.java:76) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345) at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59) at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1473) at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1092) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:306) at org.jboss.tm.TxManager.commit(TxManager.java:224) at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:126) at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:146) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.leave() at org.jbpm.bpel.def.StructuredActivity$End.execute(StructuredActivity.java:243) at org.jbpm.bpel.def.Activity.enter(Activity.java:101) ... 414 more 17:47:53,740 WARN [JDBCExceptionReporter] SQL Error: 1205, SQLState: 40001 17:47:53,740 ERROR [JDBCExceptionReporter] Your server command (family id #0, process id #541) encountered a deadlock situation. Please re-run your command. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 511, SQLState: ZZZZZ 17:47:53,805 ERROR [JDBCExceptionReporter] Attempt to update or insert row failed because resultant row of size 4024 bytes is larger than the maximum size (1961 bytes) allowed for this table. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 3621, SQLState: 01ZZZ 17:47:53,805 ERROR [JDBCExceptionReporter] Command has been aborted. 17:47:53,805 ERROR [SchedulerSession] org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.scheduler.exe.Timer] 17:47:53,938 ERROR [AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session) org.hibernate.AssertionFailure: null id in org.jbpm.graph.log.NodeLog entry (don't flush the Session after an exception occurs) at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:48) at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:140) at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:97) at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:195) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345) at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59) at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1473) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.leave() at org.jbpm.bpel.def.StructuredActivity$End.execute(StructuredActivity.java:243) at org.jbpm.bpel.def.Activity.enter(Activity.java:101) ... 414 more 17:47:53,740 WARN [JDBCExceptionReporter] SQL Error: 1205, SQLState: 40001 17:47:53,740 ERROR [JDBCExceptionReporter] Your server command (family id #0, process id #541) encountered a deadlock situation. Please re-run your command. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 511, SQLState: ZZZZZ 17:47:53,805 ERROR [JDBCExceptionReporter] Attempt to update or insert row failed because resultant row of size 4024 bytes is larger than the maximum size (1961 bytes) allowed for this table. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 3621, SQLState: 01ZZZ 17:47:53,805 ERROR [JDBCExceptionReporter] Command has been aborted. 17:47:53,805 ERROR [SchedulerSession] org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.scheduler.exe.Timer] 17:47:53,938 ERROR [AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session) 68372,85-92 43% at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:136) at org.jbpm.bpel.def.CompositeActivity$$EnhancerByCGLIB$$4001fbf3.leave() at org.jbpm.bpel.def.StructuredActivity$End.execute(StructuredActivity.java:243) at org.jbpm.bpel.def.Activity.enter(Activity.java:101) ... 414 more 17:47:53,740 WARN [JDBCExceptionReporter] SQL Error: 1205, SQLState: 40001 17:47:53,740 ERROR [JDBCExceptionReporter] Your server command (family id #0, process id #541) encountered a deadlock situation. Please re-run your command. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 511, SQLState: ZZZZZ 17:47:53,805 ERROR [JDBCExceptionReporter] Attempt to update or insert row failed because resultant row of size 4024 bytes is larger than the maximum size (1961 bytes) allowed for this table. 17:47:53,805 WARN [JDBCExceptionReporter] SQL Error: 3621, SQLState: 01ZZZ 17:47:53,805 ERROR [JDBCExceptionReporter] Command has been aborted. 17:47:53,805 ERROR [SchedulerSession] org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.scheduler.exe.Timer] 17:47:53,938 ERROR [AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session) org.hibernate.AssertionFailure: null id in org.jbpm.graph.log.NodeLog entry (don't flush the Session after an exception occurs) at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:48) at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:140) at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:97) at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:195) at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:905) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:345) at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59) at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1473) at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1092) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:306) at org.jboss.tm.TxManager.commit(TxManager.java:224) at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:126) at org.hibernate.transaction.JTATransaction.commit(JTATransaction.java:146) at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:162) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032811#4032811 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032811 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user