OSUser provider does not generate IDs correctly in clustered environment

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Medium
    • 2.7
    • Affects Version/s: 2.3, 2.3.1, 2.3.2, 2.3.3, 2.4, 2.4.1, 2.4.2, 2.4.3, 2.4.4, 2.4.5, 2.5, 2.5.1, 2.5.2, 2.5.3, 2.5.4, 2.5.5, 2.5.6, 2.5.7, 2.5.8, 2.6.0, 2.6.1
    • Component/s: None
    • Environment:

      OSUser based user management; confluence massive

      Ths OSUser hibernate configuration does not use the ResettableTableHiLoGenerator for row IDs in a clustered environment. This leads to cluster nodes attempting to reuse existing row IDs when inserting new user records into the table.

      This will result in the following error message:

      Violation of PRIMARY KEY constraint 'CONSTRAINT NAME'. Cannot insert duplicate key in object 'os_user'."

      Trying to insert the user repeatably should eventually succeed as the ID generator eventually catches up to an unused row ID.

              Assignee:
              Unassigned
              Reporter:
              Christopher Owen [Atlassian]
              Votes:
              2 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: