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 were not deletable as their internal state was corrupt. It means these issues and subtasks were marked “deleted” but they were not removed from Jira.
They remained not deletable even after a downgrade of the app, hence this workaround was created.
Solution
The solution is to fix the issue state directly in the Jira database
Backup your Jira instance
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);
You may need to adapt the SQL statement to your database type.
Jira does not have to be shutdown neither to be reindexed.