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

Deleting an issue security scheme does not remove it from issues and renders them inaccessible

XMLWordPrintable

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Summary

      If you disassociate an issue security scheme from a project and then delete it, it doesn't actually remove that issue security level from the issue, which renders the issue inaccessible.

      Environment

      • JIRA v7.2.0-OD-05-030

      Steps to Reproduce

      1. Create a new issue security scheme and level
      2. Associate that issue security scheme with a project and associate the issue security level with an issue.
      3. Disassociate the issue security scheme from the project, you'll be told that the security level will be removed from x issues. Nothing actually happens if you check the DB.
      4. Delete the security scheme
      5. Browse to the issue in step 2.

      Expected Results

      Issue has no security level and anyone can see it.

      Actual Results

      Issue can not be viewed by anyone.

      Workaround

      Remove the issue security link to un-existing issue security levels

      update jiraissue set security = null where security in (select distinct security from jiraissue where security not in (select id from schemeissuesecuritylevels ) and security is not null);

            [JRASERVER-60561] Deleting an issue security scheme does not remove it from issues and renders them inaccessible

            BostjanR added a comment -

            Hi, 

            the issue resurfaced in 9.1.0

            BostjanR added a comment - Hi,  the issue resurfaced in 9.1.0

            Aleksandr Gerasimenok added a comment -

            Hi!
            For JIRA 7.1.4 this bug didnt resolve. After security scheme removed from project JIRA shows: "Secutity on this issues will be removed", but security levels are kept.

            Aleksandr Gerasimenok added a comment - Hi! For JIRA 7.1.4 this bug didnt resolve. After security scheme removed from project JIRA shows: "Secutity on this issues will be removed", but security levels are kept.

            Joanne added a comment -

            We found this issue in JIRA 7.0.10 and the workaround fixed it but remember to re-index after updating the database!

            Joanne added a comment - We found this issue in JIRA 7.0.10 and the workaround fixed it but remember to re-index after updating the database!

            Mauro Badii (Inactive) added a comment -

            matt.doar how about ...

            update jiraissue set security = null where security in (select distinct security from jiraissue where security not in (select id from schemeissuesecuritylevels ) and security is not null);

            Mauro Badii (Inactive) added a comment - matt.doar how about ... update jiraissue set security = null where security in (select distinct security from jiraissue where security not in (select id from schemeissuesecuritylevels ) and security is not null);

            MattS added a comment -

            That workaround appears to remove the security level from every issue in JIRA, which may not be what is wanted!

            MattS added a comment - That workaround appears to remove the security level from every issue in JIRA, which may not be what is wanted!

              ohernandez@atlassian.com Oswaldo Hernandez (Inactive)
              mhunter Matthew Hunter
              Affected customers:
              2 This affects my team
              Watchers:
              18 Start watching this issue

                Created:
                Updated:
                Resolved: