org.springframework.beans.factory.BeanCreationException

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.

  • Upgrading instance to 4.0 FishEye may fail with an error: {code} 2016-03-15 08:28:29,487 INFO - Dropping cru_name for cru_perm_scheme 2016-03-15 08:28:29,507 INFO - Dropping cru_review_id for cru_review_participant 2016-03-15 08:28:49,218 INFO - Dropping cru_source_name for cru_revision 2016-03-15 08:49:10,851 INFO - Dropping cru_user_name for cru_user 2016-03-15 08:49:11,060 INFO - Dropping cru_builtin_group_name for cru_builtin_group 2016-03-15 08:49:11,084 INFO - Dropping cru_user for cru_comment_read_status 2016-03-15 08:49:11,155 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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_66] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_66] at java.lang.reflect.Method.invoke(Method.java:497) [?:1.8.0_66] 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] 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.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'cru_user'; check that column/key exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.Util.getInstance(Util.java:386) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725) [mysql-connector-java-5.1.26-bin.jar:?] at com.cenqua.crucible.hibernate.upgrade.Hibernate4UpgradeTask.dropConstraints(Hibernate4UpgradeTask.java:99) [fisheye.jar:?] at com.cenqua.crucible.hibernate.upgrade.Hibernate4UpgradeTask.beforeUpgradeScript(Hibernate4UpgradeTask.java:58) [fisheye.jar:?] at com.cenqua.crucible.hibernate.upgrade.UpgradeTaskManager$ChainedUpgradeTask.beforeUpgradeScript(UpgradeTaskManager.java:28) [fisheye.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.doUpgrade(DefaultDBControl.java:464) [fisheye.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:423) [fisheye.jar:?] ... 50 more {code} h2. Workaround As a FishEye db user may have an access to more than one FishEye database on single db server then we may try to limit an access of FishEye db user to FishEye db only.
    via by Cezary Zawadka,
  • Upgrading instance to 4.0 FishEye may fail with an error: {code} 2016-03-15 08:28:29,487 INFO - Dropping cru_name for cru_perm_scheme 2016-03-15 08:28:29,507 INFO - Dropping cru_review_id for cru_review_participant 2016-03-15 08:28:49,218 INFO - Dropping cru_source_name for cru_revision 2016-03-15 08:49:10,851 INFO - Dropping cru_user_name for cru_user 2016-03-15 08:49:11,060 INFO - Dropping cru_builtin_group_name for cru_builtin_group 2016-03-15 08:49:11,084 INFO - Dropping cru_user for cru_comment_read_status 2016-03-15 08:49:11,155 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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_66] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_66] at java.lang.reflect.Method.invoke(Method.java:497) [?:1.8.0_66] 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] 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.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'cru_user'; check that column/key exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.Util.getInstance(Util.java:386) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811) [mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725) [mysql-connector-java-5.1.26-bin.jar:?] at com.cenqua.crucible.hibernate.upgrade.Hibernate4UpgradeTask.dropConstraints(Hibernate4UpgradeTask.java:99) [fisheye.jar:?] at com.cenqua.crucible.hibernate.upgrade.Hibernate4UpgradeTask.beforeUpgradeScript(Hibernate4UpgradeTask.java:58) [fisheye.jar:?] at com.cenqua.crucible.hibernate.upgrade.UpgradeTaskManager$ChainedUpgradeTask.beforeUpgradeScript(UpgradeTaskManager.java:28) [fisheye.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.doUpgrade(DefaultDBControl.java:464) [fisheye.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:423) [fisheye.jar:?] ... 50 more {code} h2. Workaround As a FishEye db user may have an access to more than one FishEye database on single db server then we may try to limit an access of FishEye db user to FishEye db only.
    via by Cezary Zawadka,
  • When upgrading from v3.10.3 to v4.0.2 I see this error in the log file. Fisheye will not come up and we were forced to roll back to v3.10.3. 2016-03-18 11:23:57,176 INFO - See infinitydb.com - Boiler Bay Inc 2016-03-18 11:23:57,176 INFO - InfinityDB is Copyight (C) 2001-2013 Roger L. Deran, all rights reserved. 2016-03-18 11:23:57,176 INFO - InfinityDB has been Licensed to Atlassian 2016-03-18 11:23:57,176 INFO - for distribution in FishEye and Crucible. 2016-03-18 11:23:57,176 INFO - Atlassian Pty Ltd (ABN 53 102 443 916) 2016-03-18 11:23:57,177 INFO - of 341 George St., Sydney, New South Wales, 2000 Australia 2016-03-18 11:23:57,440 INFO - UpgradeManager started. 2016-03-18 11:23:57,459 INFO - loading config from file: /var/fisheye/config.xml 2016-03-18 11:23:58,157 INFO - FishEye: Commercial License registered to Gap, Inc.. 2016-03-18 11:23:58,583 INFO - Adding secondary content dir of /var/fisheye/content 2016-03-18 11:24:07,634 INFO - Starting database... 2016-03-18 11:24:07,669 INFO - Upgrading DB from version 91 using /opt/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql 2016-03-18 11:24:07,980 INFO - Starting Hibernate4UpgradeTask.beforeUpgradeScript 2016-03-18 11:24:07,981 INFO - Dropping implicit unique constraints 2016-03-18 11:24:08,030 INFO - Done Hibernate4UpgradeTask.beforeUpgradeScript 2016-03-18 11:24:08,197 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/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql: SQL script error on line 1: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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_66] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_66] at java.lang.reflect.Method.invoke(Method.java:497) [?:1.8.0_66] 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/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql: SQL script error on line 1: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql: SQL script error on line 1: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] 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: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'idx_commitnotif_rep'; check that column/key exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.Util.getInstance(Util.java:386) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764) [mysql-connector-java-5.1.28.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:548) [fisheye.jar:?] ... 53 more 2016-03-18 11:24:08,282 INFO - Shutdown requested Exception in thread "Thread-1" org.springframework.context.ApplicationContextException: Application Context not initialised. at com.cenqua.fisheye.config.SpringContext.getApplicationContext(SpringContext.java:47) at com.cenqua.fisheye.config.SpringContext.getComponentByClass(SpringContext.java:86) at com.cenqua.fisheye.config.RootConfig.getRepositoryManager(RootConfig.java:594) at com.cenqua.fisheye.config.RootConfig.shutDownRepositories(RootConfig.java:1422) at com.cenqua.fisheye.ctl.ShutdownService.stopImpl(ShutdownService.java:281) at com.cenqua.fisheye.ctl.ShutdownService.access$000(ShutdownService.java:35) at com.cenqua.fisheye.ctl.ShutdownService$1.run(ShutdownService.java:59)
    via by Daniel Vystrcil,
  • When upgrading from v3.10.3 to v4.0.2 I see this error in the log file. Fisheye will not come up and we were forced to roll back to v3.10.3. 2016-03-18 11:23:57,176 INFO - See infinitydb.com - Boiler Bay Inc 2016-03-18 11:23:57,176 INFO - InfinityDB is Copyight (C) 2001-2013 Roger L. Deran, all rights reserved. 2016-03-18 11:23:57,176 INFO - InfinityDB has been Licensed to Atlassian 2016-03-18 11:23:57,176 INFO - for distribution in FishEye and Crucible. 2016-03-18 11:23:57,176 INFO - Atlassian Pty Ltd (ABN 53 102 443 916) 2016-03-18 11:23:57,177 INFO - of 341 George St., Sydney, New South Wales, 2000 Australia 2016-03-18 11:23:57,440 INFO - UpgradeManager started. 2016-03-18 11:23:57,459 INFO - loading config from file: /var/fisheye/config.xml 2016-03-18 11:23:58,157 INFO - FishEye: Commercial License registered to Gap, Inc.. 2016-03-18 11:23:58,583 INFO - Adding secondary content dir of /var/fisheye/content 2016-03-18 11:24:07,634 INFO - Starting database... 2016-03-18 11:24:07,669 INFO - Upgrading DB from version 91 using /opt/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql 2016-03-18 11:24:07,980 INFO - Starting Hibernate4UpgradeTask.beforeUpgradeScript 2016-03-18 11:24:07,981 INFO - Dropping implicit unique constraints 2016-03-18 11:24:08,030 INFO - Done Hibernate4UpgradeTask.beforeUpgradeScript 2016-03-18 11:24:08,197 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/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql: SQL script error on line 1: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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_66] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_66] at java.lang.reflect.Method.invoke(Method.java:497) [?:1.8.0_66] 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/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql: SQL script error on line 1: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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/fisheye/fecru-4.0.2/sql/MYSQL/upgrade/upgrade_91.sql: SQL script error on line 1: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] 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: "drop index idx_commitnotif_rep on cru_commit_notification;" (Can't DROP 'idx_commitnotif_rep'; check that column/key exists), 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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'idx_commitnotif_rep'; check that column/key exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [?:1.8.0_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422) [?:1.8.0_66] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.Util.getInstance(Util.java:386) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2819) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842) [mysql-connector-java-5.1.28.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764) [mysql-connector-java-5.1.28.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:548) [fisheye.jar:?] ... 53 more 2016-03-18 11:24:08,282 INFO - Shutdown requested Exception in thread "Thread-1" org.springframework.context.ApplicationContextException: Application Context not initialised. at com.cenqua.fisheye.config.SpringContext.getApplicationContext(SpringContext.java:47) at com.cenqua.fisheye.config.SpringContext.getComponentByClass(SpringContext.java:86) at com.cenqua.fisheye.config.RootConfig.getRepositoryManager(RootConfig.java:594) at com.cenqua.fisheye.config.RootConfig.shutDownRepositories(RootConfig.java:1422) at com.cenqua.fisheye.ctl.ShutdownService.stopImpl(ShutdownService.java:281) at com.cenqua.fisheye.ctl.ShutdownService.access$000(ShutdownService.java:35) at com.cenqua.fisheye.ctl.ShutdownService$1.run(ShutdownService.java:59)
    via by Daniel Vystrcil,
  • Drop table in mysql Database with java
    via Stack Overflow by Ernanirst
    ,
    • 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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_66] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[?:1.8.0_66] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[?:1.8.0_66] at java.lang.reflect.Method.invoke(Method.java:497)[?:1.8.0_66] 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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/crucible-cert/fecru-4.0.0/sql/MYSQL/upgrade/upgrade_91.sql: Can't DROP 'cru_user'; check that column/key exists 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_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)[?:1.8.0_66] 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.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP 'cru_user'; check that column/key exists at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[?:1.8.0_66] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[?:1.8.0_66] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[?:1.8.0_66] at java.lang.reflect.Constructor.newInstance(Constructor.java:422)[?:1.8.0_66] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811)[mysql-connector-java-5.1.26-bin.jar:?] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725)[mysql-connector-java-5.1.26-bin.jar:?] at com.cenqua.crucible.hibernate.upgrade.Hibernate4UpgradeTask.dropConstraints(Hibernate4UpgradeTask.java:99)[fisheye.jar:?] at com.cenqua.crucible.hibernate.upgrade.Hibernate4UpgradeTask.beforeUpgradeScript(Hibernate4UpgradeTask.java:58)[fisheye.jar:?] at com.cenqua.crucible.hibernate.upgrade.UpgradeTaskManager$ChainedUpgradeTask.beforeUpgradeScript(UpgradeTaskManager.java:28)[fisheye.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.doUpgrade(DefaultDBControl.java:464)[fisheye.jar:?] at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:423)[fisheye.jar:?] ... 50 more

    Users with the same issue

    rocdayrocday
    2 times, last one,
    KialandeiKialandei
    9 times, last one,
    jshakiljshakil
    23 times, last one,
    mortalman7mortalman7
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    115 more bugmates