we are getting this index exception in catalina.out and jira is getting slow, please help

Akash Mudholkar May 20, 2021

2021-05-21 11:27:05,028 http-nio-5000-exec-51672 WARN cxpsaml 649x4861813x58 1x4ccan 10.24.114.53 /rest/api/2/issue/PRPAL-210221 [c.a.jira.index.AccumulatingResultBuilder] Indexing failed for Issue - '22093121'
2021-05-21 11:27:05,029 http-nio-5000-exec-51672 WARN cxpsaml 649x4861813x58 1x4ccan 10.24.114.53 /rest/api/2/issue/PRPAL-210221 [c.a.jira.index.AccumulatingResultBuilder] com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error getting the next result (Closed Resultset: next)
java.lang.RuntimeException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: Error getting the next result (Closed Resultset: next)
at com.atlassian.jira.index.DefaultIndex$Failure.<init>(DefaultIndex.java:101)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$reindexIssues$1(DefaultIssueIndexer.java:192)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$$Lambda$656/880302279.perform(Unknown Source)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$null$2(DefaultIssueIndexer.java:305)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$$Lambda$658/1196162170.get(Unknown Source)
at com.atlassian.jira.index.SimpleIndexingStrategy.get(SimpleIndexingStrategy.java:7)
at com.atlassian.jira.index.SimpleIndexingStrategy.get(SimpleIndexingStrategy.java:5)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$perform$3(DefaultIssueIndexer.java:303)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$$Lambda$657/1334619601.consume(Unknown Source)
at com.atlassian.jira.util.collect.CollectionUtil.foreach(CollectionUtil.java:39)
at com.atlassian.jira.issue.util.IssueGVsIssueIterable.foreach(IssueGVsIssueIterable.java:28)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.perform(DefaultIssueIndexer.java:282)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.reindexIssues(DefaultIssueIndexer.java:162)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssues(DefaultIndexManager.java:541)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssues(DefaultIndexManager.java:517)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssues(DefaultIndexManager.java:396)
at com.atlassian.jira.issue.index.DefaultIndexManager.reIndexIssueObjects(DefaultIndexManager.java:422)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:497)
at com.atlassian.jira.config.component.SwitchingInvocationHandler.invoke(SwitchingInvocationHandler.java:22)
at com.sun.proxy.$Proxy14.reIndexIssueObjects(Unknown Source)
at com.atlassian.jira.event.listeners.search.IssueIndexListener.reIndex(IssueIndexListener.java:161)
at com.atlassian.jira.event.listeners.search.IssueIndexListener.reIndexModifiedIssue(IssueIndexListener.java:170)
at com.atlassian.jira.event.listeners.search.IssueIndexListener.issueUpdated(IssueIndexListener.java:57)
at com.atlassian.jira.event.issue.AbstractIssueEventListener.workflowEvent(AbstractIssueEventListener.java:126)
at com.atlassian.jira.event.issue.IssueEventListenerHandler$IssueEventInvoker.invoke(IssueEventListenerHandler.java:43)
at com.atlassian.event.internal.AsynchronousAbleEventDispatcher$1$1.run(AsynchronousAbleEventDispatcher.java:48)
at com.google.common.util.concurrent.MoreExecutors$DirectExecutorService.execute(MoreExecutors.java:299)
at com.atlassian.event.internal.AsynchronousAbleEventDispatcher.dispatch(AsynchronousAbleEventDispatcher.java:107)
at com.atlassian.event.internal.EventPublisherImpl.invokeListeners(EventPublisherImpl.java:160)
at com.atlassian.event.internal.EventPublisherImpl.publish(EventPublisherImpl.java:79)
at com.atlassian.jira.event.issue.DefaultIssueEventManager.publishEvent(DefaultIssueEventManager.java:120)
at com.atlassian.jira.event.issue.DefaultIssueEventManager.publishAsRedundant(DefaultIssueEventManager.java:132)
at com.atlassian.jira.event.issue.DefaultIssueEventManager.dispatchRedundantEvent(DefaultIssueEventManager.java:103)
at com.atlassian.jira.issue.util.DefaultIssueUpdater.storeModifiedFields(DefaultIssueUpdater.java:113)
at com.atlassian.jira.issue.util.DefaultIssueUpdater.doUpdate(DefaultIssueUpdater.java:59)
at com.atlassian.jira.issue.managers.DefaultIssueManager.doUpdate(DefaultIssueManager.java:691)
at com.atlassian.jira.issue.managers.DefaultIssueManager.updateIssue(DefaultIssueManager.java:675)
at com.atlassian.jira.bc.issue.DefaultIssueService.update(DefaultIssueService.java:321)
at com.atlassian.jira.bc.issue.DefaultIssueService.update(DefaultIssueService.java:295)
... 2 filtered

1 answer

0 votes
Alexander Pappert
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 23, 2021

please try a full index

https://confluence.atlassian.com/adminjiraserver/search-indexing-938847710.html

Full re-index: Delete and rebuild the whole index, including the comment and change history indexes.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events