[DERBY-5876] Overhaul table compression code

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.10.1.1
• Component/s: Store
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 23/Jul/12 15:27
• Updated: 21/Feb/21 14:37

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.

Issue Links

• is related to: DERBY-7099 DELETE skips a row matching the WHERE clause (single delete by PK)
• is related to: DERBY-6897 org.apache.derby.impl.store.raw.data.NoSpaceOnPage: nospc.U
• relates to: DERBY-4055 Space may not be reclaimed if row locks are not available after three retries
• relates to: DERBY-5487 Primary key disk pages not reclaimed when using SYSCS_UTIL.SYSCS_COMPRESS_TABLE with just the purge_rows option
• relates to: DERBY-5738 SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE only returns to the OS pages in the last extent
• relates to: DERBY-3683 SYSCS_COMPRESS_TABLE gets deadlock while executing concurrently with other user threads
• relates to: 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."
• relates to: DERBY-5416 SYSCS_COMPRESS_TABLE causes an OutOfMemoryError when the heap is full at call time and then gets mostly garbage collected later on
• relates to: DERBY-4923 update of a long row can fail with ERROR nospc: nospc.U exception.
• relates to: DERBY-6502 Failure in OnlineCompressTest
• relates to: DERBY-3843 enhance SYSCS_INPLACE_COMPRESS_TABLE to better handle overflow rows and overflow columns
• relates to: DERBY-1193 increase usage of "unfilled" pages after successful committed deleted purged rows.
• relates to: DERBY-512 enhance existing automatic space reclamation for tables