[jira] [Commented] (DERBY-6319) Intermittent ERROR nospc: nospc.U at org.apache.derby.impl.store.raw.data.StoredPage.logRow

["Mike Matrigali (JIRA)" <ji...@apache.org>]

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

Mike Matrigali commented on DERBY-6319:
---------------------------------------

may be duplicate of derby-4923, but never had a repro so not sure.  Customer got an updated 10.8 release that had a fix for DERBY-4923 and for DERBY-4920 and have not seen the issue in the field again with that release.  

> Intermittent ERROR nospc: nospc.U at org.apache.derby.impl.store.raw.data.StoredPage.logRow
> -------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6319
>                 URL: https://issues.apache.org/jira/browse/DERBY-6319
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.8.2.2
>         Environment: Environment: Derby - 10.8.2.2 - (1181258)
> JRE 1.6.0 IBM J9 2.4 Linux x86-32 jvmxi3260sr12-20121024_126067 (JIT enabled, AOT enabled)
> J9VM - 20121024_126067
> JIT - r9_20120914_26057
> GC - 20120928_AA
> Derby properties
> Derby properties set:
> derby.infolog.append=true
> derby.storage.pageCacheSize=10000
> #Set page size to 4K to avoid possible corruption on power loss
> derby.storage.pageSize=4096
> # Set sort buffer size to 10MB
> derby.storage.sortBufferMax=10240
> derby.locks.escalationThreshold=2147483647
>            Reporter: Kathey Marsden
>
> I do not have much information on this issue yet, but am filing this bug as a placeholder as I get more. On a system with 4K pageSize set, under heavy load, user is seeing the following exception intermittently, (once every few days). Indication is that with the same data, the problem does not reproduce so not likely to be DERBY-4923.
> Failed Statement and stack trace: (Data content changed but not length of data) 
> Failed Statement is: update XML_DOCUMENT set NODES=?, TEXT=?, NAME_TABLE=? where GUID=? with 4 parameters begin parameter #1: BLOB:Length=3697 :end parameter begin parameter #2: 123412341234123412341234123412341232324343214124234124234243211421321323213232132131231232131231232132132131232132132132131231123213213213213213213212321321321321321321321321312321321312312321321312312321312312321321321321312321321321321321321321213213123123213123122311 :end parameter begin parameter #3: BLOB:Length=164 :end parameter begin parameter #4: 8B8B8B8B8B8B8B80B064FFF2FFFF2F05 :end parameter 
> ERROR nospc: nospc.U
> at org.apache.derby.impl.store.raw.data.StoredPage.logRow(Unknown Source)
> at org.apache.derby.impl.store.raw.data.InsertOperation.writeOptionalDataToBuffer(Unknown Source)
> at org.apache.derby.impl.store.raw.data.InsertOperation.<init>(Unknown Source)
> at org.apache.derby.impl.store.raw.data.LoggableActions.actionInsert(Unknown Source)
> at org.apache.derby.impl.store.raw.data.BasePage.insertAllowOverflow(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)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeBatchElement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(Unknown Source)
> at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
> at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
> at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
> at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
> at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2354)
> at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)
> at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
> at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
> at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
> ...



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)