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

Cannot create new user due to primary key violation or unique constraint error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 2.2.1
    • 2.2
    • None

      Here are the exceptions from various databases:

      Oracle:

      org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: ORA-00001: unique constraint (CWK.SYS_C002106) violated
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:88)
      caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (CWK.SYS_C002106) violated
      at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)

      MS SQL Server:

      org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_user_5070F446'. Cannot insert duplicate key in object 'os_user'.
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:88)
      caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_os_user_5070F446'. Cannot insert duplicate key in object 'os_user'.
      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)

      MySQL:

      org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '1' for key 1
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:88)
      caused by: java.sql.BatchUpdateException: Duplicate entry '1' for key 1
      at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647)

        1. atlassian-bucket-2006.04.11-createuser-patch.jar
          303 kB
          dave

            [CONFSERVER-6092] Cannot create new user due to primary key violation or unique constraint error

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2901396 ] New: CONFSERVER Bug Workflow v4 [ 2996012 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2797585 ] New: JAC Bug Workflow v3 [ 2901396 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2727754 ] New: JAC Bug Workflow v2 [ 2797585 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392499 ] New: JAC Bug Workflow [ 2727754 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2274333 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392499 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2229718 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2274333 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2187093 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2229718 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1913086 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2187093 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1719731 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1913086 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1671519 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1719731 ]

              Unassigned Unassigned
              dave@atlassian.com dave (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: