db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremiah Jahn <jerem...@goodinassociates.com>
Subject lock timeout problems
Date Tue, 08 Feb 2005 21:37:38 GMT
I have autocommit set to true and one process accessing the system at a
time. anyone know of a reason that a delete * from a table would give me
this message?

ERROR 40XL1: A lock could not be obtained within the time requested
	at org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
	at org.apache.derby.impl.services.locks.LockSet.lockObject(LockSet.java)
	at org.apache.derby.impl.services.locks.SinglePool.lockAnObject(SinglePool.java)
	at org.apache.derby.impl.services.locks.SinglePool.lockObject(SinglePool.java)
	at org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(RowLocking3.java)
	at org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java)
	at org.apache.derby.impl.store.access.heap.HeapController.lockRow(HeapController.java)
	at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(B2IRowLocking3.java)
	at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(B2IRowLocking3.java)
	at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(B2IRowLockingRR.java)
	at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java)
	at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java)
	at org.apache.derby.impl.sql.execute.IndexChanger.doDelete(IndexChanger.java)
	at org.apache.derby.impl.sql.execute.IndexChanger.delete(IndexChanger.java)
	at org.apache.derby.impl.sql.execute.IndexSetChanger.delete(IndexSetChanger.java)
	at org.apache.derby.impl.sql.execute.RowChangerImpl.deleteRow(RowChangerImpl.java)
	at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(DeleteResultSet.java)
	at org.apache.derby.impl.sql.execute.DeleteResultSet.open(DeleteResultSet.java)
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java)
	at com.goodinassociates.evidencetracking.functionaltests.DatabaseTestHelper.cleanTable(DatabaseTestHelper.java:598)
	at com.goodinassociates.evidencetracking.functionaltests.DatabaseTestHelper.cleanOrganizationTable(DatabaseTestHelper.java:135)
	at com.goodinassociates.evidencetracking.functionaltests.DatabaseTestHelper.prepareOrganizationTable(DatabaseTestHelper.java:112)
	at com.goodinassociates.evidencetracking.organization.OrganizationTest.setUp(OrganizationTest.java:35)
	at junit.framework.TestCase.runBare(TestCase.java:125)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:118)
	at junit.framework.TestSuite.runTest(TestSuite.java:208)
	at junit.framework.TestSuite.run(TestSuite.java:203)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:421)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:305)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:186)


The men sat sipping their tea in silence. After a while the klutz said,
"Life is like a bowl of sour cream." "Like a bowl of sour cream?" asked
the other. "Why?" "How should I know? What am I, a philosopher?"

Mime
View raw message