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

Deleting archived component leaves orphan issue association

    XMLWordPrintable

Details

    Description

      Issue Summary

      Deleting components that have been archived does not remove the Issue association from the nodeassociation table.

      This can lead to gadgets showing a different number of issues without components than what's seen in the Issue navigator.

      Steps to Reproduce

      1. Add a component to an issue
      2. Archive the component
      3. Delete the component

      Expected Results

      Component is deleted and any association to it is removed

      Actual Results

      Component is deleted but nodeassociation table still has the link between the issues and component.

      Workaround

      1. Delete the orphaned rows manually with the SQL query below
        delete from nodeassociation where source_node_entity = 'Issue' and sink_node_entity = 'Component' and sink_node_id not in (select id from component);
      2. Reindex Jira

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              malmeida Marcus Silveira
              Votes:
              20 Vote for this issue
              Watchers:
              28 Start watching this issue

              Dates

                Created:
                Updated: