Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,817
Community Members
 
Community Events
168
Community Groups

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

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)

.  

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events