ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Panahi" <mpan...@gmail.com>
Subject deadlock error for flow and invoke
Date Tue, 20 May 2008 01:35:58 GMT
Hello, I'm getting the following error when having this in my bpel:

                <flow name="GetPrinterQuote">
                    <bpws:invoke name="GetQuoteFromPrinterA"
partnerLink="PrinterVendorA"
                                 operation="getQuote"
portType="ns26:PrinterAPortType"
                                 inputVariable="GetQuoteIn1"
                                 outputVariable="GetQuoteOut1"/>
                    <bpws:invoke name="GetQuoteFromPrinterB"
partnerLink="PrinterVendorB"
                                 operation="getQuote"
portType="ns27:PrinterBPortType"
                                 inputVariable="GetQuoteIn2"
                                 outputVariable="GetQuoteOut2"/>
                    <bpws:invoke name="GetQuoteFromPrinterC"
partnerLink="PrinterVendorC"
                                 operation="getQuote"
portType="ns28:PrinterCPortType"
                                 inputVariable="GetQuoteIn3"
                                 outputVariable="GetQuoteOut3"/>
                </flow>

If I change flow to sequence it works fine. I notice the error is related to
derby. I am also using derby in my app. I hope there is no conflict.

Here is the version info:

mpanahi@mpanahi-laptop:~/ode/ode11svn$ svn info
Path: .
URL: http://svn.apache.org/repos/asf/ode/branches/APACHE_ODE_1.1
Repository Root: http://svn.apache.org/repos/asf
Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68
Revision: 651487
Node Kind: directory
Schedule: normal
Last Changed Author: mriou
Last Changed Rev: 650904
Last Changed Date: 2008-04-23 08:23:34 -0700 (Wed, 23 Apr 2008)

Sorry for the long stack trace.

-Mark





     [java] WARN  2008-05-19 18:26:37,227 [pool-2-thread-5]
org.apache.geronimo.connector.outbound.GeronimoConnectionEventListener:
connectionErrorOccurred called with null
     [java] java.sql.SQLException: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {427, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,10)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {427, X}
     [java] . The selected victim is XID : 427.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2125)
     [java]     at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1325)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:301)
     [java]     at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
     [java]     at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:92)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:339)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: ERROR 40001: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {427, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,10)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {427, X}
     [java] . The selected victim is XID : 427.
     [java]     at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:303)
     [java]     at
org.apache.derby.impl.services.locks.Deadlock.buildException(Deadlock.java:361)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:613)
     [java]     at
org.apache.derby.impl.services.locks.AbstractPool.lockObject(AbstractPool.java:117)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(ConcurrentPool.java:28)
     [java]     at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(RowLocking3.java:248)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:504)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:638)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(B2IRowLocking3.java:335)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(B2IRowLocking3.java:628)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(B2IRowLockingRR.java:112)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:304)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(BTreeScan.java:1809)
     [java]     at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(TableScanResultSet.java:680)
     [java]     at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:373)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(DMLWriteResultSet.java:127)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.setup(DeleteResultSet.java:252)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:136)
     [java]     at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:372)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
     [java]     ... 14 more
     [java] 18:26:37,227 WARN  [GeronimoConnectionEventListener]
connectionErrorOccurred called with null
     [java] java.sql.SQLException: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {427, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,10)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {427, X}
     [java] . The selected victim is XID : 427.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2125)
     [java]     at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1325)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:301)
     [java]     at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
     [java]     at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:92)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:339)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: ERROR 40001: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {427, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,10)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {427, X}
     [java] . The selected victim is XID : 427.
     [java]     at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:303)
     [java]     at
org.apache.derby.impl.services.locks.Deadlock.buildException(Deadlock.java:361)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:613)
     [java]     at
org.apache.derby.impl.services.locks.AbstractPool.lockObject(AbstractPool.java:117)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(ConcurrentPool.java:28)
     [java]     at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(RowLocking3.java:248)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:504)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:638)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(B2IRowLocking3.java:335)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(B2IRowLocking3.java:628)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(B2IRowLockingRR.java:112)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:304)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(BTreeScan.java:1809)
     [java]     at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(TableScanResultSet.java:680)
     [java]     at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:373)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(DMLWriteResultSet.java:127)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.setup(DeleteResultSet.java:252)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:136)
     [java]     at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:372)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
     [java]     ... 14 more
     [java] ERROR 2008-05-19 18:26:37,291 [pool-2-thread-5] Transaction:
Unexpected exception rolling back
org.apache.geronimo.connector.outbound.LocalXAResource@a1c627; continuing
with rollback
     [java] javax.transaction.xa.XAException
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:88)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:581)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: Unable to rollback
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:113)
     [java]     at
org.tranql.connector.AbstractManagedConnection$LocalTransactionImpl.rollback(AbstractManagedConnection.java:196)
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
     [java]     ... 11 more
     [java] Caused by: java.sql.SQLException: No current connection.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:103)
     [java]     at
org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:207)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(EmbedConnection.java:2100)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(EmbedConnection.java:2311)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:1694)
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:111)
     [java]     ... 13 more
     [java] 18:26:37,291 ERROR [Transaction] Unexpected exception rolling
back org.apache.geronimo.connector.outbound.LocalXAResource@a1c627;
continuing with rollback
     [java] javax.transaction.xa.XAException
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:88)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:581)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: Unable to rollback
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:113)
     [java]     at
org.tranql.connector.AbstractManagedConnection$LocalTransactionImpl.rollback(AbstractManagedConnection.java:196)
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
     [java]     ... 11 more
     [java] Caused by: java.sql.SQLException: No current connection.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:103)
     [java]     at
org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:207)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(EmbedConnection.java:2100)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(EmbedConnection.java:2311)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:1694)
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:111)
     [java]     ... 13 more
     [java] ERROR 2008-05-19 18:26:37,309 [pool-2-thread-5]
org.apache.ode.scheduler.simple.SimpleScheduler: Error while executing
transaction
     [java] javax.transaction.SystemException
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:585)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] 18:26:37,309 ERROR [SimpleScheduler] Error while executing
transaction
     [java] javax.transaction.SystemException
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:585)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] WARN  2008-05-19 18:26:37,343 [pool-2-thread-3]
org.apache.geronimo.connector.outbound.GeronimoConnectionEventListener:
connectionErrorOccurred called with null
     [java] java.sql.SQLException: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {428, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,11)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {428, X}
     [java] . The selected victim is XID : 428.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2125)
     [java]     at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1325)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:301)
     [java]     at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
     [java]     at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:92)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:339)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: ERROR 40001: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {428, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,11)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {428, X}
     [java] . The selected victim is XID : 428.
     [java]     at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:303)
     [java]     at
org.apache.derby.impl.services.locks.Deadlock.buildException(Deadlock.java:361)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:613)
     [java]     at
org.apache.derby.impl.services.locks.AbstractPool.lockObject(AbstractPool.java:117)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(ConcurrentPool.java:28)
     [java]     at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(RowLocking3.java:248)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:504)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:638)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(B2IRowLocking3.java:335)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(B2IRowLocking3.java:628)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(B2IRowLockingRR.java:112)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:304)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(BTreeScan.java:1809)
     [java]     at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(TableScanResultSet.java:680)
     [java]     at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:373)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(DMLWriteResultSet.java:127)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.setup(DeleteResultSet.java:252)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:136)
     [java]     at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:372)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
     [java]     ... 14 more
     [java] 18:26:37,343 WARN  [GeronimoConnectionEventListener]
connectionErrorOccurred called with null
     [java] java.sql.SQLException: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {428, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,11)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {428, X}
     [java] . The selected victim is XID : 428.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
     [java]     at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2125)
     [java]     at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1325)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
     [java]     at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:301)
     [java]     at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
     [java]     at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:92)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:339)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: ERROR 40001: A lock could not be obtained due to a
deadlock, cycle of locks and waiters is:
     [java] Lock : ROW, ODE_JOB, (2,6)
     [java]   Waiting XID : {428, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {426, X}
     [java] Lock : ROW, ODE_JOB, (3,11)
     [java]   Waiting XID : {426, X} , SA, delete from ODE_JOB where jobid =
? and nodeid = ?
     [java]   Granted XID : {428, X}
     [java] . The selected victim is XID : 428.
     [java]     at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:303)
     [java]     at
org.apache.derby.impl.services.locks.Deadlock.buildException(Deadlock.java:361)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:613)
     [java]     at
org.apache.derby.impl.services.locks.AbstractPool.lockObject(AbstractPool.java:117)
     [java]     at
org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(ConcurrentPool.java:28)
     [java]     at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(RowLocking3.java:248)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:504)
     [java]     at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:638)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(B2IRowLocking3.java:335)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(B2IRowLocking3.java:628)
     [java]     at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(B2IRowLockingRR.java:112)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:304)
     [java]     at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(BTreeScan.java:1809)
     [java]     at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(TableScanResultSet.java:680)
     [java]     at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:373)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255)
     [java]     at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(DMLWriteResultSet.java:127)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.setup(DeleteResultSet.java:252)
     [java]     at
org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java:136)
     [java]     at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:372)
     [java]     at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
     [java]     ... 14 more
     [java] ERROR 2008-05-19 18:26:37,400 [pool-2-thread-3] Transaction:
Unexpected exception rolling back
org.apache.geronimo.connector.outbound.LocalXAResource@60d27; continuing
with rollback
     [java] javax.transaction.xa.XAException
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:88)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:581)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: Unable to rollback
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:113)
     [java]     at
org.tranql.connector.AbstractManagedConnection$LocalTransactionImpl.rollback(AbstractManagedConnection.java:196)
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
     [java]     ... 11 more
     [java] Caused by: java.sql.SQLException: No current connection.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:103)
     [java]     at
org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:207)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(EmbedConnection.java:2100)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(EmbedConnection.java:2311)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:1694)
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:111)
     [java]     ... 13 more
     [java] 18:26:37,400 ERROR [Transaction] Unexpected exception rolling
back org.apache.geronimo.connector.outbound.LocalXAResource@60d27;
continuing with rollback
     [java] javax.transaction.xa.XAException
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:88)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:581)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] Caused by: Unable to rollback
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:113)
     [java]     at
org.tranql.connector.AbstractManagedConnection$LocalTransactionImpl.rollback(AbstractManagedConnection.java:196)
     [java]     at
org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
     [java]     ... 11 more
     [java] Caused by: java.sql.SQLException: No current connection.
     [java]     at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
     [java]     at
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:103)
     [java]     at
org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:207)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(EmbedConnection.java:2100)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(EmbedConnection.java:2311)
     [java]     at
org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:1694)
     [java]     at
org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:111)
     [java]     ... 13 more
     [java] ERROR 2008-05-19 18:26:37,409 [pool-2-thread-3]
org.apache.ode.scheduler.simple.SimpleScheduler: Error while executing
transaction
     [java] javax.transaction.SystemException
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:585)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] 18:26:37,409 ERROR [SimpleScheduler] Error while executing
transaction
     [java] javax.transaction.SystemException
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:585)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475)
     [java]     at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
     [java]     at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
     [java]     at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
     [java]     at java.util.concurrent.FutureTask.run(FutureTask.java:123)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
     [java]     at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
     [java]     at java.lang.Thread.run(Thread.java:595)
     [java] ERROR 2008-05-19 18:28:10,629 [btpool0-2]
org.apache.ode.axis2.ODEService: Timeout or execution error when waiting for
response to MEX {MyRoleMex#hqejbhcnphr3ad07nejk0v [Client
hqejbhcnphr3ad07nejk0u] calling {
http://j2ee.netbeans.org/wsdl/PrintAndMail}PrintAndMailService.PrintAndMailOperation(...)}
java.util.concurrent.TimeoutException: Message exchange
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@1429a7dtimed
out when waiting for a response!
     [java] 18:28:10,629 ERROR [ODEService] Timeout or execution error when
waiting for response to MEX {MyRoleMex#hqejbhcnphr3ad07nejk0v [Client
hqejbhcnphr3ad07nejk0u] calling {
http://j2ee.netbeans.org/wsdl/PrintAndMail}PrintAndMailService.PrintAndMailOperation(...)}
java.util.concurrent.TimeoutException: Message exchange
org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@1429a7dtimed
out when waiting for a response!

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message