Deleted issue still appears in filter using JQL query

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Problem

Deleted issue still appears in queries 

For example : issue with key DEV-1350

  • Perform following query ; project=DEV and issuekey>DEV-1348 and issuekey<DEV-1352
  • Dev-1350 will appear under the search result
  • However, when clicked, an error " Issue does not exist "

No error appears in logs

Diagnosis

Diagnostic Steps

  • Perform a search through JIRA database jiraissue table, issue does not exist.
  • select * from jiraissue where issuenum='1350' AND id=(select id from project where pkey='DEV');

    1350 = issuenum
    DEV = PKey 
    (substitute accordingly)

 

Cause

  • Index cache is corrupted or not properly updated

 

Resolution

Perform the following:

  • Perform a full reindex, not a background reindex

If problem still showing:
  • Stop JIRA
  • Go to JIRA_HOME/caches/ and delete all the folders there.
  • Restart JIRA
  • Perform a full reindex

Last modified on May 23, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.