Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-68635

Integrity checker should fix invalid references from field configuration to field configuration scheme

    XMLWordPrintable

Details

    • 1
    • 1
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      Summary

      From time to time, Jira's fieldlayoutschemeentity table has abandoned references from a field configuration to a field configuration scheme.

      Steps to Reproduce

      Apart from manually deleting field configuration schemes from the database, it's not clear how this issue can be reproduced.

      Expected Results

      The integrity checker should remove missing references.

      Actual Results

      The integrity checker should remove missing references from the fieldlayoutschemeentity table.
      The following error is logged:

      com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: No FieldLayoutScheme found for id 22601
      

      Workaround

      DELETE statements are to be used at your own risk and aren't supported by Atlassian.
      Take a database dump before deleting rows from your database.

      Delete the missing references:

      DELETE FROM fieldlayoutschemeentity WHERE scheme NOT IN (SELECT id FROM fieldlayoutscheme);
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            adridi Arbi Dridi
            Votes:
            7 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated: