"ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page...." in suites.All

• Key: DERBY-3381
• Type: Bug
• Status: Closed
• Resolution: Duplicate
• Priority: Minor
• Assignee: Mike Matrigali
• Reporter: Ole Solberg
• Component/s: Test
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.4.2.0, 10.5.1.1

Environment

OS: Solaris Express Community Edition snv_70 X86bits SunOS 5.11 snv_70
JVM: java version "1.6.0_04", Java(TM) SE Runtime Environment (build 1.6.0_04-b12), Java HotSpot(TM) Server VM (build 10.0-b19, mixed mode)

Description

'ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation.'

See http://dbtg.thresher.com/derby/test/Daily/jvm1.6/testing/testlog/solN+1/618017-suitesAll_diff.txt


There was also a discussion on 'ERROR XSDA3' in http://mail-archives.apache.org/mod_mbox/db-derby-user/200701.mbox/[e-mail]%3E

Comments

[Knut Anders Hatlen]

Happened again: http://dbtg.thresher.com/derby/test/Daily/jvm1.6/testing/testlog/sol/618327-suitesAll_diff.txt

[Mamta A. Satoor]

Happened on trunk with ibm1.6. The trace looked as follows
SetTransactionIsolation:embeddedjava.sql.SQLException: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation.
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.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.compressObjects(CleanDatabaseTestSetup.java:267)
at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.cleanDatabase(CleanDatabaseTestSetup.java:166)
at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.setUp(CleanDatabaseTestSetup.java:109)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
Caused by: java.sql.SQLException: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 28 more
Caused by: ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.store.raw.data.CopyRowsOperation.writeOptionalDataToBuffer(Unknown Source)
at org.apache.derby.impl.store.raw.data.CopyRowsOperation.<init>(Unknown Source)
at org.apache.derby.impl.store.raw.data.LoggableActions.actionCopyRows(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.copyInto(Unknown Source)
at org.apache.derby.impl.store.raw.data.BasePage.copyAndPurge(Unknown Source)
at org.apache.derby.impl.store.raw.data.StoredPage.moveRecordForCompressAtSlot(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchRowsForCompress(Unknown Source)
at org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchNextGroup(Unknown Source)
at org.apache.derby.iapi.db.OnlineCompress.defragmentRows(Unknown Source)
at org.apache.derby.iapi.db.OnlineCompress.compressTable(Unknown Source)
at org.apache.derby.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown Source)
at org.apache.derby.exe.ac28ae19e3x0119x1a2ex714ex00000fb0cbff2.g0(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at <unknown class>.<unknown method>(Unknown Source)
at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 22 more

[Mike Matrigali]

I believe this is a duplicate of DERBY-3625, which has been fixed. The stack traces all look the same as the fixed bug.