[DERBY-5406] Intermittent failures in CompressTableTest and TruncateTableTest

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.8.2.2, 10.9.1.0
• Fix Version/s: 10.8.3.0, 10.9.1.0
• Component/s: SQL
• Bug behavior facts: Regression Test Failure
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 09/Sep/11 09:54
• Updated: 01/Nov/12 21:10
• Resolved: 23/Jan/12 14:23

Description

The test cases CompressTableTest.testConcurrentInvalidation() and TruncateTableTest.testConcurrentInvalidation() fail intermittently with errors such as:

ERROR XSAI2: The conglomerate (2,720) requested does not exist.

The problem has been analyzed in the comments on DERBY-4275, and a patch attached to that issue (invalidation-during-compilation.diff) fixes the underlying race condition. However, that patch only works correctly together with the fix for DERBY-5161, which was backed out because it caused the regression DERBY-5280.

We will therefore need to find a way to fix DERBY-5161 without reintroducing DERBY-5280 in order to resolve this issue.

Issue Links

• relates to: DERBY-4275 Query executions fail when compressing a table using SYSCS_UTIL.SYSCS_COMPRESS_TABLE
• relates to: DERBY-5161 Cannot rollback after syntax error in internal statement