Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-6428

Update 3.10 -> 4.0 fails if crowd resyncGroupsList contains fisheye-users or crucible-users

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • High
    • 4.0.2
    • 4.0.0, 4.0.1
    • None

    Description

      Problem description

      On update 3.10 -> 4.0 we create two "special" default groups fisheye-users and crucible-users with FishEye/Crucible global permissions respectively. This happens in com.cenqua.crucible.hibernate.upgrade.crowd.MigrateUserLicenses.

      Further on, we add global permissions for all the groups in config.xml/security/crowd/resyncGroupsList. If user had fisheye-users or crucible-users defined there, we fail, because these groups have had the global permissions already added in #addDefaultGroups.

      If an update has failed

      Once the update has failed because of fisheye-users or crucible-users groups, you first have to roll back to previous working version (3.10.3 or earlier) before continuing.

      Workaround for updating to 4.0.0 and 4.0.1

      Before upgrading to 4.0, remove <group name="fisheye-users"/> and <group name="crucible-users"/> from config.xml/security/crowd/resyncGroupsList. Leave the other groups intact.

      Updating to 4.0.2

      Provided you start from a working instance (not one that has failed to upgrade to 4.0.0/4.0.1), upgrading to 4.0.2 does not require any extra steps regarding this issue.

      Message on the first run

       2016-03-17 10:58:22,799 INFO  - Migrating user licenses
      2016-03-17 10:58:22,810 INFO  - Creating group fisheye-users with permission 'FishEye users'
      2016-03-17 10:58:22,829 INFO  - Creating group crucible-users with permission 'Crucible users'
      2016-03-17 10:58:22,860 INFO  - Adding permission to Crowd group fisheye-users
      2016-03-17 10:58:22,913 ERROR - The Web context could not be started
      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 /opt/atlassian/fecru-4.0.1/sql/ORACLE/upgrade/upgrade_92.sql: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FISHEYE.UK_GP_GROUP_NAME) violated
      
              at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:278) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1115) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1018) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:706) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:775) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:424) [jetty-servlet-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:767) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:249) [jetty-servlet-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1252) [jetty-webapp-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:710) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:494) [jetty-webapp-8.1.10.v20130312.jar:8.1.10.v20130312]
              at com.cenqua.fisheye.web.jetty.FishEyeWebApplicationContext.doStart(FishEyeWebApplicationContext.java:32) [fisheye.jar:?]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:229) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:172) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:229) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.Server.doStart(Server.java:280) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at com.cenqua.fisheye.web.WebServer.start(WebServer.java:335) [fisheye.jar:?]
              at com.cenqua.fisheye.ctl.Run.mainImpl(Run.java:229) [fisheye.jar:?]
              at com.cenqua.fisheye.ctl.Run.main(Run.java:56) [fisheye.jar:?]
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [?:1.8.0_71]
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_71]
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_71]
              at java.lang.reflect.Method.invoke(Method.java:497) [?:1.8.0_71]
              at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101) [fisheyeboot.jar:?]
              at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44) [fisheyeboot.jar:?]
      Caused by: 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 /opt/atlassian/fecru-4.0.1/sql/ORACLE/upgrade/upgrade_92.sql: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FISHEYE.UK_GP_GROUP_NAME) violated
      
              at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:164) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:125) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:270) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              ... 40 more
      Caused by: com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script /opt/atlassian/fecru-4.0.1/sql/ORACLE/upgrade/upgrade_92.sql: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FISHEYE.UK_GP_GROUP_NAME) violated
      
              at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:432) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.start(DefaultDBControl.java:260) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.start(DefaultDBControl.java:242) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DBControlFactoryImpl.<init>(DBControlFactoryImpl.java:40) [fisheye.jar:?]
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_71]
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_71]
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_71]
              at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_71]
              at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              ... 42 more
      Caused by: java.lang.RuntimeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FISHEYE.UK_GP_GROUP_NAME) violated
      
              at com.cenqua.crucible.hibernate.upgrade.crowd.CrowdUpgradeUtil.executeUpdate(CrowdUpgradeUtil.java:70) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.upgrade.crowd.MigrateUserLicenses.addGlobalPermission(MigrateUserLicenses.java:190) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.upgrade.crowd.MigrateUserLicenses.lambda$null$127(MigrateUserLicenses.java:75) [fisheye.jar:?]
              at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) [?:1.8.0_71]
              at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) [?:1.8.0_71]
              at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948) [?:1.8.0_71]
              at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) [?:1.8.0_71]
              at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) [?:1.8.0_71]
              at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) [?:1.8.0_71]
              at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174) [?:1.8.0_71]
              at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) [?:1.8.0_71]
              at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) [?:1.8.0_71]
              at com.cenqua.crucible.hibernate.upgrade.crowd.MigrateUserLicenses.lambda$migrateCrowdGroups$128(MigrateUserLicenses.java:88) [fisheye.jar:?]
              at java.util.Optional.ifPresent(Optional.java:159) [?:1.8.0_71]
              at com.cenqua.crucible.hibernate.upgrade.crowd.MigrateUserLicenses.migrateCrowdGroups(MigrateUserLicenses.java:72) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.upgrade.crowd.MigrateUserLicenses.perform(MigrateUserLicenses.java:66) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.upgrade.crowd.EmbeddedCrowdUpgradeTask.afterUpgradeScript(EmbeddedCrowdUpgradeTask.java:83) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.upgrade.UpgradeTaskManager$ChainedUpgradeTask.afterUpgradeScript(UpgradeTaskManager.java:40) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.doUpgrade(DefaultDBControl.java:467) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:423) [fisheye.jar:?]
              ... 50 more
      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (FISHEYE.UK_GP_GROUP_NAME) violated
      
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at com.cenqua.crucible.hibernate.upgrade.crowd.CrowdUpgradeUtil.executeUpdate(CrowdUpgradeUtil.java:67) [fisheye.jar:?]
              ... 69 more
      

      Message on subsequent runs

      DB is left in an inconsistent state, so subsequent attempts to start FishEye/Crucible fails with this output:

      2016-03-17 10:59:00,659 INFO  - Upgrading DB from version 92 using /opt/atlassian/fecru-4.0.1/sql/ORACLE/upgrade/upgrade_92.sql
      2016-03-17 10:59:00,820 ERROR - The Web context could not be started
      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 /opt/atlassian/fecru-4.0.1/sql/ORACLE/upgrade/upgrade_92.sql: SQL script error on line 1: "create table cwd_app_dir_group_mapping (id number(19,0) not null, app_dir_mapping_id number(19,0) not null, application_id number(19,0) not null, directory_id number(19,0) not null, group_name varchar2(255 char) not null, primary key (id));"
          (ORA-00955: name is already used by an existing object
          ), please contact http://www.atlassian.com/support/
              at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:278) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1115) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1018) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:302) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:229) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:298) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:706) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:775) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:424) [jetty-servlet-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:767) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:249) [jetty-servlet-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1252) [jetty-webapp-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:710) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:494) [jetty-webapp-8.1.10.v20130312.jar:8.1.10.v20130312]
              at com.cenqua.fisheye.web.jetty.FishEyeWebApplicationContext.doStart(FishEyeWebApplicationContext.java:32) [fisheye.jar:?]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:229) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:172) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:229) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:95) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.server.Server.doStart(Server.java:280) [jetty-server-8.1.10.v20130312.jar:8.1.10.v20130312]
              at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:64) [jetty-util-8.1.10.v20130312.jar:8.1.10.v20130312]
              at com.cenqua.fisheye.web.WebServer.start(WebServer.java:335) [fisheye.jar:?]
              at com.cenqua.fisheye.ctl.Run.mainImpl(Run.java:229) [fisheye.jar:?]
              at com.cenqua.fisheye.ctl.Run.main(Run.java:56) [fisheye.jar:?]
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [?:1.8.0_71]
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_71]
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_71]
              at java.lang.reflect.Method.invoke(Method.java:497) [?:1.8.0_71]
              at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:101) [fisheyeboot.jar:?]
              at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:44) [fisheyeboot.jar:?]
      Caused by: 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 /opt/atlassian/fecru-4.0.1/sql/ORACLE/upgrade/upgrade_92.sql: SQL script error on line 1: "create table cwd_app_dir_group_mapping (id number(19,0) not null, app_dir_mapping_id number(19,0) not null, application_id number(19,0) not null, directory_id number(19,0) not null, group_name varchar2(255 char) not null, primary key (id));"
          (ORA-00955: name is already used by an existing object
          ), please contact http://www.atlassian.com/support/
              at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:164) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:125) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:270) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              ... 40 more
      Caused by: com.cenqua.crucible.hibernate.CruDBException: Problem upgrading with script /opt/atlassian/fecru-4.0.1/sql/ORACLE/upgrade/upgrade_92.sql: SQL script error on line 1: "create table cwd_app_dir_group_mapping (id number(19,0) not null, app_dir_mapping_id number(19,0) not null, application_id number(19,0) not null, directory_id number(19,0) not null, group_name varchar2(255 char) not null, primary key (id));"
          (ORA-00955: name is already used by an existing object
          ), please contact http://www.atlassian.com/support/
              at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:432) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.start(DefaultDBControl.java:260) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.start(DefaultDBControl.java:242) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DBControlFactoryImpl.<init>(DBControlFactoryImpl.java:40) [fisheye.jar:?]
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_71]
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_71]
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_71]
              at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_71]
              at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:148) [spring-beans-4.0.9.RELEASE.jar:4.0.9.RELEASE]
              ... 42 more
      Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "create table cwd_app_dir_group_mapping (id number(19,0) not null, app_dir_mapping_id number(19,0) not null, application_id number(19,0) not null, directory_id number(19,0) not null, group_name varchar2(255 char) not null, primary key (id));"
          (ORA-00955: name is already used by an existing object
          ), please contact http://www.atlassian.com/support/
              at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:576) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:507) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.doUpgrade(DefaultDBControl.java:465) [fisheye.jar:?]
              at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:423) [fisheye.jar:?]
              ... 50 more
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
      
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1707) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1670) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310) [ojdbc7-12cR1.jar:12.1.0.2.0]
              at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:548) [fisheye.jar:?]
              ... 53 more

      Attachments

        Issue Links

          Activity

            People

              kcichy Kamil Cichy
              kcichy Kamil Cichy
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: