How to fix issues with a corrupt index state

Problem

Subtasks and linked issues cannot be deleted.
Email This Issue version 8.1.1 introduced a bug which made impossible to delete subtasks and linked issues. After a failed attempt, these issues could not be deleted, as their internal state was corrupt. It means these issues and subtasks were marked β€œdeleted” but they were not removed from Jira. They could not be deleted even after downgrading of the app.

Solution

The solution is to fix the issue state directly in the Jira database
1. Backup your Jira instance.
2. Execute this SQL UPDATE statement in your Jira database
1
update issue_version set DELETED = 'N' where DELETED ='Y' and ISSUE_ID in (Select ID from jiraissue);
Copied!
Note: You might need to adapt the SQL statement to your database type.
Result: Jira does not have to be shutdown or be re-indexed.
Copy link