Problem with compression table
Sun Jul 08 12:55:04 MSK 2012 : Сетевой сервер Apache Derby
Network Server - 10.9.1.0 - (1344872) запущен и готов
принимать соединения на порту 1527 на {3}
----------------------------------------------------------------
Sun Jul 08 12:55:04 MSK 2012:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.9.1.0 - (1344872): instance a816c00e-0138-65cc-9925-00001dbd2e98
on database directory D:\derby\stats\atom\stat.db with class loader
sun.misc.Launcher$AppClassLoader@360be0
Loaded from file:/X:/revision/tsmcollector/library/derby.jar
java.vendor=Sun Microsystems Inc.
java.runtime.version=1.6.0_31-b05
user.dir=X:\workspace\tsmcollector
derby.system.home=null
Database Class Loader started - derby.database.classpath=''
Sun Jul 08 12:55:15 MSK 2012 Thread[main,5,main] (XID = 232482711),
(SESSIONID = 1), (DATABASE = d:/derby/stats/atom/stat.db), (DRDAID =
null), Cleanup action starting
Sun Jul 08 12:55:15 MSK 2012 Thread[main,5,main] (XID = 232482711),
(SESSIONID = 1), (DATABASE = d:/derby/stats/atom/stat.db), (DRDAID =
null), Failed Statement is: alter table "APP"."ACTLOG" compress inplace
purge defragment truncate_end
ERROR XSDG0: Page Page(31069,Container(0, 155808)) 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.ConcurrentCache.find(Unknown Source)
at org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.moveRecordForCompressAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchRowsForCompress(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchNextGroup(Unknown
Source)
at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.defragmentRows(Unknown
Source)
at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.executeConstantActionBody(Unknown
Source)
at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.executeConstantAction(Unknown
Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.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.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.derby.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown
Source)
at
org.apache.derby.exe.acaaeec04ex0138x65ccx9925x00001dbd2e982.g0(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at org.apache.derby.impl.sql.execute.CallStatementResultSet.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.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.eclipse.db.DBFunction.compressTableSoft(DBFunction.java:407)
at org.eclipse.appl.TsmColl.compressDB(TsmColl.java:80)
at org.eclipse.appl.TsmColl.main(TsmColl.java:235)
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(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage0(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage(Unknown
Source)
... 35 more
============= begin nested exception, level (1) ===========
java.io.EOFException: Reached end of file while attempting to read a
whole page.
at org.apache.derby.impl.store.raw.data.RAFContainer4.readFull(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage0(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.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.ConcurrentCache.find(Unknown Source)
at org.apache.derby.impl.store.raw.data.FileContainer.initPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.newPage(Unknown
Source)
at org.apache.derby.impl.store.raw.data.BaseContainer.addPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.addPage(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.StoredPage.moveRecordForCompressAtSlot(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchRowsForCompress(Unknown
Source)
at
org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchNextGroup(Unknown
Source)
at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.defragmentRows(Unknown
Source)
at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.executeConstantActionBody(Unknown
Source)
at
org.apache.derby.impl.sql.execute.AlterTableConstantAction.executeConstantAction(Unknown
Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.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.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.derby.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown
Source)
at
org.apache.derby.exe.acaaeec04ex0138x65ccx9925x00001dbd2e982.g0(Unknown
Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown
Source)
at org.apache.derby.impl.sql.execute.CallStatementResultSet.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.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.eclipse.db.DBFunction.compressTableSoft(DBFunction.java:407)
at org.eclipse.appl.TsmColl.compressDB(TsmColl.java:80)
at org.eclipse.appl.TsmColl.main(TsmColl.java:235)
============= end nested exception, level (1) ===========
----------------------------------------------------------------
Sun Jul 08 12:55:15 MSK 2012:
Shutting down instance a816c00e-0138-65cc-9925-00001dbd2e98 on database
directory D:\derby\stats\atom\stat.db with class loader
sun.misc.Launcher$AppClassLoader@360be0
Cleanup action completed
