Using the Database Integrity Checker

Searching for common data inconsistencies, the Database Integrity Checker attempts to ensure that all JIRA data is in a consistent state.

This is useful in a number of situations, e.g.

• Before migrating a project to a new workflow
• An external program is modifying JIRA's database
• Troubleshooting a server crash

If an error is encountered, most of the integrity checks provide a 'repair' option which attempts to reset the data to a stable state.

Using the Integrity Checker

1. Log in as a user with the 'JIRA System Administrators' global permission.
2. Bring up the administration page by clicking either the 'Administration' link on the top bar or the title of the Administration box on the dashboard.
3. Under the 'System' sub-menu in the left-hand navigation solumne, click the 'Integrity Checker' link.
4. The 'Integrity Checker' screen will be displayed:
   
5. The integrity checker has a number of 'integrity checks' that look for common inconsistencies in the data. Select one or more checks you would like to run, then click the 'Check' button.
6. After the selected checks run, the preview screen will be shown.
   The screen provides details about the existing data inconsistencies. If any inconsistencies were found, the 'Fix' button will also appear on the page. The messages in red describe inconsistencies that the check will correct if it is chosen and the 'Fix' button is clicked. Messages that appear in yellow are warnings that the check will not correct; JIRA will auto-recover from these inconsistencies when an action is taken on an issue.
   Select any inconsistencies that you would like to correct, then click the 'Fix' button.

   We strongly recommend taking a backup of your data before correcting any data inconsistencies.

7. If any inconsistencies were found and you chose to correct them, you will be presented with a summary screen describing all the corrective actions that have taken place.