Details
-
Bug
-
Resolution: Handled by Support
-
Highest
-
None
-
1.6.2.1, 1.6.6, 2.0, 2.2.1
-
None
-
SunOS 5.10 Generic_141415-08 i86pc i386 i86pc Solaris
java version "1.6.0_13"
Java(TM) SE Runtime Environment (build 1.6.0_13-b03)
Java HotSpot(TM) Server VM (build 11.3-b02, mixed mode)"FISHEYE_INST" type installation
Description
Originally, I tried to upgrade directly from our currently installed version of Crucible, 1.6.2.1, to the latest and greatest, 2.2.1. Because that failed, while executing sql upgrade scripts, I tried to upgrade in smaller steps.
So I then upgraded (the original, backed up) version 1.6.2.1 to 1.6.3, which was fine (and did not involve any db upgrade script, according to fisheye.out). I continued and upgraded from 1.6.3 directly to 1.6.6, which was fine, too. Again, no sql upgrade scripts run in that step, either.
In the next step, from 1.6.6 to 2.0.0, crucible exited during the sql upgrade process. The fisheye.out starts like this:
INFO - FishEye/Crucible 2.0.0 (build-410), Built on 2009-06-29 INFO - FishEye: Commercial License registered to TradingScreen Inc. Japan. () INFO - Periodic polling for software updates is disabled. INFO - Starting plugin system... INFO - Starting database... INFO - Upgrading DB from version 29 using /data/tsbuild/crucible/fecru-2.0.0/sql/HSQL/upgrade/upgrade_29.sql INFO - Upgrading DB from version 30 using /data/tsbuild/crucible/fecru-2.0.0/sql/HSQL/upgrade/upgrade_30.sql INFO - Upgrading DB from version 31 using /data/tsbuild/crucible/fecru-2.0.0/sql/HSQL/upgrade/upgrade_31.sql INFO - Upgrading DB from version 32 using /data/tsbuild/crucible/fecru-2.0.0/sql/HSQL/upgrade/upgrade_32.sql INFO - Upgrading DB from version 33 using /data/tsbuild/crucible/fecru-2.0.0/sql/HSQL/upgrade/upgrade_33.sql 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.CruD BException: Problem upgrading with script /data/tsbuild/crucible/fecru-2.0.0/sql/HSQL/upgrade/upgrade_33.sql: SQL script error on line 47: "insert into cru_frx_comment (select cru_comment, cru_frx_id from cru_revision_comment where cru_line_range is null);" (Violation of unique constraint SYS_PK_643: duplicate value(s) for column(s) CRU_COMMENT_ID), please contact http://www.atlassian.com/support/ at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254)
The full output is attached to this JIRA issue.