nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to delete a ghost issue?

Alex Heng1

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!

Accepted answers

Logan G Hawkes

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.

All comments

Logan G Hawkes

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 Heng1

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.