Issue Summary

The The Background re-indexing fails when the database connection unexpectedly is closed

• Database: Oracle 12c
• Database Driver:Oracle JDBC driver 19.3.0.0
• Dbconfig.xml

  <pool-remove-abandoned>true</pool-remove-abandoned>
      <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
      <validation-query>select 1 from dual</validation-query>
      <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
      <time-between-eviction-runs-millis>10000</time-between-eviction-runs-millis>
      <pool-test-on-borrow>false</pool-test-on-borrow>
      <pool-test-while-idle>true</pool-test-while-idle>
  

Steps to Reproduce

Not easy to reproduce

Expected Results

The background re-indexing recovers when the connection is closed

Actual Results

The background re-indexing is failing

2021-02-22 02:10:59,155+0000 JiraTaskExecutionThread-13 ERROR UsernameXXX 1380x3929500x2 1v3hu72 172.30.40.3,10.153.64.190 /secure/admin/IndexReIndex!reindex.jspa [c.a.j.util.index.CompositeIndexLifecycleManager] Reindex All In Background FAILED. Indexer: DefaultIndexManager: paths: [/opt/apps/application-data/jira/caches/indexesV1/comments, /opt/apps/application-data/jira/caches/indexesV1/issues, /opt/apps/application-data/jira/caches/indexesV1/changes, /opt/apps/application-data/jira/caches/indexesV1/worklogs, /opt/apps/application-data/jira/caches/indexesV1/plugins/JEEntity]
org.ofbiz.core.util.GeneralRuntimeException: Error getting the next result (Closed Connection: next)
...
Caused by: java.sql.SQLRecoverableException: Closed Connection: next

...

Workaround

Restart the background re-indexing