cloudstack-users-cn mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "yan_5386@163.com" <yan_5...@163.com>
Subject Re: Re: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Date Fri, 16 Jan 2015 01:27:34 GMT
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 李强 <qiang.li7@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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message