[DERBY-719] Calling SYSCS_INPLACE_COMPRESS_TABLE on SYS.SYSTABLES results in a lock timeout, with only a single connection active

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.5.1.1
• Component/s: Store
• Environment: sane mode
• Assignee: Mamta A. Satoor
• Reporter: Daniel John Debrunner
• Created: 19/Nov/05 07:22
• Updated: 04/May/09 18:22
• Resolved: 14/May/08 05:08

Description

ij version 10.2
ij> connect 'jdbc:derby:css;create=true';
ij> call SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('SYS', 'SYSTABLES', 1, 1, 1);
ERROR 40XL1: A lock could not be obtained within the time requested