[ASTERIXDB-3476] isActive is getting marked to true early for Column Indexes

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.10
• Fix Version/s: 0.9.10
• Component/s: STO - Storage
• Labels: triaged
• Assignee: Unassigned
• Reporter: Ritik Raj
• Created: 07/Aug/24 19:15
• Updated: 22/Sep/24 16:53
• Resolved: 22/Sep/24 16:53

Description

For Column Indexes, isActive is marked to true before completing all the required steps for column Index activation, and if some failure happens before completing the steps, this leaves "isActive" to true, and index "isOpen" to false.

so, on the next query, since the isOpen == false, the index activation is called but the isActive is true, which causes the exception to be thrown and the query to fail.
and requires a restart to cluster restart to undo the isActive state.