[DERBY-6766] java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 10.10.2.0
• Component/s: Store
• Labels: nospc
• 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)
• Urgency: Normal
• Bug behavior facts: Crash
• Assignee: Unassigned
• Reporter: Kai Grabfelder
• Created: 23/Oct/14 06:25
• Updated: 27/Jun/17 09:55

Description

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)

Issue Links

• is related to: DERBY-6897 org.apache.derby.impl.store.raw.data.NoSpaceOnPage: nospc.U