ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yebo <yebo1...@qq.com>
Subject Re: Problem error when start servicemix with ODE
Date Tue, 23 Sep 2008 01:42:28 GMT

The ODE that I am using is downloaded from the page:
http://www.apache.org/dyn/closer.cgi/ode/apache-ode-jbi-1.2.zip.

In user-guider i found many configure properties, but i didn't find them in
the directory apache-servicemix-3.2.2\data\smx\components\OdeBpelEngine,
why?

I have added   <jencks:poolingSupport id="poolingSupport"
    connectionMaxIdleMinutes="5"
    connectionMaxWaitMilliseconds="10000"
    poolMaxSize="100"
    poolMinSize="20" />  in the servicemix/conf/tx.xml file, did i configure
right?
And it still threw exceptions:

DEBUG - HttpComponent                  - Received exchange: status: Done,
role: provider
DEBUG - HttpComponent                  - Retrieved correlation id: null
WARN  - GeronimoConnectionEventListener - connectionErrorOccurred called
with null
ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks
and waiters is:
Lock : ROW, ODE_JOB, (3,6)
  Waiting XID : {690, X} , SA, delete from ODE_JOB where jobid = ? and
nodeid = ?
  Granted XID : {682, X}
Lock : ROW, ODE_JOB, (3,33)
  Waiting XID : {682, X} , SA, delete from ODE_JOB where jobid = ? and
nodeid = ?
  Granted XID : {690, X}
. The selected victim is XID : 690.
        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.LockSet.lockObject(Unknown
Source)
        at
org.apache.derby.impl.services.locks.SinglePool.lockAnObject(Unknown Source)
        at
org.apache.derby.impl.services.locks.SinglePool.lockObject(Unknown Source)
        at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(Unknown
Source)
        at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
        at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown
Sourc
e)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown
Source
)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown
Source
)
        at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
Source)
        at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown Source)
        at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown
Sourc
e)
        at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)

        at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)

        at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
        at org.apache.derby.impl.sql.execute.DeleteResultSet.setup(Unknown
Source)
        at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown
Source)
        at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.j
ava:103)
        at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:92)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:339)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
        at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)

        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
        at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
        at java.util.concurrent.FutureTask.run(FutureTask.java:123)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
WARN  - GeronimoConnectionEventListener - connectionErrorOccurred called
with null
ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks
and waiters is:
Lock : ROW, ODE_JOB, (3,6)
  Waiting XID : {691, X} , SA, delete from ODE_JOB where jobid = ? and
nodeid = ?
  Granted XID : {682, X}
Lock : ROW, ODE_JOB, (3,34)
  Waiting XID : {682, X} , SA, delete from ODE_JOB where jobid = ? and
nodeid = ?
  Granted XID : {691, X}
. The selected victim is XID : 691.
        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.LockSet.lockObject(Unknown
Source)
        at
org.apache.derby.impl.services.locks.SinglePool.lockAnObject(Unknown Source)
        at
org.apache.derby.impl.services.locks.SinglePool.lockObject(Unknown Source)
        at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(Unknown
Source)
        at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
        at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown
Sourc
e)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown
Source
)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown
Source
)
        at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
Source)
        at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown Source)
        at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown
Sourc
e)
        at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)

        at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)

        at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
        at org.apache.derby.impl.sql.execute.DeleteResultSet.setup(Unknown
Source)
        at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown
Source)
        at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.j
ava:103)
        at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:92)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:339)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
        at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)

        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
        at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
        at java.util.concurrent.FutureTask.run(FutureTask.java:123)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
WARN  - GeronimoConnectionEventListener - connectionErrorOccurred called
with null
ERROR 40001: A lock could not be obtained due to a deadlock, cycle of locks
and waiters is:
Lock : ROW, ODE_JOB, (3,6)
  Waiting XID : {692, X} , SA, delete from ODE_JOB where jobid = ? and
nodeid = ?
  Granted XID : {682, X}
Lock : ROW, ODE_JOB, (3,35)
  Waiting XID : {682, X} , SA, delete from ODE_JOB where jobid = ? and
nodeid = ?
  Granted XID : {692, X}
. The selected victim is XID : 692.
        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.LockSet.lockObject(Unknown
Source)
        at
org.apache.derby.impl.services.locks.SinglePool.lockAnObject(Unknown Source)
        at
org.apache.derby.impl.services.locks.SinglePool.lockObject(Unknown Source)
        at
org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(Unknown
Source)
        at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
        at
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown
Source)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown
Sourc
e)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown
Source
)
        at
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown
Source
)
        at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
Source)
        at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown Source)
        at
org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown
Source)
        at
org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown
Sourc
e)
        at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)

        at
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown
Source)

        at
org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown
Source)
        at org.apache.derby.impl.sql.execute.DeleteResultSet.setup(Unknown
Source)
        at org.apache.derby.impl.sql.execute.DeleteResultSet.open(Unknown
Source)
        at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
        at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
        at
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.j
ava:103)
        at
org.apache.ode.scheduler.simple.JdbcDelegate.deleteJob(JdbcDelegate.java:92)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:339)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4$1.call(SimpleScheduler.java:336)
        at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:174)

        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
        at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
        at java.util.concurrent.FutureTask.run(FutureTask.java:123)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
DEBUG - DeliveryChannelImpl            - Send
ID:192.168.174.1-11c8ccbd53c-2:12 in DeliveryChannel{O
deBpelEngine}
WARN  - Transaction                    - Unexpected exception from
beforeCompletion; transaction wil
l roll back
<openjpa-1.1.0-r422266:657916 fatal general error>
org.apache.openjpa.persistence.PersistenceExcepti
on: The transaction has been rolled back.  See the nested exceptions for
details on the errors that
occurred.
        at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2160)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2007)
        at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1905)
        at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1823)
        at
org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.
java:514)
        at
org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(TransactionImpl.
java:498)
        at
org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:472
)
        at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManage
rImpl.java:250)
        at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:183)

        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:335)
        at
org.apache.ode.scheduler.simple.SimpleScheduler$4.call(SimpleScheduler.java:332)
        at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
        at java.util.concurrent.FutureTask.run(FutureTask.java:123)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
Caused by: <openjpa-1.1.0-r422266:657916 nonfatal general error>
org.apache.openjpa.persistence.Pers
istenceException: No current connection. {INSERT INTO ODE_EVENT (EVENT_ID,
DETAIL, DATA, SCOPE_ID, T
STAMP, TYPE, INSTANCE_ID, PROCESS_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
[code=40000, state=08003]
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.narrow(SQLExceptions.java:146)
        at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4150)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
        at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
        at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManage
rImpl.java:74)
        at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java
:543)
        at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java
:105)
        at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUp
dateManager.java:56)
        at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)

        at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)

        at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:549)
        at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
        ... 15 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: No current
connection. {INSERT INTO OD
E_EVENT (EVENT_ID, DETAIL, DATA, SCOPE_ID, TSTAMP, TYPE, INSTANCE_ID,
PROCESS_ID) VALUES (?, ?, ?, ?
, ?, ?, ?, ?)} [code=40000, state=08003]
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.ja
va:201)
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecora
tor.java:57)
        at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement
(LoggingConnectionDecorator.java:228)
        at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.ja
va:164)
        at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCS
toreManager.java:1343)
        at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.ja
va:153)
        at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.prepareStatement(PreparedStat
ementManagerImpl.java:160)
        at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatem
entManagerImpl.java:114)
        at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(Batchi
ngPreparedStatementManagerImpl.java:82)
        at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStateme
ntManagerImpl.java:89)
        at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManage
rImpl.java:72)
        ... 22 more

-- 
View this message in context: http://www.nabble.com/Problem-error-when-start-servicemix-with-ODE-tp19602756p19619852.html
Sent from the Apache Ode User mailing list archive at Nabble.com.


Mime
View raw message