db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunitha Kambhampati (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-606) SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE fails on (very) large tables
Date Tue, 29 Aug 2006 16:02:23 GMT
    [ http://issues.apache.org/jira/browse/DERBY-606?page=comments#action_12431280 ] 
            
Sunitha Kambhampati commented on DERBY-606:
-------------------------------------------

Here is the stacktrace:
ij version 10.2
ij> connect 'jdbc:derby:dbtpcc';
ij> call syscs_util.syscs_inplace_compress_table('APP','STOCK',1,1,1);
ERROR XSLB1: Log operation null encounters error writing itself out to the log stream, this
could be caused by an errant log operation or internal log buffer full due to excessively
large log operation.
ERROR XSLB1: Log operation null encounters error writing itself out to the log stream, this
could be caused by an errant log operation or internal log buffer full due to excessively
large log operation.
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at org.apache.derby.impl.store.raw.log.FileLogger.logAndDo(Unknown Source)
	at org.apache.derby.impl.store.raw.xact.Xact.logAndDo(Unknown Source)
	at org.apache.derby.impl.store.raw.data.LoggableAllocActions.actionCompressSpaceOperation(Unknown
Source)
	at org.apache.derby.impl.store.raw.data.AllocExtent.compress(Unknown Source)
	at org.apache.derby.impl.store.raw.data.AllocPage.compress(Unknown Source)
	at org.apache.derby.impl.store.raw.data.FileContainer.compressContainer(Unknown Source)
	at org.apache.derby.impl.store.raw.data.BaseContainer.compressContainer(Unknown Source)
	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.compressContainer(Unknown Source)
	at org.apache.derby.impl.store.access.heap.Heap.compressConglomerate(Unknown Source)
	at org.apache.derby.impl.store.access.RAMTransaction.compressConglomerate(Unknown Source)
	at org.apache.derby.iapi.db.OnlineCompress.truncateEnd(Unknown Source)
	at org.apache.derby.iapi.db.OnlineCompress.compressTable(Unknown Source)
	at org.apache.derby.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown Source)
	at org.apache.derby.exe.ac601a400fx010dx55efx588dx0000001d75e80.g0(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
	at java.lang.reflect.Method.invoke(Method.java:391)
	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.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.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
	at org.apache.derby.tools.ij.main(Unknown Source)
ERROR XJ001: Java exception: ': java.io.IOException'.
java.io.IOException
	at org.apache.derby.iapi.services.io.CompressedNumber.writeInt(Unknown Source)
	at org.apache.derby.impl.store.raw.data.CompressSpacePageOperation.writeExternal(Unknown
Source)
	at org.apache.derby.iapi.services.io.FormatIdOutputStream.writeObject(Unknown Source)
	at org.apache.derby.impl.store.raw.log.LogRecord.writeExternal(Unknown Source)
	at org.apache.derby.iapi.services.io.FormatIdOutputStream.writeObject(Unknown Source)
	at org.apache.derby.impl.store.raw.log.FileLogger.logAndDo(Unknown Source)
	at org.apache.derby.impl.store.raw.xact.Xact.logAndDo(Unknown Source)
	at org.apache.derby.impl.store.raw.data.LoggableAllocActions.actionCompressSpaceOperation(Unknown
Source)
	at org.apache.derby.impl.store.raw.data.AllocExtent.compress(Unknown Source)
	at org.apache.derby.impl.store.raw.data.AllocPage.compress(Unknown Source)
	at org.apache.derby.impl.store.raw.data.FileContainer.compressContainer(Unknown Source)
	at org.apache.derby.impl.store.raw.data.BaseContainer.compressContainer(Unknown Source)
	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.compressContainer(Unknown Source)
	at org.apache.derby.impl.store.access.heap.Heap.compressConglomerate(Unknown Source)
	at org.apache.derby.impl.store.access.RAMTransaction.compressConglomerate(Unknown Source)
	at org.apache.derby.iapi.db.OnlineCompress.truncateEnd(Unknown Source)
	at org.apache.derby.iapi.db.OnlineCompress.compressTable(Unknown Source)
	at org.apache.derby.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown Source)
	at org.apache.derby.exe.ac601a400fx010dx55efx588dx0000001d75e80.g0(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
	at java.lang.reflect.Method.invoke(Method.java:391)
	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.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.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
	at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
	at org.apache.derby.impl.tools.ij.Main14.main(Unknown Source)
	at org.apache.derby.tools.ij.main(Unknown Source)
ij> exit;


> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE fails on (very) large tables
> --------------------------------------------------------------------
>
>                 Key: DERBY-606
>                 URL: http://issues.apache.org/jira/browse/DERBY-606
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.1.1.0
>         Environment: Java 1.5.0_04 on Windows Server 2003 Web Edition
>            Reporter: Jeffrey Aguilera
>
> SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE fails with one of the following error messages
when applied to a very large table (>2GB):
> Log operation null encounters error writing itself out to the log stream, this could
be caused by an errant log operation or internal log buffer full due to excessively large
log operation. SQLSTATE: XJ001: Java exception: ': java.io.IOException'.
> or
> The exception 'java.lang.ArrayIndexOutOfBoundsException' was thrown while evaluating
an expression. SQLSTATE: XJ001: Java exception: ': java.lang.ArrayIndexOutOfBoundsException'.
> In either case, no entry is written to the console log or to derby.log.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message