[ https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16031185#comment-16031185 ]
Bryan Pendleton commented on DERBY-6766: ---------------------------------------- @Vamsarvardhana Reddy, were you able to collect any of the additional information or try any of the additional experiments suggested in this comment? https://issues.apache.org/jira/browse/DERBY-6766?focusedCommentId=14183610&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14183610 > 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)