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

Overhaul table compression code

    XMLWordPrintableJSON

Details

    • Task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.10.1.1
    • None
    • Store
    • None
    • Normal

    Description

      There appear to be a lot of bugs related to table compression. This JIRA is a place to link these bugs together and to discuss whether it makes sense to overhaul this brittle code.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-7099 DELETE skips a row matching the WHERE clause (single delete by PK)

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6897 org.apache.derby.impl.store.raw.data.NoSpaceOnPage: nospc.U

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4055 Space may not be reclaimed if row locks are not available after three retries

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5487 Primary key disk pages not reclaimed when using SYSCS_UTIL.SYSCS_COMPRESS_TABLE with just the purge_rows option

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5738 SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE only returns to the OS pages in the last extent

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3683 SYSCS_COMPRESS_TABLE gets deadlock while executing concurrently with other user threads

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5234 Unable to insert data into table. Failed due be "ERROR XSDG0: Page Page(51919,Container(0, 1104)) could not be read from disk."

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5416 SYSCS_COMPRESS_TABLE causes an OutOfMemoryError when the heap is full at call time and then gets mostly garbage collected later on

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4923 update of a long row can fail with ERROR nospc: nospc.U exception.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6502 Failure in OnlineCompressTest

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-3843 enhance SYSCS_INPLACE_COMPRESS_TABLE to better handle overflow rows and overflow columns

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1193 increase usage of "unfilled" pages after successful committed deleted purged rows.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-512 enhance existing automatic space reclamation for tables

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              Unassigned Unassigned
              rhillegas Richard N. Hillegas
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: