db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kai Duckwitz (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 Thu, 30 Oct 2014 06:26:34 GMT

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

Mime
View raw message