JIRA Reindex took 6 Days !!!

Question

Hi,

Our Jira Instance(8.1.3) took ~6 Days for a lock and reindex. However, lock and reindex in safe mode is taking just 30mins below are the screenshots for the database statistics and hardware info. Can someone help me in troubleshooting this issue?

Nic Brough -Adaptavist- · Answer

No, as I said already, workflow functions will not affect indexing.  They only get run when you are using a transition.

Yaswanth_6dp699 · Answer

I'll revisit the scripts and check.

@Nic Brough -Adaptavist- could you please confirm whether the placing of post function custom scripts affect the indexing, I mean in the post function, by default there is a function called Re-index an issue to keep indexes in sync with the database will there be any change in reindex time if custom scripted post function is placed below/above this default function (screenshot attached for reference)

Nic Brough -Adaptavist- · Answer

I have seen this.  @Brant Schroeder is absolutely right - there's a script doing bad/heavy/slow things.  Well, at least one script, it might be several.

Re-enable SR and check the script registry, looking at scripted fields, listeners, triggers, and services  (workflow functions and behaviours won't affect indexing, but most of the rest of SR functions can)