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

Integrity checker detects duplicate permissions on fresh JIRA installation/restoration

      The "Check for Duplicate Permissions" option in the Integrity Checker shows 4 duplicates, even on a fresh installation: DupePerms.jpg

      Checking in the database:

      SELECT * FROM schemepermissions WHERE ID IN (10003, 10032, 10100, 10101);
      

      We get:

      10003		24	group	jira-developers	
      10032		22	group	jira-users	
      10100		33	group	jira-users	
      10101		44	group	jira-administrators	
      

      Clicking on the "Fix" will proceed to delete all the entries above.

      Search for the System Administration global permission group entry:

      select * from schemepermissions where PERMISSION=44;
      

      We received an empty results which mean the JIRA System Administrators global permission group got deleted.

      There are no perceived side effects if I log-in using the JIRA System Administrators user account.

      Additional Notes
      I think it is also worth explaining on why the Integrity Checker manages to find these as "duplicates", when there isn't actually any duplication in the first place. There is only one instance of 22, 24, 33 and 44 permissions in a fresh installation, so there isn't any "duplicates". Also, why does removing them show no side effects even though permission 44 is actually the JIRA System Administrators global permission ?

            [JRASERVER-41886] Integrity checker detects duplicate permissions on fresh JIRA installation/restoration

            No work has yet been logged on this issue.

              e2656c68d96d Agata Kowal
              dleng Daniel Leng (Inactive)
              Affected customers:
              60 This affects my team
              Watchers:
              73 Start watching this issue

                Created:
                Updated:
                Resolved: