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/

Atlassian JIRA | Ming Giet Chong [Atlassian] | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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

    Atlassian JIRA | 8 years ago | 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/
  2. 0

    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

    Atlassian JIRA | 8 years ago | 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/

    Root Cause Analysis

    1. 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()
    2. Spring Beans
      AbstractAutowireCapableBeanFactory$1.run
      1. org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
      3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
      4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
      5. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
      5 frames
    3. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    4. Spring Beans
      AbstractAutowireCapableBeanFactory.createBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
      1 frame