Hi all - I was wondering if anyone has any insight on to the exception below. I preformed a SYSCS_CHECK_TABLE on all tables after restarting Derby and all returned a 1. I also preformed disk checking on the physical disk which houses the database which was clean as well. This query has run successfully after the restart as well, and I'm looking to see what may have caused this and how to possibly prevent a similar occurrence in the future. This is version 10.2.2.0.

Thanks

2010-08-14 07:46:26.047 GMT Thread[DRDAConnThread_13346,5,derby.daemons] (XID = 79141229328), (SESSIONID = 12194), (DATABASE = ../../database/xdb1), (DRDAID = NF000001.P02E-953354465271340036{12196}), Cleanup action starting
2010-08-14 07:46:26.047 GMT Thread[DRDAConnThread_13346,5,derby.daemons] (XID = 79141229328), (SESSIONID = 12194), (DATABASE = ../../database/xdb1), (DRDAID = NF000001.P02E-953354465271340036{12196}), Failed Statement is: SELECT * FROM "EBI"."BPScriptCategories" WHERE "ID" = ?
ERROR XSDG0: Page Page(1,Container(0, 1601)) could not be read from disk.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.store.raw.data.CachedPage.readPage(Unknown Source)
    at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Source)
    at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
    at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
    at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
    at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
    at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
    at org.apache.derby.impl.store.access.btree.ControlRow.Get(Unknown Source)
    at org.apache.derby.impl.store.access.btree.ControlRow.Get(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown Source)
    at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
    at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
    at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
============= begin nested exception, level (1) ===========
java.io.IOException: Illegal seek
    at java.io.RandomAccessFile.seek(Native Method)
    at org.apache.derby.impl.store.raw.data.RAFContainer.readPage(Unknown Source)
    at org.apache.derby.impl.store.raw.data.CachedPage.readPage(Unknown Source)
    at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown Source)
    at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
    at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
    at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
    at org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
    at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown Source)
    at org.apache.derby.impl.store.access.btree.ControlRow.Get(Unknown Source)
    at org.apache.derby.impl.store.access.btree.ControlRow.Get(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source)
    at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown Source)
    at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source)
    at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source)
    at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.writeFDODTA(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.writeQRYDTA(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.processCommands(Unknown Source)
    at org.apache.derby.impl.drda.DRDAConnThread.run(Unknown Source)
============= end nested exception, level (1) ===========