[
https://issues.apache.org/jira/browse/DERBY-6382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13799742#comment-13799742
]
ASF subversion and git services commented on DERBY-6382:
--------------------------------------------------------
Commit 1533682 from [~kmarsden] in branch 'code/branches/10.5'
[ https://svn.apache.org/r1533682 ]
DERBY-6382 fter Inplace compress: java.sql.SQLException: Page
Page(10219,Container(0, 1136)) could not be read from disk caused by Caused by:
java.io.EOFException: Reached end of file while attempting to read a whole page.
This is a partial fix for DERBY-5234. Merged revision 1337258 from 10.8
Contributed by Rick Hillegas
> After Inplace compress: java.sql.SQLException: Page Page(10219,Container(0,
> 1136)) could not be read from disk caused by Caused by: java.io.EOFException:
> Reached end of file while attempting to read a whole page.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-6382
> URL: https://issues.apache.org/jira/browse/DERBY-6382
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.5.3.0
> Reporter: Kathey Marsden
> Fix For: 10.8.3.0, 10.9.1.0
>
>
> .The reproduction attached to DERBY-5234, DbCompressErrorTester shows the
> error below. 1335570 and 1335677 were committed to trunk and ported to 10.8
> branch at subversion revision 1337258 and fix this issue. Unfortunately it
> did not fix the issue the reporting user was experiencing, so DERBY-5234 was
> closed CannotReproduce. Creating this issue to make sure the fixed issue is
> tracked separately as fixed.
> java DbCompressErrorTester
> Loading database driver
> iterations=333300
> inserted: 33330/333300
> inserted: 66660/333300
> inserted: 99990/333300
> inserted: 133320/333300
> inserted: 166650/333300
> inserted: 199980/333300
> inserted: 233310/333300
> inserted: 266640/333300
> inserted: 299970/333300
> Delete - done
> 333300 rows deleted
> Compress inplace - done
> inserted: 33330/333300
> inserted: 66660/333300
> inserted: 99990/333300
> inserted: 133320/333300
> inserted: 166650/333300
> inserted: 199980/333300
> inserted: 233310/333300
> inserted: 266640/333300
> inserted: 299970/333300
> Inserted data: 326943
> Deleted data: 0
> java.sql.SQLException: Page Page(10219,Container(0, 1136)) could not be read
> from disk.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:142)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:278)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:348)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2284)
> at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:82)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1333)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1692)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:309)
> at DbCompressErrorTester.insertData(DbCompressErrorTester.java:162)
> at DbCompressErrorTester.test(DbCompressErrorTester.java:116)
> at DbCompressErrorTester.main(DbCompressErrorTester.java:38)
> Caused by: java.sql.SQLException: Page Page(10219,Container(0, 1136)) could
> not be read from disk.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
> ... 12 more
> Caused by: java.sql.SQLException: Java exception: 'Reached end of file while
> attempting to read a whole page.: java.io.E
> OFException'.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:142)
> at org.apache.derby.impl.jdbc.Util.javaException(Util.java:299)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:408)
> ... 10 more
> Caused by: java.io.EOFException: Reached end of file while attempting to read
> a whole page.
> at
> org.apache.derby.impl.store.raw.data.RAFContainer4.readFull(RAFContainer4.java:484)
> at
> org.apache.derby.impl.store.raw.data.RAFContainer4.readPage0(RAFContainer4.java:244)
> at
> org.apache.derby.impl.store.raw.data.RAFContainer4.readPage(RAFContainer4.java:214)
> at
> org.apache.derby.impl.store.raw.data.CachedPage.readPage(CachedPage.java:671)
> at
> org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(CachedPage.java:190)
> at
> org.apache.derby.impl.services.cache.ConcurrentCache.find(ConcurrentCache.java:295)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.initPage(FileContainer.java:2342)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.newPage(FileContainer.java:1825)
> at
> org.apache.derby.impl.store.raw.data.BaseContainer.addPage(BaseContainer.java:314)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(BaseContainerHandle.java:183)
> at
> org.apache.derby.impl.store.access.heap.HeapController.doInsert(HeapController.java:302)
> at
> org.apache.derby.impl.store.access.heap.HeapController.insert(HeapController.java:575)
> at
> org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(RowChangerImpl.java:457)
> at
> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1028)
> at
> org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:505)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:436)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:317)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1241)
> ... 5 more
> ~/repro/derby-5234 $
--
This message was sent by Atlassian JIRA
(v6.1#6144)
