Uploaded image for project: 'Crowd'
  1. Crowd
  2. CWD-3882

Add unique constraint on columns external_id and directory_id

    XMLWordPrintable

    Details

    • Type: Suggestion
    • Status: Gathering Interest (View Workflow)
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Feedback Policy:

      Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      Description

      In the table cwd_user, there should be no rows where the external_id is repeated for the same directory_id. Said in another way, the external_id should be unique for the same directory_id.

      To avoid this from causing problems, we should add a unique constraint at a database level in the table cwd_user.

      When two users share external_id and directory_id, the user is not able to login or update new information from the external user directory. Those actions will fail with the following error:

      org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
        at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:590)
        at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindUserByExternalId(HibernateUserDao.java:501)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindByExternalId(HibernateUserDao.java:473)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.findByExternalId(HibernateUserDao.java:449)
        at com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findByExternalId(CachedCrowdUserDao.java:164)
...

      This also affects embedded Crowd.

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CWD-5182 Sync Failures due to duplicated External IDs

          • Highest - Our top priority issues
          • Long Term Backlog
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-35047 Confluence user synchronisation create duplicated user account after user rename in the remote repository

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CWD-3984 Rename user in external directory create new user with same external_id

          • Medium - Medium priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-22515 After change an username in Active Directory and resynchronize, there are two accounts showing in Confluence (the old and the new username).

          • Medium - Medium priority issues
          • Closed

          Suggestion - CWD-1133 Provide ability to rename users in Crowd.

          • Closed
          is blocked by

          KRAK-615 Loading...

          links to

          Web Link CSP-126414

          mentioned in

          Page Loading...

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              aconde Alejandro Conde Carrillo (Inactive)
              Votes:
              18 Vote for this issue
              Watchers:
              22 Start watching this issue

                Dates

                Created:
                Updated: