Uploaded image for project: 'Keycloak'
  1. Keycloak
  2. KEYCLOAK-18698

Upgrade crashes with error duplicate key value violates unique constraint "sibling_names"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: RH-SSO-7.4.6, RH-SSO-7.4.7
    • Fix Version/s: None
    • Component/s: Core
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      Still trying to reproduce it in a local env.

      Show
      Still trying to reproduce it in a local env.

      Description

      The issue has been checked in RHSSO 7.4.6 and 7.4.7

      They are using PostgreSQL and LDAP for user federation.

      LDAP configuration has a group-ldap-mapper with "Preserve Group Inheritance" turned on.

      The exact error is:

      Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sibling_names"
      Detail: Key (realm_id, parent_group, name)=(<realm_id>, , 100000000) already exists.

        Attachments

          Activity

            People

            Assignee:
            rhn-support-jortizpa Jose Ortiz Padilla
            Reporter:
            rhn-support-jortizpa Jose Ortiz Padilla
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: