Deleting archived component leaves orphan issue association

XMLWordPrintable

    • 8.01
    • 22
    • Severity 2 - Major
    • 11

      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

            Assignee:
            Unassigned
            Reporter:
            Marcus Silveira
            Votes:
            22 Vote for this issue
            Watchers:
            30 Start watching this issue

              Created:
              Updated: