[ https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14189699#comment-14189699 ]
Kai Duckwitz commented on DERBY-6766: ------------------------------------- the attached derby.log seems not to be very substantial regarding the problem. Unfortunately there is no other logfile. Mostly there are inserts and updates and only once a day there is a "delete-job" about midnight. But you are right, quiet seldom there can also be a few deletes on objects/rows in a normal transaction (where the error occured), but in the same transaction there are always inserts and updates. Unfortunately I don't know which query/object/row produced the error. The biggest column is varchar (2000). The other datatypes are timestamp(29) smallint(5) numeric(19) and varchar(2-2000) > 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 > > > 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)