Reviews cannot be created due to ConstraintViolationException

お困りですか?

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

コミュニティに質問

問題

When creating a review, the following message is displayed to the user:

URL: /json/cru/createReviewDialog
 
An org.hibernate.exception.ConstraintViolationException was encountered
could not execute statement
ORA-00001: unique constraint (CRUCIBLE.SYS_C0054150) violated

 

The following appears in the atlassian-fisheye-YYYY-MM-DD.log:

WARN  [qtp1345923076-254092 ] org.hibernate.engine.jdbc.spi.SqlExceptionHelper SqlExceptionHelper-logExceptions - SQL Error: 1, SQLState: 23000
ERROR [qtp1345923076-254092 ] org.hibernate.engine.jdbc.spi.SqlExceptionHelper SqlExceptionHelper-logExceptions - ORA-00001: unique constraint (CRUCIBLE.SYS_C0054150) violated
ERROR [qtp1345923076-254092 ] fisheye SessionState-commitAllTx - Commit failed. Rolling back.
org.hibernate.exception.ConstraintViolationException: could not execute statement
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:74) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CRUCIBLE.SYS_C0054150) violated

原因

Two separate Fisheye/Crucible servers (e.g. a test and a production one) are connecting to the same database.

There is an existing suggestion to prevent this case from happening:  FE-6658 - Getting issue details... STATUS

ソリューション

Stop the non-production Fisheye/Crucible server.

最終更新日 2018 年 7 月 31 日

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

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