Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4119

Compress on a large table fails with IllegalArgumentException - Illegal Capacity

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.5.1.1, 10.6.1.0
    • Store
    • None

    Description

      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 available.
      The compress was started with CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE('schema', 'table', 1) from ij.

      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).

      Attachments

        1. overflow4.diff
          2 kB
          Knut Anders Hatlen
        2. overflow3.diff
          2 kB
          Knut Anders Hatlen
        3. overflow2.diff
          2 kB
          Knut Anders Hatlen
        4. overflow.diff
          0.6 kB
          Knut Anders Hatlen

        Activity

          People

            knutanders Knut Anders Hatlen
            kristwaa Kristian Waagan
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: