[
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
