Hey guys,
Today, I am facing this issue in more than one projects. Issues are creating but the workflow is not indexing, so issues are becoming zombie. Cannot make any transition:

There is no problem in conditions, permissions, etc, already checked.
Usually, for this kind of problem, we are reindexing the system or changing the workflow. However, these projects that I am facing problems are too big to change workflow. And right now it is not possible to reindex.
How can I fix that problem efficiently? I am open to all solutions including DB and scripting.