db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6766) java.sql.SQLException: nospc.U Unexpected no space error while attempting to update a row on page
Date Fri, 24 Oct 2014 22:04:33 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14183610#comment-14183610
] 

Mike Matrigali commented on DERBY-6766:
---------------------------------------

Unfortunately the info posted is not going to be enough to figure out what is going on.  These
bugs tend to be
about the state the page has gotten to previously, rather than the line number of the code
that finally hits the
problem.  Obviously the best thing would be reproducible test case, but seems from your description
you are
not sure what forces the issue.

any chance you have and can post the derby.log from when this error occurred.  It should have
logged a page
dump which may help understand the issue.  Previous changes for this issue should have beefed
up what is
logged in the case of the error so we have a better shot at tracking it down.

There have been a number of fixes in this area, and while they tend to have the same error
message symptom, they
have been different bugs in the code.

Some of the fixes in this area only help for new table created after the bug fix.  Can you
run offline compress on the table, and then report back if you still see the error after that.
 Running compress in this manner basically recreates all the underlying files, thus making
sure they are all created with the latest fixed code.

Usually this is not an option due to security of the data, but if you could provide a copy
of the database with the 
associated log files at the moment the error occurs (or soon after), one could analyse the
log and maybe see what change to the page caused the problem.  Often the problem is not the
change that hits the error, it is a previous change to the page or previous change to the
row that was the actual problem.  

> 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
>
> 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)

Mime
View raw message