Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and 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

              Assignee:
              Unassigned Unassigned
              Reporter:
              malmeida Marcus Silveira
              Votes:
              7 Vote for this issue
              Watchers:
              15 Start watching this issue

                Dates

                Created:
                Updated: