Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[smila-user] Lock could not be obtained

Hi,

when running SMILA for several days, the appended messages start to fill the log. As those are emitted once per minute, the log becomes quite unreadable. What is the reason for these messages and how can I stop them from occuring?

Stephan



2012-04-17 10:01:12,818 WARN [OdeScheduler ] outbound.GeronimoConnectionEventListener - connectionErrorOccurred called with null java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:88) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1648) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(EmbedPreparedStatement.java:270) at org.tranql.connector.jdbc.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:49) at org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:167) at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:393) at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:392) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:154) at org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:391) at org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:507) at org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java:372) at org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:153)
        at java.lang.Thread.run(Thread.java:636)
Caused by: java.sql.SQLException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
        ... 18 more
Caused by: ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:276) at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:602) at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(ConcurrentLockSet.java:855) at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(AbstractPool.java:297) at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(ConcurrentPool.java:28) at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(RowLocking2nohold.java:89) at org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:520) at org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java:638) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(B2IRowLocking3.java:309) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(B2IRowLocking3.java:599) at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(B2IRowLockingRR.java:105) at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:305) at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(BTreeScan.java:1740) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(BulkTableScanResultSet.java:327) at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(BulkTableScanResultSet.java:282) at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:373) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255) at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:255) at org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(SortResultSet.java:574) at org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(SortResultSet.java:561) at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(SortResultSet.java:314) at org.apache.derby.impl.sql.execute.SortResultSet.openCore(SortResultSet.java:268) at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(BasicNoPutResultSetImpl.java:245) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
        ... 12 more
2012-04-17 10:01:12,818 ERROR [OdeScheduler ] Transaction - Unexpected exception rolling back org.apache.geronimo.connector.outbound.LocalXAResource@1b6f236d; continuing with rollback
javax.transaction.xa.XAException
at org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:88) at org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:581) at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475) at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:165) at org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:391) at org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:507) at org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java:372) at org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:153)
        at java.lang.Thread.run(Thread.java:636)
Caused by: javax.resource.spi.LocalTransactionException: Unable to rollback
at org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:113) at org.tranql.connector.AbstractManagedConnection$LocalTransactionImpl.rollback(AbstractManagedConnection.java:196) at org.apache.geronimo.connector.outbound.LocalXAResource.rollback(LocalXAResource.java:86)
        ... 9 more
Caused by: java.sql.SQLNonTransientConnectionException: No current connection. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:76) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:103) at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Util.java:207) at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(EmbedConnection.java:2176) at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(EmbedConnection.java:2387) at org.apache.derby.impl.jdbc.EmbedConnection.rollback(EmbedConnection.java:1761) at org.tranql.connector.jdbc.ManagedJDBCConnection.localTransactionRollback(ManagedJDBCConnection.java:111)
        ... 11 more
Caused by: java.sql.SQLException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
        ... 18 more
2012-04-17 10:01:12,818 ERROR [OdeScheduler ] simple.SimpleScheduler - Error loading immediate jobs from database.
javax.transaction.SystemException
at org.apache.geronimo.transaction.manager.TransactionImpl.rollbackResources(TransactionImpl.java:585) at org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:475) at org.apache.geronimo.transaction.manager.TransactionManagerImpl.rollback(TransactionManagerImpl.java:250) at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:165) at org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:391) at org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:507) at org.apache.ode.scheduler.simple.SimpleScheduler.runTask(SimpleScheduler.java:372) at org.apache.ode.scheduler.simple.SchedulerThread.run(SchedulerThread.java:153)
        at java.lang.Thread.run(Thread.java:636)



--
Stephan Mehlhase

European Media Laboratory GmbH
Schloss-Wolfsbrunnenweg 35
69118 Heidelberg

Amtsgericht Mannheim / HRB 335719
Managing Partner: Dr. h. c. Dr.-Ing. E. h. Klaus Tschira, Scientific and Managing
Director: Prof. Dr.-Ing. Andreas Reuter

http://www.eml-development.de

Testen Sie auch unsere neue Android Applikation zur Mediensteuerung:
http://market.android.com/search?q=pname:org.eml.upnp



Back to the top