Salesforce

IDXACTIVATE / IDXFIX leave index admin locks after being interrupted

« Go Back

Information

 
TitleIDXACTIVATE / IDXFIX leave index admin locks after being interrupted
URL Name000037380
Article Number000161333
EnvironmentProduct: OpenEdge
Version: 10.x, 11.0.x, 11.1.x, 11.2.0
OS: All Supported Operating Systems
Question/Problem Description
IDXACTIVATE / IDXFIX sessions hang.
Unable to activate an index using IDXACTIVATE after a previous IDXACTIVATE session was interrupted.
Unable to fix indexes using IDXFIX after a previous IDXFIX session was terminated.

 
Steps to Reproduce
Clarifying Information
PROMON shows RGET lock type with transaction 0 and table id 0
Previous IDXACTIVATE / IDXFIX session has been disconnected using PROSHUT -C disconnect or PROMON Option 8 to disconnect the userid.
Previous IDXACTIVATE or IDXFIX  session has been sent SIGSEGV, SIGHUP,SIGQUIT or SIGTERM kill signals.
IDXACTIVATE feature was introduced in OpenEdge 10.1A
Error MessageIndexActivate: Failed to release share_index lock. (13241)
IndexActivate: Failed to release index admin lock. (13241)
IndexActivate: Failed to release shared schema lock. (13241)
Defect NumberDefect PSC00246733 / OE00223763
Enhancement Number
Cause
Index admin lock clean code is not properly executed on disconnect or when the process is being terminated prior to completion.
Resolution
Upgrade to OpenEdge 10.2B08, 11.2.1, 11.3.0 or later. Where the index admin lock is properly cleared out when index utilities are disconnected.
Workaround
To clean up the admin lock, the database needs to be restarted, unless a new idxactivate/idxfix session can be started which manages to inherit the same userid as the previously disconnected/terminated idxactivate/idxfix session and allowed to run to completion.

This would be achievable in a controlled environment by not allowing any other users to connect and explicitly allocating dummy connections to use user-slots until the user-slot previously used by the terminated / disconnected IDXFIX / IDXACTIVATE session is then available for the new online idxactivate/idxfix session to use.
Notes
Keyword Phrase
Last Modified Date10/30/2025 6:07 PM

Powered by