Description
Ran a trivial stress test of "Hello World" and got this in the log:
2009-09-03 10:18:29,635 WARN [org.hibernate.util.JDBCExceptionReporter] (ODEServerImpl-6) SQL Error: 30000, SQLState: 40001
2009-09-03 10:18:29,635 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServerImpl-6) A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID :
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID : {745, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {748, X}
. The selected victim is XID : 748.
2009-09-03 10:18:29,666 INFO [STDOUT] (ODEServerImpl-6) ERROR - JacobVPU$JacobThreadImpl.run(463) | Method "run" in class "org.apache.ode.bpel.rtrep.v2.ASSIGN" threw an unexpected exception.
org.hibernate.exception.LockAcquisitionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.apache.ode.daohib.bpel.ScopeDaoImpl.getVariable(ScopeDaoImpl.java:138)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.fetchVariableData(BpelRuntimeContextImpl.java:366)
at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.fetchVariableData(RuntimeInstanceImpl.java:155)
at org.apache.ode.bpel.rtrep.v2.ACTIVITY.fetchVariableData(ACTIVITY.java:140)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.fetchVariableData(ASSIGN.java:441)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.evalRValue(ASSIGN.java:185)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.copy(ASSIGN.java:353)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.run(ASSIGN.java:76)
at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.execute(RuntimeInstanceImpl.java:639)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:616)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.executeCreateInstance(BpelRuntimeContextImpl.java:604)
at org.apache.ode.bpel.engine.ODEProcess.executeCreateInstance(ODEProcess.java:384)
at org.apache.ode.bpel.engine.ODEProcess$2.call(ODEProcess.java:306)
at org.apache.ode.bpel.engine.ODEProcess$2.call(ODEProcess.java:305)
at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:1242)
at org.apache.ode.bpel.engine.BpelInstanceWorker.doInstanceWork(BpelInstanceWorker.java:174)
at org.apache.ode.bpel.engine.BpelInstanceWorker.execInCurrentThread(BpelInstanceWorker.java:108)
at org.apache.ode.bpel.engine.ODEProcess.doInstanceWork(ODEProcess.java:504)
at org.apache.ode.bpel.engine.ODEProcess.invokeProcess(ODEProcess.java:304)
at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.doInvoke(MyRoleMessageExchangeImpl.java:129)
at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:46)
at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:45)
at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:1242)
at org.apache.ode.bpel.engine.Contexts.execTransaction(Contexts.java:106)
at org.apache.ode.bpel.engine.BpelServerImpl$TransactedCallable.call(BpelServerImpl.java:972)
at org.apache.ode.bpel.engine.BpelServerImpl$ServerCallable.call(BpelServerImpl.java:952)
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:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S}
, SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID :
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID : {745, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {748, X}
. The selected victim is XID : 748.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1196)
at org.hibernate.loader.Loader.doQuery(Loader.java:720)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 43 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID :
Granted XID : {748, X}
. The selected victim is XID : 748.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 56 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID : {745, S}
, SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID
2009-09-03 10:18:29,666 INFO [STDOUT] (ODEServerImpl-6) :
. The selected victim is XID : 748.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
... 49 more
2009-09-03 10:18:29,681 INFO [STDOUT] (ODEServerImpl-6) ERROR - BpelInstanceWorker.doInstanceWork(176) | Work for instance {http://www.jboss.org/bpel/examples}HelloWorld-1#163845 in thread Thread[ODEServerImpl-6,5,jboss] resulted in an exception.
java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:464)
at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.execute(RuntimeInstanceImpl.java:639)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:616)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.executeCreateInstance(BpelRuntimeContextImpl.java:604)
at org.apache.ode.bpel.engine.ODEProcess.executeCreateInstance(ODEProcess.java:384)
at org.apache.ode.bpel.engine.ODEProcess$2.call(ODEProcess.java:306)
at org.apache.ode.bpel.engine.ODEProcess$2.call(ODEProcess.java:305)
at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:1242)
at org.apache.ode.bpel.engine.BpelInstanceWorker.doInstanceWork(BpelInstanceWorker.java:174)
at org.apache.ode.bpel.engine.BpelInstanceWorker.execInCurrentThread(BpelInstanceWorker.java:108)
at org.apache.ode.bpel.engine.ODEProcess.doInstanceWork(ODEProcess.java:504)
at org.apache.ode.bpel.engine.ODEProcess.invokeProcess(ODEProcess.java:304)
at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.doInvoke(MyRoleMessageExchangeImpl.java:129)
at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:46)
at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:45)
at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:1242)
at org.apache.ode.bpel.engine.Contexts.execTransaction(Contexts.java:106)
at org.apache.ode.bpel.engine.BpelServerImpl$TransactedCallable.call(BpelServerImpl.java:972)
at org.apache.ode.bpel.engine.BpelServerImpl$ServerCallable.call(BpelServerImpl.java:952)
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:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.apache.ode.daohib.bpel.ScopeDaoImpl.getVariable(ScopeDaoImpl.java:138)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.fetchVariableData(BpelRuntimeContextImpl.java:366)
at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.fetchVariableData(RuntimeInstanceImpl.java:155)
at org.apache.ode.bpel.rtrep.v2.ACTIVITY.fetchVariableData(ACTIVITY.java:140)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.fetchVariableData(ASSIGN.java:441)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.evalRValue(ASSIGN.java:185)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.copy(ASSIGN.java:353)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.run(ASSIGN.java:76)
at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
... 24 more
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID : {745, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {748, X}
. The selected victim is XID : 748.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1196)
at org.hibernate.loader.Loader.doQuery(Loader.java:720)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 43 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID :
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID : {745, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {748, X}
. The selected victim is XID : 748.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 56 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S}
, SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID :
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID : {745, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hx
2009-09-03 10:18:29,681 INFO [STDOUT] (ODEServerImpl-6) mldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {748, X}
. The selected victim is XID : 748.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
... 49 more
2009-09-03 10:18:29,681 INFO [STDOUT] (ODEServerImpl-6) DEBUG - BpelInstanceWorker.doInstanceWork(180) | Finished work for instance {http://www.jboss.org/bpel/examples}HelloWorld-1#163845 in thread Thread[ODEServerImpl-6,5,jboss]
2009-09-03 10:18:29,681 INFO [STDOUT] (ODEServerImpl-10) DEBUG - BpelInstanceWorker.doInstanceWork(180) | Finished work for instance {http://www.jboss.org/bpel/examples}HelloWorld-1#163845 in thread Thread[ODEServerImpl-10,5,jboss]
2009-09-03 10:18:29,697 INFO [STDOUT] (ODEServerImpl-10) DEBUG - BpelInstanceWorker.run(133) | Worker thread Thread[ODEServerImpl-10,5,jboss] for instance IID 163845 ran out of work.
2009-09-03 10:18:29,697 INFO [STDOUT] (ODEServerImpl-6) FATAL - BpelServerImpl$ServerCallable.call(955) | Internal Error
org.apache.ode.bpel.iapi.BpelEngineException: java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.apache.ode.bpel.engine.ODEProcess.doInstanceWork(ODEProcess.java:507)
at org.apache.ode.bpel.engine.ODEProcess.invokeProcess(ODEProcess.java:304)
at org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.doInvoke(MyRoleMessageExchangeImpl.java:129)
at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:46)
at org.apache.ode.bpel.engine.UnreliableMyRoleMessageExchangeImpl$1.call(UnreliableMyRoleMessageExchangeImpl.java:45)
at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:1242)
at org.apache.ode.bpel.engine.Contexts.execTransaction(Contexts.java:106)
at org.apache.ode.bpel.engine.BpelServerImpl$TransactedCallable.call(BpelServerImpl.java:972)
at org.apache.ode.bpel.engine.BpelServerImpl$ServerCallable.call(BpelServerImpl.java:952)
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:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:464)
at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139)
at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.execute(RuntimeInstanceImpl.java:639)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:616)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.executeCreateInstance(BpelRuntimeContextImpl.java:604)
at org.apache.ode.bpel.engine.ODEProcess.executeCreateInstance(ODEProcess.java:384)
at org.apache.ode.bpel.engine.ODEProcess$2.call(ODEProcess.java:306)
at org.apache.ode.bpel.engine.ODEProcess$2.call(ODEProcess.java:305)
at org.apache.ode.bpel.engine.ODEProcess$ProcessCallable.call(ODEProcess.java:1242)
at org.apache.ode.bpel.engine.BpelInstanceWorker.doInstanceWork(BpelInstanceWorker.java:174)
at org.apache.ode.bpel.engine.BpelInstanceWorker.execInCurrentThread(BpelInstanceWorker.java:108)
at org.apache.ode.bpel.engine.ODEProcess.doInstanceWork(ODEProcess.java:504)
... 13 more
Caused by: org.hibernate.exception.LockAcquisitionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2231)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.apache.ode.daohib.bpel.ScopeDaoImpl.getVariable(ScopeDaoImpl.java:138)
at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.fetchVariableData(BpelRuntimeContextImpl.java:366)
at org.apache.ode.bpel.rtrep.v2.RuntimeInstanceImpl.fetchVariableData(RuntimeInstanceImpl.java:155)
at org.apache.ode.bpel.rtrep.v2.ACTIVITY.fetchVariableData(ACTIVITY.java:140)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.fetchVariableData(ASSIGN.java:441)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.evalRValue(ASSIGN.java:185)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.copy(ASSIGN.java:353)
at org.apache.ode.bpel.rtrep.v2.ASSIGN.run(ASSIGN.java:76)
at sun.reflect.GeneratedMethodAccessor291.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451)
... 24 more
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID :
Granted XID : {748, X}
. The selected victim is XID : 748.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.next(WrappedResultSet.java:1196)
at org.hibernate.loader.Loader.doQuery(Loader.java:720)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
... 43 more
Caused by: java.sql.SQLException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
Waiting XID : {745, S}
, SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID :
. The selected victim is XID : 748.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 56 more
Caused by: ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, BPEL_XML_DATA, (1,11)
Waiting XID : {748, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {745, X}
Lock : ROW, BPEL_XML_DATA, (1,12)
2009-09-03 10:18:29,697 INFO [STDOUT] (ODEServerImpl-6) Waiting XID : {745, S} , SA, select hxmldata0_.ID as ID12_, hxmldata0_.LDATA_ID as LDATA2_12_, hxmldata0_.NAME as NAME12_, hxmldata0_.SCOPE_ID as SCOPE4_12_, hxmldata0_.PIID as PIID12_, hxmldata0_.IS_SIMPLE_TYPE as IS6_12_, hxmldata0_.INSERT_TIME as INSERT7_12_, hxmldata0_.MLOCK as MLOCK12_ from BPEL_XML_DATA hxmldata0_ where hxmldata0_.NAME=? and hxmldata0_.SCOPE_ID=?
Granted XID : {748, X}
. The selected victim is XID : 748.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown Source)
at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown Source)
at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.lockPositionForRead(Unknown Source)
at org.apache.derby.impl.store.access.conglomerate.GenericScanController.fetchRows(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapScan.fetchNextGroup(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
... 49 more