Uploaded image for project: 'RiftSaw'
  1. RiftSaw
  2. RIFTSAW-41

Deadlock in Derby running simultaneous "Hello World" invocations

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • 2.0-CR1
    • 2.0-M2
    • None

    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 :

      {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.
      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 :

      {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 : {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.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) :

      {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) 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 :

      {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.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_, 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 :

      {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 : {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 : {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

      Attachments

        Activity

          People

            rhn-support-hbraun Heiko Braun
            steeqs4 Martin Sarabura (Inactive)
            Archiver:
            rhn-support-adandapa Aitik Dandapat

            Dates

              Created:
              Updated:
              Resolved:
              Archived:

              PagerDuty