Re: Indexes stuck in INSTALLED status

Brandon Dean <engr...@...>

Thanks Rafael, I did see your post and I gave those settings a shot but that alone didn't seem to resolve the problem.  Following the steps in my last post seems to be a repeatable solution to getting indexes out of the INSTALLED status though.

I did some more testing on the disable process and it worked fine this time as long as I:
  1. performed a commit after issuing the DISABLE_INDEX
  2. insured that I had no open transactions
  3. waited patiently for the logs to indicate that the index had in fact been disabled before trying to perform any other operations on the index
At this point I feel like I know how to get things back on track, even though I still don't have a good understanding of how they got off track in the first place.  Thanks again for your response!

Join { to automatically receive all group messages.