Reviews cannot be created due to ConstraintViolationException
Problem
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
Cause
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
Resolution
Stop the non-production Fisheye/Crucible server.