Documentation for JIRA 4.4. Documentation for other versions of JIRA is available too.

Always back up your data before performing any modification to the database.

JIRA shows linked issues as closed, even though they are open. There are no corresponding error messages found in JIRA's logs. This is caused by issues in the JIRA database having an invalid resolution. The following SQL query can be executed to confirm this:

select pkey, resolution from jiraissue where resolution not in (select id from resolution);

To fix the problem, run this SQL statement and reset the resolution to UNRESOLVED for the issues with invalid resolution.

UPDATE jiraissue SET resolution = NULL where resolution not in (SELECT id FROM resolution);



See our Getting Help page for details.



Raise an issue for our developers.



See answers from the community.



Tweet, blog and update our documentation.

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.