db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: [jira] Created: (DERBY-606) SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE fails on (very) large tables
Date Fri, 07 Oct 2005 00:01:49 GMT
could you post the DDL of the table and if you set the page size by
hand or not.  Exact size of table would help, easiest is probably
doing some sort of directory listing of the data directory.

Also what exact parameters did you pass to the procedure.

Jeffrey Aguilera (JIRA) wrote:

> 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
>         Type: Bug
>     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.
> 

Mime
View raw message