Forum OpenACS Q&A: Response to Problem with intermedia migrating acs3 instance

You can also try:

drop index sws_ctx_index force

to get rid of an index that is in an invalid state.