Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Wed, 28 Aug 2013 19:57:53 +0000 (UTC)
From: "Kathey Marsden (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12665995.1377719788768.48933.1377719873338@arcas>
In-Reply-To: <JIRA.12665995.1377719788768@arcas>
References: <JIRA.12665995.1377719788768@arcas>
Subject: [jira] [Created] (DERBY-6319) Intermittent ERROR nospc: nospc.U at
 org.apache.derby.impl.store.raw.data.StoredPage.logRow
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Kathey Marsden created DERBY-6319:
-------------------------------------

             Summary: 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira