Always back up your data before performing any modification to the database. If possible, try your modifications on a test server.
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:
This occurs due to foreign key constraints in the database.