JIRA Reindex took 6 Days !!!

[Yaswanth]

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?

[Brant Schroeder]

I would recommend looking into tuning you Jira memory.  https://confluence.atlassian.com/adminjiraserver073/increasing-jira-application-memory-861253796.html

You should also look at how many threads Jira has available to use on the DB and tune it as well. https://confluence.atlassian.com/adminjiraserver/tuning-database-connections-938846864.html

[Yaswanth]

thank you for the reply @Brant Schroeder everything seems fine. I just discovered that Scriptrunner plugin is causing this issue. By disabling script runner plugin alone... reindex took just 1.5Hrs

any ideas on how to handle this?

[Brant Schroeder]

I have never heard of ScriptRunner causing and issue like this.  You must have a script that is kicking off after each issue is index. I would suggest finding and rewriting the script.  They also have excellent support so you should submit an issue to them and they might know the issue.

[Nic Brough -Adaptavist-]

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)

[Yaswanth]

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-]

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