db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vamsavardhana Reddy (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 Wed, 31 May 2017 06:44:04 GMT

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

Vamsavardhana Reddy commented on DERBY-6766:
--------------------------------------------

Does this database corruption happen due to load on the database or is it because of specific
data that is handled by the database?  Anything specific that causes this corruption and any
suggestions to avoid this issue?

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

Mime
View raw message