INSIGHT - Lot of errors - Indexing really slow-down

[Thomas AUVRAY]

Hi, 

Recently our JIRA instance is really slowing-down by insight plug-in. Each indexing takes more than 30 minutes. 

I've checked the logfiles and this error message appear about 10 times per seconds : 

2018-03-22 17:03:22,532 JiraTaskExectionThread-1 WARN CHE 1013x7206x1 116ke3l 80.13.73.145 /secure/admin/IndexReIndex.jspa [c.r.j.p.i.services.cache.PermissionCacheImpl] Exception occurred while loading permission context, the default one (Jira) will be used
java.lang.NullPointerException
 at com.riadalabs.jira.plugins.insight.services.cache.PermissionCacheImpl.getPermissionContext(PermissionCacheImpl.java:438)
 at com.riadalabs.jira.plugins.insight.services.cache.PermissionCacheImpl.loadPermission(PermissionCacheImpl.java:66)
 at com.riadalabs.jira.plugins.insight.services.permission.InsightPermissionServiceImpl.hasInsightPermisson(InsightPermissionServiceImpl.java:408)
 at com.riadalabs.jira.plugins.insight.services.permission.InsightPermissionServiceImpl.hasInsightAdminPermisson(InsightPermissionServiceImpl.java:233)
 at com.riadalabs.jira.plugins.insight.services.core.AbstractService.checkAdminPermission(AbstractService.java:694)
 at com.riadalabs.jira.plugins.insight.services.core.AbstractService.filterOnPermission(AbstractService.java:919)
 at com.riadalabs.jira.plugins.insight.services.core.AbstractService.filterAttributesByPermission(AbstractService.java:858)
 at com.riadalabs.jira.plugins.insight.services.core.AbstractService.filterAttributesByPermission(AbstractService.java:835)
 at com.riadalabs.jira.plugins.insight.services.core.AbstractService.filterByPermission(AbstractService.java:813)
 at com.riadalabs.jira.plugins.insight.services.core.impl.ObjectServiceImpl.findObjectBeansByAttributeValue(ObjectServiceImpl.java:1138)

Do you know where we need to looks at to solve this ? 

Thanks in advance, 

[Thomas AUVRAY · Accepted solution]

Like I said, this was a Scripted Fields of Script Runner who hasking Insight and fall into error when indexing. 

[Alexander Sundström]

Hi Thomas, 

On the latest version 5.4.8  there is a fix fot the error in the logs.

Have you checked the documentation at https://documentation.riada.se/insight/latest/insight-manager-s-guide/import-and-synchronization/general-import-concepts for more information about the recommendations and what can be done for performance tuning?

Cheers!
Alexander

[Thomas AUVRAY]

Hi Alexander, 

Thank you for your answer. 

I resolved this issue last Friday by correcting one Script Runner Field. This one worked fine each time I test it but it complety crashing down during the indexing. 
I have searched a lot of time before finding it. This logs don't really help me. 

Maybe this topic will help someone one day ! 

Thanks again, 

Have a good day !