We are getting this issue for JIRA as response time of the alerts in search option and loading of the page is not working.
Found the exception related to same is :-
2022-12-07 16:26:36,497+0530 Caesium-1-1 ERROR ServiceRunner [c.a.jira.startup.IndexRecoveryLauncher] Automatic index recovery failed
org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Closed Resultset: next)
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:272)
at org.ofbiz.core.entity.EntityListIterator.next(EntityListIterator.java:51)
at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.next(DefaultOfBizListIterator.java:178)
at com.atlassian.jira.ofbiz.DefaultOfBizListIterator$LookaheadIterator.next(DefaultOfBizListIterator.java:161)
at com.google.common.collect.ForwardingIterator.next(ForwardingIterator.java:55)
at com.atlassian.jira.ofbiz.WrappingIterator.next(WrappingIterator.java:27)
at com.atlassian.jira.ofbiz.WrappingIterator.next(WrappingIterator.java:13)
at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.forEach(SelectQueryImpl.java:230)
at com.atlassian.jira.entity.SelectQueryImpl$ExecutionContextImpl.consumeWith(SelectQueryImpl.java:214)
at com.atlassian.jira.index.ha.DefaultIndexRecoveryManager.deIndexDeletedIssues(DefaultIndexRecoveryManager.java:236)
at com.atlassian.jira.index.ha.DefaultIndexRecoveryManager.reindexIssuesIn(DefaultIndexRecoveryManager.java:193)
at com.atlassian.jira.startup.IndexRecoveryLauncher.handleIndexRecoveryInServerMode(IndexRecoveryLauncher.java:100)
at com.atlassian.jira.startup.IndexRecoveryLauncher.startIndexRecovery(IndexRecoveryLauncher.java:60)
at com.atlassian.jira.startup.IndexRecoveryLauncher.lambda$runIndexRecoveryJob$1(IndexRecoveryLauncher.java:114)
at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:134)
at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:106)
at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:90)
at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:435)
