Groovy script created corrupted issue link that can't be deleted

[Matt Whitaker]

Hello,

On my Jira instance someone has created a script to link issues automatically. This was a listener that didn't handle the fact that an issue could be deleted. After fixing this problem the issues that had tired to be deleted are now stuck in a state that the issue nor the issue link can be deleted. Apart from trying to go into the database to try and find this issue is there any way to force delete the issue. 

Things I have tried:

• Deleting the issue link though the Java API
• Deleting the ticket though the Java API
• Deleting the ticket though the REST API
• Deleting the Link Type

All of these have come with a big hang time and eventually error. 

Thanks in advance.

[sukkeong · Accepted solution]

If you have access to the application logs, it can help with determining what went wrong. If the action was unsuccessful or causing an error.

Additionally, try

1. Performing a system re-index
2. Deleting the issues or issue link through the application instead.

[Matt Whitaker]

Hi,

Thanks for the response I have access the script runner versions ( the built in script that shows the output of some of the jira logs) this isn’t really showing any problems... I have tried your second option the api stuff was trying to work around not being able to do it in the application. I will try a full reindex rather than a project one to see if this works.

Many Thanks for the suggestions

[sukkeong]

If system re-index did not help, try performing integrity check
Administration > System > Integrity checker