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

Tracking for Derby space reclamation issues

    XMLWordPrintableJSON

Details

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

    Description

      This issue is being used to track various Derby space reclamation issues.

      Users have reported the need to do periodic compress due to these issues, so opening this issue for centralized tracking of the problem and also to help users identify which issue they are hitting and possible work arounds.

      Attachments

        Issue Links

          is duplicated by

          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
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4054 Multithreaded clob update with exclusive table locking causes table growth that is not reclaimed

          • Major - Major loss of function.
          • Open

          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-5473 Index growth can occur with update of ever increasing values

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4050 Multithreaded clob update causes growth in table that does not get reclaimed

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4056 Space is not reclaimed when attempting to insert row that violates UNIQUE constraint

          • 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-4057 Space is not reclaimed if transaction is rolled back

          • Major - Major loss of function.
          • Closed

          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

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-670 improve space reclamation from deleted blob/clob columns which are bigger than a page

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

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-691 committed deleted row space reclamation may be missed if delete is actually an aborted insert.

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

          Activity

            People

              Unassigned Unassigned
              kmarsden Katherine Marsden
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: