Re indexing an issue - is it necessary to call the release method

[Tasneem Bhyat]

Hi there

With JIRA Data Center (8.5.4) running on multiple nodes, I have the following code which runs fine on Data Center single node (8.5.4.). On multi node, it runs, but on occasion throws an exception at the release method.

this is the code, I have made the line where the exception is thrown , in bold. Can someone please advise...I have pasted part of the stacktrace below

boolean isIndexIssues = ImportUtils.isIndexIssues();
boolean isHeld = issueIndexManager.isHeld();
try {
   if (!isIndexIssues)
      ImportUtils.setIndexIssues(true);

   if (isHeld)
      issueIndexManager.release();

   issueIndexManager.reIndex(issue);
} catch (IndexException e) {
   log.warn("Unable to reindex issue: {}", issue.getKey());
} finally {
   if (isHeld)
      issueIndexManager.hold();

   ImportUtils.setIndexIssues(isIndexIssues);
}





Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to user request
Where: while updating tuple (17400,88) in relation "AO_60DB71_LEXORANK"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2211)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:309)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446)

.  

[Gonchik Tsymzhitov]

Hi @Tasneem Bhyat , 

sorry for refer to old post, did find any solution?

[Tasneem Bhyat]

Hi @Gonchik Tsymzhitov , no I have not, unfortunately.

Would welcome it if you found any solution :)