com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script /usr/local/crucible-2.0.0/sql/HSQL/upgrade/upgrade_30.sql: SQL script error on line 268: "alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review;" (Integrity constraint violation - no parent 19, table: CRU_COMMENT in statement [alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review]), please contact http://www.atlassian.com/support/

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • It appears that Crucible cannot upgrade directly from 1.6.1 to 2.0, because of the problem database http://forums.atlassian.com/ann.jspa?annID=41 Error from the log: {noformat} ERROR - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbControlFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.cenqua.crucible.hibernate.DBControlFactoryImpl]: Constructor threw exception; nested exception is com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script /usr/local/crucible-2.0.0/sql/HSQL/upgrade/upgrade_30.sql: SQL script error on line 268: "alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review;" (Integrity constraint violation - no parent 19, table: CRU_COMMENT in statement [alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review]), please contact http://www.atlassian.com/support/ at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) {noformat} A workaround is to upgrade to version 1.6.6, then upgrade to version 2.0. To do so; # Shutdown your Crucible server completely. # Make a backup of your {{FISHEYE_INST}} directory # Download crucible 1.6.6 from [www.atlassian.com] # Follow the instructions in the [Upgrade Guide|http://confluence.atlassian.com/x/Z4HdBQ] to upgrade to this new version. # Next, repeat to upgrade to 2.0
    via by Ming Giet Chong [Atlassian],
  • It appears that Crucible cannot upgrade directly from 1.6.1 to 2.0, because of the problem database http://forums.atlassian.com/ann.jspa?annID=41 Error from the log: {noformat} ERROR - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbControlFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.cenqua.crucible.hibernate.DBControlFactoryImpl]: Constructor threw exception; nested exception is com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script /usr/local/crucible-2.0.0/sql/HSQL/upgrade/upgrade_30.sql: SQL script error on line 268: "alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review;" (Integrity constraint violation - no parent 19, table: CRU_COMMENT in statement [alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review]), please contact http://www.atlassian.com/support/ at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) {noformat} A workaround is to upgrade to version 1.6.6, then upgrade to version 2.0. To do so; # Shutdown your Crucible server completely. # Make a backup of your {{FISHEYE_INST}} directory # Download crucible 1.6.6 from [www.atlassian.com] # Follow the instructions in the [Upgrade Guide|http://confluence.atlassian.com/x/Z4HdBQ] to upgrade to this new version. # Next, repeat to upgrade to 2.0
    via by Ming Giet Chong [Atlassian],
    • com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script /usr/local/crucible-2.0.0/sql/HSQL/upgrade/upgrade_30.sql: SQL script error on line 268: "alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review;" (Integrity constraint violation - no parent 19, table: CRU_COMMENT in statement [alter table cru_comment add constraint FKE5A1D10644A616B5 foreign key (cru_review_id) references cru_review]), please contact http://www.atlassian.com/support/ at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
    No Bugmate found.