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 "Vamsavardhana Reddy (JIRA)" <ji...@apache.org> on 2017/05/31 06:44:04 UTC
[jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U
Unexpected no space error while attempting to update a row on page
[ 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)