JIRA indexing fails after upgrading from 7.13 to 8.5.3

[Divya TV]

After upgrading jira from 7.13.1 to 8.5.3 - indexing fails.

2020-03-02 16:29:33,655+0100 JiraTaskExecutionThread-1 ERROR user.lastname@company.com 989x246x1 1jkkvin 10.98.77.89 /secure/admin/IndexReIndex!reindex.jspa [c.a.j.issue.index.DefaultIndexManager] Failed to acquire the write lock. Thread which is holding the lock has been found: thread [name=LexoRankReindexer:thread-1, id=252]

2020-03-02 16:29:33,650+0100 JiraTaskExecutionThread-1 ERROR user.lastname@company.com 989x246x1 1jkkvin 10.98.77.89 /secure/admin/IndexReIndex!reindex.jspa [c.a.j.issue.index.DefaultIndexManager] Wait attempt timed out - waited 30000 milliseconds
com.atlassian.jira.issue.index.IndexException: Wait attempt timed out - waited 30000 milliseconds

2020-03-02 16:29:33,655+0100 JiraTaskExecutionThread-1 ERROR user.lastname@company.com 989x246x1 1jkkvin 10.98.77.89 /secure/admin/IndexReIndex!reindex.jspa [c.a.j.issue.index.DefaultIndexManager] Failed to acquire the write lock. Thread which is holding the lock has been found: thread [name=LexoRankReindexer:thread-1, id=252]

2020-03-02 16:29:33,656+0100 JiraTaskExecutionThread-1 INFO user.lastname@company.com 989x246x1 1jkkvin 10.98.77.89 /secure/admin/IndexReIndex!reindex.jspa [c.a.j.index.ha.DefaultNodeReindexService] Starting node re-index service
2020-03-02 16:29:33,656+0100 JiraTaskExecutionThread-1 INFO user.lastname@company.com 989x246x1 1jkkvin 10.98.77.89 /secure/admin/IndexReIndex!reindex.jspa [c.a.j.w.a.admin.index.IndexAdminImpl] Re-indexing finished
2020-03-02 16:29:33,657+0100 JiraTaskExecutionThread-1 ERROR user.lastname@company.com 989x246x1 1jkkvin 10.98.77.89 /secure/admin/IndexReIndex!reindex.jspa [c.a.jira.task.TaskManagerImpl] Task 'Jira Indexing' failed.
com.atlassian.jira.index.IndexingFailureException: Indexing completed with 1 errors
at com.atlassian.jira.util.index.CompositeIndexLifecycleManager.reIndexAll(CompositeIndexLifecycleManager.java:83)
at com.atlassian.jira.util.index.CompositeIndexLifecycleManager.reIndexAll(CompositeIndexLifecycleManager.java:49)
at com.atlassian.jira.web.action.admin.index.ReIndexAsyncIndexerCommand.doReindex(ReIndexAsyncIndexerCommand.java:27)
at com.atlassian.jira.web.action.admin.index.AbstractAsyncIndexerCommand.call(AbstractAsyncIndexerCommand.java:63)

I have two nodes in a cluster and node2 is down. Caches/indexesv1 was cleaned before restarting JIRA application. Checked./jira-home.lock file and removed it before restart.

I have only javamelody plugin and nothing else installed.

[Divya TV · Accepted solution]

1) Get supported version of ojdbc8.jar - this isnt bundled with the installer anymore.

2) Get temp tablespace increased.

3) re-indexed without any plugins.