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

[Akash Mudholkar]

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

[Alexander Pappert]

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.