[
https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16030712#comment-16030712
]
Vamsavardhana Reddy commented on DERBY-6766:
--------------------------------------------
Does this database corruption happen due to load on the database or is it
because of specific data that is handled by the database? Anything specific
that causes this corruption and any suggestions to avoid this issue?
> java.sql.SQLException: nospc.U Unexpected no space error while attempting to
> update a row on page
> --------------------------------------------------------------------------------------------------
>
> Key: DERBY-6766
> URL: https://issues.apache.org/jira/browse/DERBY-6766
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.10.2.0
> Environment: Derby 10.10.2.0 - (1582446), AIX 6.1.0.0
> (6100-08-03-1339), Hibernate 3.5.6-Final, Java 1.6.0 IBM J9 VM (build 2.4,
> JRE 1.6.0 IBM J9 2.4 AIX ppc64-64)
> Reporter: Kai Duckwitz
> Priority: Critical
> Labels: nospc
> Attachments: console.zip, derby.log, IDD.DDL
>
>
> We already had this error with version 10.8.2.2 an hoped that it would be
> fixed in 10.10.2.0 due to [DERBY-4923] - but it is not.
> This error occurs sporadically on updating or inserting objects via
> hibernate. The application runs for weeks without a problem (20-50 object
> updates/inserts per second) and then the error occures up to 10 times in 2
> hours; after that the error can be absent for days or weeks.
> We use only these data types:
> NUMERIC,SMALLINT,TIMESTAMP,VARCHAR
> Stacktrace:
> Caused by: java.sql.SQLException: Unexpected no space error while attempting
> to update a row on page Page(94,Container(0, 1632)). Values of internal
> fields at time of error are as follows: slot = 301, recordId = 28,
> newColumnList = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}, nextColumn = -1,
> mode = 0, nextPortionHandle = null, page dump =
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 51 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> 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)
> ... 48 more
> Caused by: ERROR nospc: nospc.U
> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.UpdateOperation.writeOptionalDataToBuffer(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.UpdateOperation.<init>(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.LoggableActions.actionUpdate(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.doUpdateAtSlot(Unknown Source)
> at org.apache.derby.impl.store.raw.data.BasePage.updateAtSlot(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.conglomerate.GenericConglomerateController.replace(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.RowChangerImpl.updateRow(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.UpdateResultSet.collectAffectedRows(Unknown
> Source)
> at org.apache.derby.impl.sql.execute.UpdateResultSet.open(Unknown
> Source)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
