Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-27616

Constraint violation when a user tries to login

    XMLWordPrintable

Details

    Description

      This error can occur when the group is set as lowercase in Crowd when actually the original group in LDAP is uppercase.

      caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#188383471]; SQL []; ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)
caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

2012-12-18 15:07:49,153 INFO [TP-Processor14] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] updateGroups Deleted user "user1"'s imported membership of remote group "group1" to directory "Delegated Authentication Directory".
2012-12-18 15:07:49,158 INFO [TP-Processor14] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importMembership Imported user "user1"'s membership of remote group "group1" to directory "Delegated Authentication Directory".
2012-12-18 15:07:49,162 ERROR [TP-Processor14] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated

      Workaround:

      1) Compare the groups in your Crowd with the groups in your LDAP to find out which are different (lowercase instead of uppercase).
      2) Remove the users from all these groups.
      3) Use GUI or SQL to remove the lowercase groups from the DB.
      4) Perform a Flush - Administration->Cache Statistics->Flush All
      5) Try to login with using a user that was inside on of this groups.
      6) RESTART Confluence Application

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-28194 Confluence attempts to apply group memberships when synchronising from a remote directory even if they already exist, causing a duplicate key violation

          • Medium - Medium priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-28194 Confluence attempts to apply group memberships when synchronising from a remote directory even if they already exist, causing a duplicate key violation

          • Medium - Medium priority issues
          • Closed

          Activity

            People

              Unassigned Unassigned
              bgriebeler BrunaA
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: