How to delete a ghost issue?

[Alex Heng]

Hi All, somehow I generated a ghost issue, is shows up in the dashboard but cannot be deleted. when delete it shows "There was a system error trying to delete the issue"

I checked the log and see

error message: /secure/DeleteIssue.jspa [webwork.util.ValueStack] query="/numberOfSubTasks" {[id="null" type="5" values=""]} {[id="numberOfSubTasks" type="8" values=""]}

Can someone please help me out? Thanks!

[Logan G Hawkes · Accepted solution]

We're gonna need more information. Check the database. The mysql query should be something like:

select * from jiraissue where pkey like JIRA-123;

Assuming that there's no smoking gun there, like the issue not existing or being the wrong issue type or somesuch, check the subtasks that are associated with the issue:

select * from issuelink where SOURCE=(select id from jiraissue where pkey='JIRA-123');

This should give you some more information to work with.

[Alex Heng]

Thanks. This is installed on a linux system with default database. Can you please tell me how to access the database? Thanks.

[Logan G Hawkes]

You're running HSQL? Oooo, this may be a problem. HSQL is not recommended for production instances of Jira. Here's a link to the Jira docs on connecting to an HSQL DB. The syntax of the above commands may differ.