You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Dmitry <de...@gmail.com> on 2012/07/08 11:00:08 UTC

Problem with 10.9.1.0

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

Re: Problem with 10.9.1.0

Posted by Bryan Pendleton <bp...@gmail.com>.

> java.io.EOFException: Reached end of file while attempting to read a whole page.
...
> 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.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown Source)

Did your disk fill up while you were trying to compress this table?

thanks,

bryan