You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <ji...@apache.org> on 2008/04/04 21:53:24 UTC

[jira] Commented: (DERBY-3381) "ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page...." in suites.All

    [ https://issues.apache.org/jira/browse/DERBY-3381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12585728#action_12585728 ] 

Mamta A. Satoor commented on DERBY-3381:
----------------------------------------

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

> "ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page...." in suites.All
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3381
>                 URL: https://issues.apache.org/jira/browse/DERBY-3381
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.4.0.0
>         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)
>            Reporter: Ole Solberg
>            Priority: Minor
>
> '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/%3C2526D42D65F597428BFF422D6AB79E9E0108FC40@NA1000EXM01.na.ds.monsanto.com%3E

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.