Violation of UNIQUE KEY constraint 'cwd_unique_membership'

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

Some LDAP users can't access Confluence. The errors on the logs indicate a Constrain Violation and a duplicate value. Checking the cwd_membership shows that the values are not duplicated.

 

atlassian-confluence.log に次のメッセージが表示される。

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#6456133]; SQL []; Violation of UNIQUE KEY constraint 'cwd_unique_membership'. 
Cannot insert duplicate key in object 'dbo.cwd_membership'. The duplicate key value is (310715, <NULL>, 6462549).; nested exception is java.sql.SQLException: Violation of UNIQUE KEY constraint 'cwd_unique_membership'. Cannot insert duplicate key in object 'dbo.cwd_membership'. The duplicate key value is (310715, <NULL>, 6462549).
caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#6456132]; SQL []; Violation of PRIMARY KEY constraint 'PK__cwd_memb__3213E83FC6CE8E53'. Cannot insert duplicate key in object 'dbo.cwd_membership'. The duplicate key value is (6462549).; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__cwd_memb__3213E83FC6CE8E53'. Cannot insert duplicate key in object 'dbo.cwd_membership'. The duplicate key value is (6462549).
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__cwd_memb__3213E83FC6CE8E53'. Cannot insert duplicate key in object 'dbo.cwd_membership'. The duplicate key value is (6462549).
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

診断

Recreating the Directory do not help. It might be a bug on version 5.1 that we could not identify already.

 

回避策

Upgrade Confluence to 5.3.

 

Last modified on Mar 30, 2016

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.