How to fix issues with a corrupt index state
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.
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
update issue_version set DELETED = 'N' where DELETED ='Y' and ISSUE_ID in (Select ID from jiraissue);