You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users-cn@cloudstack.apache.org by "linuxbqj@gmail.com" <li...@gmail.com> on 2015/01/16 02:09:32 UTC
Re: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
看错误是数据库的访问问题
2015-01-15 16:12 GMT+08:00 李强 <qi...@qq.com>:
> 谁遇见过这个问题，起因是增加了vcenter zone 然后重启就起不来了。
>
>
> Log4j configuration from : /usr/share/cloudstack-management/conf/log4j-cloud.xml
> Jan 15, 2015 4:08:28 PM org.apache.catalina.core.StandardContext loadOnStartup
> SEVERE: Servlet /awsapi threw load() exception
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'http://localhost:7080/awsapi' for key 'mhost_uq_host'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1363)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5.CGLIB$persist$25(<generated>)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5_FastClassByCloudStack_ddbcff29.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5.persist(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.setupHost(ServiceProvider.java:312)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.initialize(ServiceProvider.java:242)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905.CGLIB$initialize$1(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905_FastClassByCloudStack_dd4dbbcf.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905.initialize(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.configure(ServiceProvider.java:115)
> at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
> at com.cloud.bridge.service.EC2MainServlet.init(EC2MainServlet.java:69)
> at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
> at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4425)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4738)
> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
> at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:516)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Jan 15, 2015 4:08:28 PM org.apache.axis2.deployment.ClusterBuilder buildCluster
> INFO: Clustering has been disabled
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: ping-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/ping-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: soapmonitor-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/soapmonitor-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/addressing-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: jaxws-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/axis2-jaxws-mar-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: script-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/scripting-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: metadataExchange-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mex-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: mtompolicy-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mtompolicy-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/axis2-1.5.6.jar
> Jan 15, 2015 4:08:32 PM org.apache.catalina.loader.WebappClassLoader loadClass
> INFO: Illegal access: this web application instance has been stopped already. Could not load org.apache.cloudstack.managed.context.ManagedContextTimerTask$1. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
> java.lang.IllegalStateException
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1369)
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
> at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
> at java.util.TimerThread.mainLoop(Timer.java:555)
> at java.util.TimerThread.run(Timer.java:505)
> Exception in thread "Timer-2" java.lang.NoClassDefFoundError: org/apache/cloudstack/managed/context/ManagedContextTimerTask$1
> at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
> at java.util.TimerThread.mainLoop(Timer.java:555)
> at java.util.TimerThread.run(Timer.java:505)
> Caused by: java.lang.ClassNotFoundException: org.apache.cloudstack.managed.context.ManagedContextTimerTask$1
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1483)
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
> ... 3 more
> Jan 15, 2015 4:08:32 PM org.apache.axis2.deployment.ServiceDeployer deploy
> INFO: Deploying Web service: version-1.5.6.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/version-1.5.6.aar
> Jan 15, 2015 4:08:34 PM org.apache.axis2.deployment.ServiceDeployer deploy
> INFO: Deploying Web service: cloud-ec2.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/cloud-ec2.aar
> Jan 15, 2015 4:08:34 PM org.apache.axis2.util.OnDemandLogger warn
> WARNING: No transportReceiver for org.apache.axis2.transport.http.AxisServletListener found. An instance for HTTP will be configured automatically. Please update your axis2.xml file!
> Jan 15, 2015 4:08:34 PM org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor <init>
> INFO: JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
> Jan 15, 2015 4:08:34 PM org.apache.coyote.http11.Http11NioProtocol start
> INFO: Starting Coyote HTTP/1.1 on http-7080
> Jan 15, 2015 4:08:34 PM org.apache.catalina.startup.Catalina start
> INFO: Server startup in 33868 ms
--
白清杰 (Born Bai)
Mail: linuxbqj@gmail.com
回复： Re: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Posted by 李强 <qi...@qq.com>.
4.4.2 的版本
下面是日志应该全了。
INFO: validateJarFile(/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/lib/geronimo-servlet_3.0_spec-1.0.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
Jan 16, 2015 3:41:01 PM org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already. Could not load net.sf.ehcache.util.ProductInfo. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1369)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
at net.sf.ehcache.util.UpdateChecker.buildParamsString(UpdateChecker.java:133)
at net.sf.ehcache.util.UpdateChecker.buildUpdateCheckUrl(UpdateChecker.java:123)
at net.sf.ehcache.util.UpdateChecker.doCheck(UpdateChecker.java:68)
at net.sf.ehcache.util.UpdateChecker.checkForUpdate(UpdateChecker.java:60)
at net.sf.ehcache.util.UpdateChecker.run(UpdateChecker.java:51)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Exception in thread "net.sf.ehcache.CacheManager@81836f1" java.lang.NullPointerException
at org.slf4j.impl.Log4jLoggerAdapter.debug(Log4jLoggerAdapter.java:285)
at net.sf.ehcache.util.UpdateChecker.checkForUpdate(UpdateChecker.java:63)
at net.sf.ehcache.util.UpdateChecker.run(UpdateChecker.java:51)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/slf4j-jdk14-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.JDK14LoggerFactory]
Jan 16, 2015 3:41:01 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
Jan 16, 2015 3:41:01 PM org.springframework.web.context.ContextLoader initWebApplicationContext
INFO: Root WebApplicationContext: initialization started
Jan 16, 2015 3:41:01 PM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing Root WebApplicationContext: startup date [Fri Jan 16 15:41:01 CST 2015]; root of context hierarchy
Jan 16, 2015 3:41:01 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
Jan 16, 2015 3:41:01 PM org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider registerDefaultFilters
INFO: JSR-330 'javax.inject.Named' annotation found and supported for component scanning
Jan 16, 2015 3:41:04 PM org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor <init>
INFO: JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
Jan 16, 2015 3:41:04 PM org.springframework.context.support.AbstractApplicationContext$BeanPostProcessorChecker postProcessAfterInitialization
INFO: Bean 'transactionContextBuilder' of type [class com.cloud.utils.db.TransactionContextBuilder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
Jan 16, 2015 3:41:04 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@17bebeb1: defining beans [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,SObjectItemDaoImpl,cloudStackConfigurationDaoImpl,userCredentialsDaoImpl,multiPartPartsDaoImpl,cloudStackUserDaoImpl,multipartMetaDaoImpl,multiPartUploadsDaoImpl,SBucketDaoImpl,SMetaDaoImpl,cloudStackAccountDaoImpl,MHostDaoImpl,SAclDaoImpl,offeringDaoImpl,bucketPolicyDaoImpl,SObjectDaoImpl,cloudStackSvcOfferingDaoImpl,SHostDaoImpl,MHostMountDaoImpl,EC2RestServlet,serviceProvider,EC2MainServlet,EC2Engine,s3Engine,componentContext,transactionContextBuilder,instantiatePostProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; root of factory hierarchy
log4j:WARN No appenders could be found for logger (com.cloud.utils.crypt.EncryptionSecretKeyChecker).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Jan 16, 2015 3:41:05 PM org.springframework.web.context.ContextLoader initWebApplicationContext
INFO: Root WebApplicationContext: initialization completed in 4263 ms
Jan 16, 2015 3:41:05 PM org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor <init>
INFO: JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.OfferingDaoImpl_EnhancerByCloudStack_979ece34
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.CloudStackAccountDaoImpl_EnhancerByCloudStack_2945eda
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.SMetaDaoImpl_EnhancerByCloudStack_b445be2c
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.UserCredentialsDaoImpl_EnhancerByCloudStack_5547894b
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.MultipartMetaDaoImpl_EnhancerByCloudStack_9bae40eb
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.CloudStackConfigurationDaoImpl_EnhancerByCloudStack_c379d109
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.BucketPolicyDaoImpl_EnhancerByCloudStack_1b143ace
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.SObjectItemDaoImpl_EnhancerByCloudStack_ff26f297
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.MHostMountDaoImpl_EnhancerByCloudStack_542a26a6
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_c61248e7
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.MultiPartUploadsDaoImpl_EnhancerByCloudStack_8186ee14
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.SBucketDaoImpl_EnhancerByCloudStack_52c32adf
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.SAclDaoImpl_EnhancerByCloudStack_c5b2035b
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.CloudStackSvcOfferingDaoImpl_EnhancerByCloudStack_4cd704f9
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.MultiPartPartsDaoImpl_EnhancerByCloudStack_4d811896
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.SHostDaoImpl_EnhancerByCloudStack_eea4bf31
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.SObjectDaoImpl_EnhancerByCloudStack_d57f2f22
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.persist.dao.CloudStackUserDaoImpl_EnhancerByCloudStack_d0cdb47c
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.service.core.ec2.EC2Engine_EnhancerByCloudStack_280c13d2
INFO [c.c.u.c.ComponentContext] (main:null) Configuring com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_533cae47
Log4j configuration from : /usr/share/cloudstack-management/conf/log4j-cloud.xml
Jan 16, 2015 3:41:06 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /awsapi threw load() exception
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'http://localhost:7080/awsapi' for key 'mhost_uq_host'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1363)
at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_c61248e7.CGLIB$persist$25(<generated>)
at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_c61248e7_FastClassByCloudStack_fbffd9ee.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_c61248e7.persist(<generated>)
at com.cloud.bridge.service.controller.s3.ServiceProvider.setupHost(ServiceProvider.java:312)
at com.cloud.bridge.service.controller.s3.ServiceProvider.initialize(ServiceProvider.java:242)
at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_533cae47.CGLIB$initialize$1(<generated>)
at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_533cae47_FastClassByCloudStack_d6e2af19.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_533cae47.initialize(<generated>)
at com.cloud.bridge.service.controller.s3.ServiceProvider.configure(ServiceProvider.java:115)
at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
at com.cloud.bridge.service.EC2MainServlet.init(EC2MainServlet.java:69)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4425)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4738)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ClusterBuilder buildCluster
INFO: Clustering has been disabled
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: ping-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/ping-1.5.6.mar
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: soapmonitor-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/soapmonitor-1.5.6.mar
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/addressing-1.5.6.mar
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: jaxws-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/axis2-jaxws-mar-1.5.6.mar
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: script-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/scripting-1.5.6.mar
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: metadataExchange-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mex-1.5.6.mar
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: mtompolicy-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mtompolicy-1.5.6.mar
Jan 16, 2015 3:41:06 PM org.apache.axis2.deployment.ModuleDeployer deploy
INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/axis2-1.5.6.jar
Jan 16, 2015 3:41:08 PM org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already. Could not load org.apache.cloudstack.managed.context.ManagedContextTimerTask$1. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1369)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Exception in thread "Timer-2" java.lang.NoClassDefFoundError: org/apache/cloudstack/managed/context/ManagedContextTimerTask$1
at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
at java.util.TimerThread.mainLoop(Timer.java:555)
at java.util.TimerThread.run(Timer.java:505)
Caused by: java.lang.ClassNotFoundException: org.apache.cloudstack.managed.context.ManagedContextTimerTask$1
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1483)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
... 3 more
Jan 16, 2015 3:41:10 PM org.apache.axis2.deployment.ServiceDeployer deploy
INFO: Deploying Web service: version-1.5.6.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/version-1.5.6.aar
Jan 16, 2015 3:41:11 PM org.apache.axis2.deployment.ServiceDeployer deploy
INFO: Deploying Web service: cloud-ec2.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/cloud-ec2.aar
Jan 16, 2015 3:41:11 PM org.apache.axis2.util.OnDemandLogger warn
WARNING: No transportReceiver for org.apache.axis2.transport.http.AxisServletListener found. An instance for HTTP will be configured automatically. Please update your axis2.xml file!
Jan 16, 2015 3:41:11 PM org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor <init>
INFO: JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
Jan 16, 2015 3:41:11 PM org.apache.coyote.http11.Http11NioProtocol start
INFO: Starting Coyote HTTP/1.1 on http-7080
Jan 16, 2015 3:41:11 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 33542 ms
------------------ 原始邮件 ------------------
发件人: "yan_5386@163.com";<ya...@163.com>;
发送时间: 2015年1月16日(星期五) 上午9:27
收件人: "users-cn"<us...@cloudstack.apache.org>;
主题: Re: Re: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
1、版本是哪个？
2、日志没打全，问题解决很大程度依赖日志。打开Debug开关，再贴出异常栈
山东济南 崔
From: linuxbqj@gmail.com
Date: 2015-01-16 09:09
To: users-cn
Subject: Re: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
看错误是数据库的访问问题
2015-01-15 16:12 GMT+08:00 李强 <qi...@qq.com>:
> 谁遇见过这个问题，起因是增加了vcenter zone 然后重启就起不来了。
>
>
> Log4j configuration from : /usr/share/cloudstack-management/conf/log4j-cloud.xml
> Jan 15, 2015 4:08:28 PM org.apache.catalina.core.StandardContext loadOnStartup
> SEVERE: Servlet /awsapi threw load() exception
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'http://localhost:7080/awsapi' for key 'mhost_uq_host'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1363)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5.CGLIB$persist$25(<generated>)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5_FastClassByCloudStack_ddbcff29.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5.persist(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.setupHost(ServiceProvider.java:312)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.initialize(ServiceProvider.java:242)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905.CGLIB$initialize$1(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905_FastClassByCloudStack_dd4dbbcf.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905.initialize(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.configure(ServiceProvider.java:115)
> at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
> at com.cloud.bridge.service.EC2MainServlet.init(EC2MainServlet.java:69)
> at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
> at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4425)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4738)
> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
> at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:516)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Jan 15, 2015 4:08:28 PM org.apache.axis2.deployment.ClusterBuilder buildCluster
> INFO: Clustering has been disabled
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: ping-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/ping-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: soapmonitor-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/soapmonitor-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/addressing-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: jaxws-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/axis2-jaxws-mar-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: script-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/scripting-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: metadataExchange-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mex-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: mtompolicy-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mtompolicy-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/axis2-1.5.6.jar
> Jan 15, 2015 4:08:32 PM org.apache.catalina.loader.WebappClassLoader loadClass
> INFO: Illegal access: this web application instance has been stopped already. Could not load org.apache.cloudstack.managed.context.ManagedContextTimerTask$1. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
> java.lang.IllegalStateException
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1369)
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
> at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
> at java.util.TimerThread.mainLoop(Timer.java:555)
> at java.util.TimerThread.run(Timer.java:505)
> Exception in thread "Timer-2" java.lang.NoClassDefFoundError: org/apache/cloudstack/managed/context/ManagedContextTimerTask$1
> at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
> at java.util.TimerThread.mainLoop(Timer.java:555)
> at java.util.TimerThread.run(Timer.java:505)
> Caused by: java.lang.ClassNotFoundException: org.apache.cloudstack.managed.context.ManagedContextTimerTask$1
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1483)
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
> ... 3 more
> Jan 15, 2015 4:08:32 PM org.apache.axis2.deployment.ServiceDeployer deploy
> INFO: Deploying Web service: version-1.5.6.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/version-1.5.6.aar
> Jan 15, 2015 4:08:34 PM org.apache.axis2.deployment.ServiceDeployer deploy
> INFO: Deploying Web service: cloud-ec2.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/cloud-ec2.aar
> Jan 15, 2015 4:08:34 PM org.apache.axis2.util.OnDemandLogger warn
> WARNING: No transportReceiver for org.apache.axis2.transport.http.AxisServletListener found. An instance for HTTP will be configured automatically. Please update your axis2.xml file!
> Jan 15, 2015 4:08:34 PM org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor <init>
> INFO: JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
> Jan 15, 2015 4:08:34 PM org.apache.coyote.http11.Http11NioProtocol start
> INFO: Starting Coyote HTTP/1.1 on http-7080
> Jan 15, 2015 4:08:34 PM org.apache.catalina.startup.Catalina start
> INFO: Server startup in 33868 ms
--
白清杰 (Born Bai)
Mail: linuxbqj@gmail.com
Re: Re: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Posted by "yan_5386@163.com" <ya...@163.com>.
1、版本是哪个？
2、日志没打全，问题解决很大程度依赖日志。打开Debug开关，再贴出异常栈
山东济南 崔
From: linuxbqj@gmail.com
Date: 2015-01-16 09:09
To: users-cn
Subject: Re: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
看错误是数据库的访问问题
2015-01-15 16:12 GMT+08:00 李强 <qi...@qq.com>:
> 谁遇见过这个问题，起因是增加了vcenter zone 然后重启就起不来了。
>
>
> Log4j configuration from : /usr/share/cloudstack-management/conf/log4j-cloud.xml
> Jan 15, 2015 4:08:28 PM org.apache.catalina.core.StandardContext loadOnStartup
> SEVERE: Servlet /awsapi threw load() exception
> com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'http://localhost:7080/awsapi' for key 'mhost_uq_host'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
> at com.mysql.jdbc.Util.getInstance(Util.java:386)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1363)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5.CGLIB$persist$25(<generated>)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5_FastClassByCloudStack_ddbcff29.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
> at com.cloud.bridge.persist.dao.MHostDaoImpl_EnhancerByCloudStack_49c373a5.persist(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.setupHost(ServiceProvider.java:312)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.initialize(ServiceProvider.java:242)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905.CGLIB$initialize$1(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905_FastClassByCloudStack_dd4dbbcf.invoke(<generated>)
> at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
> at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
> at com.cloud.bridge.service.controller.s3.ServiceProvider_EnhancerByCloudStack_d6edd905.initialize(<generated>)
> at com.cloud.bridge.service.controller.s3.ServiceProvider.configure(ServiceProvider.java:115)
> at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
> at com.cloud.bridge.service.EC2MainServlet.init(EC2MainServlet.java:69)
> at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
> at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
> at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4425)
> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4738)
> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
> at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
> at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at org.apache.catalina.core.StandardService.start(StandardService.java:516)
> at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:593)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Jan 15, 2015 4:08:28 PM org.apache.axis2.deployment.ClusterBuilder buildCluster
> INFO: Clustering has been disabled
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: ping-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/ping-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: soapmonitor-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/soapmonitor-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/addressing-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: jaxws-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/axis2-jaxws-mar-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: script-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/scripting-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: metadataExchange-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mex-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: mtompolicy-1.5.6 - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/modules/mtompolicy-1.5.6.mar
> Jan 15, 2015 4:08:29 PM org.apache.axis2.deployment.ModuleDeployer deploy
> INFO: Deploying module: addressing-1.5.6 - file:/usr/share/cloudstack-bridge/webapps/awsapi/WEB-INF/lib/axis2-1.5.6.jar
> Jan 15, 2015 4:08:32 PM org.apache.catalina.loader.WebappClassLoader loadClass
> INFO: Illegal access: this web application instance has been stopped already. Could not load org.apache.cloudstack.managed.context.ManagedContextTimerTask$1. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
> java.lang.IllegalStateException
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1369)
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
> at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
> at java.util.TimerThread.mainLoop(Timer.java:555)
> at java.util.TimerThread.run(Timer.java:505)
> Exception in thread "Timer-2" java.lang.NoClassDefFoundError: org/apache/cloudstack/managed/context/ManagedContextTimerTask$1
> at org.apache.cloudstack.managed.context.ManagedContextTimerTask.run(ManagedContextTimerTask.java:27)
> at java.util.TimerThread.mainLoop(Timer.java:555)
> at java.util.TimerThread.run(Timer.java:505)
> Caused by: java.lang.ClassNotFoundException: org.apache.cloudstack.managed.context.ManagedContextTimerTask$1
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1483)
> at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1329)
> ... 3 more
> Jan 15, 2015 4:08:32 PM org.apache.axis2.deployment.ServiceDeployer deploy
> INFO: Deploying Web service: version-1.5.6.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/version-1.5.6.aar
> Jan 15, 2015 4:08:34 PM org.apache.axis2.deployment.ServiceDeployer deploy
> INFO: Deploying Web service: cloud-ec2.aar - file:/usr/share/cloudstack-management/webapps7080/awsapi/WEB-INF/services/cloud-ec2.aar
> Jan 15, 2015 4:08:34 PM org.apache.axis2.util.OnDemandLogger warn
> WARNING: No transportReceiver for org.apache.axis2.transport.http.AxisServletListener found. An instance for HTTP will be configured automatically. Please update your axis2.xml file!
> Jan 15, 2015 4:08:34 PM org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor <init>
> INFO: JSR-330 'javax.inject.Inject' annotation found and supported for autowiring
> Jan 15, 2015 4:08:34 PM org.apache.coyote.http11.Http11NioProtocol start
> INFO: Starting Coyote HTTP/1.1 on http-7080
> Jan 15, 2015 4:08:34 PM org.apache.catalina.startup.Catalina start
> INFO: Server startup in 33868 ms
--
白清杰 (Born Bai)
Mail: linuxbqj@gmail.com