Symptoms

Not able to delete an inactive workflow.

Cause

This is caused by the case insensitive issue in MySQL when dealing with "SELECT" statement. For more information, please see the MySQL documentation.

Resolution

1. Create a JIRA XML backup data via Administration -> Import & Export -> Backup Data to XML.
2. Stop JIRA.

3. Create a new database with COLLATE utf_bin. For example:

   CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
   

   Remember to ensure that jira's user is granted the appropriate privileges. See Connecting JIRA to MySQL.

4. Configure JIRA to use the new database.
5. Start JIRA.
6. Restore the XML backup data.