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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2015/08/30 16:53:45 UTC
[jira] [Updated] (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:all-tabpanel ]
Rick Hillegas updated DERBY-6766:
---------------------------------
Urgency: Normal (was: Blocker)
> 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: IDD.DDL, console.zip, derby.log
>
>
> 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.4#6332)