JIRA Documentation

JIRA 6.3 EAP
JIRA 6.0 Documentation
JIRA 5.2 Documentation
JIRA 5.1 Documentation
More...
 

 

Search the Knowledge Base and Documentation Spaces

You're visiting the JIRA Knowledge Base. Visit the JIRA Knowledge Base Home for an overview.

Skip to end of metadata
Go to start of metadata

Icon

Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.

Symptoms

When attempting to delete an issue, the error message "There was a system error trying to delete the issue" may appear in JIRA. Also, an error similar to the following may appear in the logs:

Cause

This occurs due to foreign key constraints in the database.

Resolution

Create and configure new database for JIRA without foreign keys. Then, restore the data by importing an XML backup into the newly created database (via JIRA).

Related Content

 Expand to see related content
Help us improve!
Is this article helpful?
Is the content complete?
Is it well written?

1 Comment

  1. I think the delete operation does not do all the job, maybe (until Atlassian fix it) the database can do the job instead. Simply add the cascasde delete option like this:

    First, delete the constraint:

    alter table jiraissue drop constraint RELATEDOSWORKFLOWENTRY

    Then recreate it with the option on delete cascade:

    alter table jiraissue add constraint RELATEDOSWORKFLOWENTRY
    Foreign key
    (workflow_id)
    References os_wfentry
    (id)
    On delete cascade