db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4119) Compress on a large table fails with IllegalArgumentException - Illegal Capacity
Date Thu, 26 Mar 2009 08:59:51 GMT
Compress on a large table fails with IllegalArgumentException - Illegal Capacity

                 Key: DERBY-4119
                 URL: https://issues.apache.org/jira/browse/DERBY-4119
             Project: Derby
          Issue Type: Bug
          Components: Store
    Affects Versions:
            Reporter: Kristian Waagan

When compressing a large table, Derby failed with the following exception:
IllegalArgumentException; Illegal Capacity: -X

I was able to access the database afterwards, but haven't yet checked if all the data is still
The compress was started with CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE('schema', 'table', 1) from

The data in the table was inserted with 25 concurrent threads. This seems to cause excessive
table growth, as the data inserted should weigh in at around 2 GB. The table size after the
insert is ten times bigger, 20 GB.
I have been able to generate the table and do a compress earlier, but then I have been using
fewer insert threads.
I have also been able to successfully compress the table when retrying after the failure occurred
(shut down the database, then booted again and compressed).

I'm trying to reproduce, and will post more information (like the stack trace) later.
So far my attempts at reproducing has failed. Normally the data is generated and the compress
is started without shutting down the database. My attempts this far has consisted of doing
compress on the existing database (where the failure was first seen).

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message