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 Mon, 28 Aug 2006 17:52:26 GMT
    [ http://issues.apache.org/jira/browse/DERBY-606?page=comments#action_12431025 ] 
            
Sunitha Kambhampati commented on DERBY-606:
-------------------------------------------

I can reproduce this failure in one of my  test scenarios on a very large table:
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 XJ001: Java exception: ': java.io.IOException'.

stock has 60million rows. 

schema for stock table.
ij> create table stock (
        s_i_id          int NOT NULL,
        s_w_id          smallint NOT NULL,
        s_quantity      int NOT NULL,
        s_dist_01       char(24) NOT NULL,
        s_dist_02       char(24) NOT NULL,
        s_dist_03       char(24) NOT NULL,
        s_dist_04       char(24) NOT NULL,
        s_dist_05       char(24) NOT NULL,
        s_dist_06       char(24) NOT NULL,
        s_dist_07       char(24) NOT NULL,
        s_dist_08       char(24) NOT NULL,
        s_dist_09       char(24) NOT NULL,
        s_dist_10       char(24) NOT NULL,

        s_ytd           decimal(8) NOT NULL,
        s_order_cnt     int NOT NULL,
        s_remote_cnt    int NOT NULL,
        s_data          varchar(50) NOT NULL
);

There is no error messages in derby.log.  I'll try to rerun the test and run with ij.execptionTrace=true
to get the entire trace. 

> 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