That worked perfectly. Thanks Willard Rathjen Cloud Systems Engineer
Office +1.800.735.7104 <tel:+1.800.735.7104> | Direct +1.515.612.7813 <tel:+1.515.612.7813> willard.rath...@appcore.com <mailto:willard.rath...@appcore.com> | www.appcore.com <http://www.appcore.com/> ---------------------------------------------------------------------- The information in this message is intended for the named recipients only. It may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this message is strictly prohibited. If you have received this e-mail in error, do not print it or disseminate it or its contents. In such event, please notify the sender by return e-mail and delete the e-mail file immediately thereafter. Thank you. > On Nov 25, 2014, at 11:55 AM, Pierre-Luc Dion <pd...@cloudops.com> wrote: > > btw 4.4.2 is expected to be release in about a week to mitigate this > upgrade issue. > > > > *Pierre-Luc DION* > Architecte de Solution Cloud | Cloud Solutions Architect > t 855.652.5683 > > *CloudOps* Votre partenaire infonuagique* | *Cloud Solutions Experts > 420 rue Guy *|* Montreal *|* Quebec *|* H3J 1S6 > w cloudops.com *|* tw @CloudOps_ > > > On Tue, Nov 25, 2014 at 12:53 PM, Pierre-Luc Dion <pd...@cloudops.com> > wrote: > >> Here is an email from Mutty Cruz: >> >> I finally was able to upgrade successfully Cloudstack 4.4.0 to Cloudstack >> 4.4.1. I used this guider: >> >> http://cloudstack-release-notes.readthedocs.org/en/latest/upgrade/upgrade-4.4.html >> >> Download System VMs from here: http://cloudstack.apt-get.eu/systemvm/4.4/ >> I specifically used this: >> >> http://cloudstack.apt-get.eu/systemvm/4.4/systemvm64template-4.4.1-xen.vhd.bz2 >> >> instead of the one suggested in the guide. >> >> Also, I executed the following two command: >> yum upgrade cloudstack-management >> once that finished successfully >> yum update (updates java) >> >> This also failed for me: >> >> nohup cloudstack-sysvmadm -d IPaddress -u cloud -p password -a > >> sysvm.log 2>&1 & >> >> but I run that command any way: >> >> Also I log in to my database server: >> >> ALTER TABLE `snapshot_policy` ADD `display` TINYINT( 1 ) NOT > NULL >> DEFAULT '1' >> >> restarted management server and all worked. >> >> >> ref: >> http://markmail.org/search/?q=Status%3A%20update%20from%204.4.0%20-%3E%204.4.1%20still%20broken%20%3F#query:Status%3A%20update%20from%204.4.0%20-%3E%204.4.1%20still%20broken%20%3F+page:1+mid:izj3sy2excfn7g6q+state:results >> >> >> >> >> On Tue, Nov 25, 2014 at 12:43 PM, Willard Rathjen < >> willard.rath...@appcore.com> wrote: >> >>> I have tested this upgrade multiple times, from a fresh 4.4.0 —> 4.4.1. I >>> am encountering a tomcat 404 error after starting CS, post-upgrade. I have >>> followed the instructions provided here: >>> http://cloudstack-release-notes.readthedocs.org/en/latest/upgrade/upgrade-4.4.html >>> < >>> http://cloudstack-release-notes.readthedocs.org/en/latest/upgrade/upgrade-4.4.html >>>> >>> >>> The issue seems to be logged here (localhost.2014-11-25.log): >>> >>> Nov 25, 2014 9:48:19 AM org.apache.catalina.session.StandardSession >>> writeObject >>> WARNING: Cannot serialize session attribute accountobj for session >>> BBED8077BF2C7466AAEAAC6C8CF408CC >>> java.io.NotSerializableException: net.sf.cglib.proxy.NoOp$1 >>> at >>> java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1183) >>> at >>> java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1547) >>> at >>> java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1508) >>> at >>> java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1431) >>> at >>> java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) >>> at >>> java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) >>> at >>> org.apache.catalina.session.StandardSession.writeObject(StandardSession.java:1585) >>> at >>> org.apache.catalina.session.StandardSession.writeObjectData(StandardSession.java:1015) >>> at >>> org.apache.catalina.session.StandardManager.doUnload(StandardManager.java:529) >>> at >>> org.apache.catalina.session.StandardManager.unload(StandardManager.java:470) >>> at >>> org.apache.catalina.session.StandardManager.stop(StandardManager.java:679) >>> at >>> org.apache.catalina.core.StandardContext.stop(StandardContext.java:4886) >>> at >>> org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:936) >>> at >>> org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1359) >>> at >>> org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1330) >>> at >>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:326) >>> at >>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) >>> at >>> org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1098) >>> at >>> org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1110) >>> at >>> org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:468) >>> at >>> org.apache.catalina.core.StandardService.stop(StandardService.java:604) >>> at >>> org.apache.catalina.core.StandardServer.stop(StandardServer.java:788) >>> at org.apache.catalina.startup.Catalina.stop(Catalina.java:662) >>> 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.stop(Bootstrap.java:301) >>> 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.commons.daemon.support.DaemonLoader.stop(DaemonLoader.java:268) >>> >>> Nov 25, 2014 9:48:19 AM org.apache.catalina.session.StandardSession >>> writeObject >>> WARNING: Cannot serialize session attribute accountobj for session >>> EBE7647CA278A97F2DF25BFF5D0FD55C >>> java.io.NotSerializableException: net.sf.cglib.proxy.NoOp$1 >>> at >>> java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1183) >>> at >>> java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1547) >>> at >>> java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1508) >>> at >>> java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1431) >>> at >>> java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) >>> at >>> java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) >>> at >>> org.apache.catalina.session.StandardSession.writeObject(StandardSession.java:1585) >>> at >>> org.apache.catalina.session.StandardSession.writeObjectData(StandardSession.java:1015) >>> at >>> org.apache.catalina.session.StandardManager.doUnload(StandardManager.java:529) >>> at >>> org.apache.catalina.session.StandardManager.unload(StandardManager.java:470) >>> at >>> org.apache.catalina.session.StandardManager.stop(StandardManager.java:679) >>> at >>> org.apache.catalina.core.StandardContext.stop(StandardContext.java:4886) >>> at >>> org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:936) >>> at >>> org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1359) >>> at >>> org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1330) >>> at >>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:326) >>> at >>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) >>> at >>> org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1098) >>> at >>> org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1110) >>> at >>> org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:468) >>> at >>> org.apache.catalina.core.StandardService.stop(StandardService.java:604) >>> at >>> org.apache.catalina.core.StandardServer.stop(StandardServer.java:788) >>> at org.apache.catalina.startup.Catalina.stop(Catalina.java:662) >>> 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.stop(Bootstrap.java:301) >>> 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.commons.daemon.support.DaemonLoader.stop(DaemonLoader.java:268) >>> >>> Nov 25, 2014 9:48:19 AM org.apache.catalina.session.StandardSession >>> writeObject >>> WARNING: Cannot serialize session attribute accountobj for session >>> 1032E1517D96003BC7239CC1103E2801 >>> java.io.NotSerializableException: net.sf.cglib.proxy.NoOp$1 >>> at >>> java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1183) >>> at >>> java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1547) >>> at >>> java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1508) >>> at >>> java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1431) >>> at >>> java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1177) >>> at >>> java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:347) >>> at >>> org.apache.catalina.session.StandardSession.writeObject(StandardSession.java:1585) >>> at >>> org.apache.catalina.session.StandardSession.writeObjectData(StandardSession.java:1015) >>> at >>> org.apache.catalina.session.StandardManager.doUnload(StandardManager.java:529) >>> at >>> org.apache.catalina.session.StandardManager.unload(StandardManager.java:470) >>> at >>> org.apache.catalina.session.StandardManager.stop(StandardManager.java:679) >>> at >>> org.apache.catalina.core.StandardContext.stop(StandardContext.java:4886) >>> at >>> org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:936) >>> at >>> org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1359) >>> at >>> org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1330) >>> at >>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:326) >>> at >>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) >>> at >>> org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1098) >>> at >>> org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1110) >>> at >>> org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:468) >>> at >>> org.apache.catalina.core.StandardService.stop(StandardService.java:604) >>> at >>> org.apache.catalina.core.StandardServer.stop(StandardServer.java:788) >>> at org.apache.catalina.startup.Catalina.stop(Catalina.java:662) >>> 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.stop(Bootstrap.java:301) >>> 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.commons.daemon.support.DaemonLoader.stop(DaemonLoader.java:268) >>> >>> Nov 25, 2014 9:48:19 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Closing Spring root WebApplicationContext >>> Nov 25, 2014 9:48:19 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Shutting down log4j >>> Nov 25, 2014 9:54:08 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Set web app root system property: 'webapp.root' = >>> [/usr/share/cloudstack-management/webapps/client/] >>> Nov 25, 2014 9:54:08 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Initializing log4j from [classpath:log4j-cloud.xml] >>> Nov 25, 2014 9:54:50 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Initializing Spring root WebApplicationContext >>> Nov 25, 2014 11:24:42 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Closing Spring root WebApplicationContext >>> Nov 25, 2014 11:24:42 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Shutting down log4j >>> Nov 25, 2014 11:25:53 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Set web app root system property: 'webapp.root' = >>> [/usr/share/cloudstack-management/webapps/client/] >>> Nov 25, 2014 11:25:53 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Initializing log4j from [classpath:log4j-cloud.xml] >>> Nov 25, 2014 11:26:38 AM org.apache.catalina.core.StandardContext >>> listenerStart >>> SEVERE: Exception sending context initialized event to listener instance >>> of class >>> org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener >>> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: >>> com.mysql.jdbc.JDBC4PreparedStatement@4531ebd8: SELECT snapshot_policy.id, >>> snapshot_policy.volume_id, snapshot_policy.schedule, >>> snapshot_policy.timezone, snapshot_policy.interval, >>> snapshot_policy.max_snaps, snapshot_policy.active, snapshot_policy.uuid, >>> snapshot_policy.display FROM snapshot_policy >>> at >>> com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:1127) >>> at >>> com.cloud.utils.db.GenericDaoBase.listAllIncludingRemoved(GenericDaoBase.java:1107) >>> at >>> com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1143) >>> at >>> com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1136) >>> 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) >>> at >>> com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) >>> at >>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >>> at >>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >>> at com.sun.proxy.$Proxy176.listAll(Unknown Source) >>> at >>> com.cloud.storage.snapshot.SnapshotSchedulerImpl.start(SnapshotSchedulerImpl.java:396) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle$1.with(CloudStackExtendedLifeCycle.java:75) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.with(CloudStackExtendedLifeCycle.java:153) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.startBeans(CloudStackExtendedLifeCycle.java:72) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycleStart.run(CloudStackExtendedLifeCycleStart.java:46) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$1.with(DefaultModuleDefinitionSet.java:105) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.startContexts(DefaultModuleDefinitionSet.java:97) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:80) >>> at >>> org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) >>> at >>> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70) >>> at >>> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:57) >>> at >>> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:61) >>> at >>> org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52) >>> at >>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) >>> at >>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) >>> at >>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) >>> at >>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) >>> at >>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) >>> at >>> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) >>> at >>> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) >>> at >>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) >>> at >>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) >>> at >>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) >>> at >>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) >>> at >>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) >>> at >>> org.apache.catalina.core.StandardHost.start(StandardHost.java:822) >>> at >>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) >>> at >>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) >>> at >>> org.apache.catalina.core.StandardService.start(StandardService.java:525) >>> at >>> org.apache.catalina.core.StandardServer.start(StandardServer.java:754) >>> at org.apache.catalina.startup.Catalina.start(Catalina.java:595) >>> 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 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.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:243) >>> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >>> Unknown column 'snapshot_policy.display' in 'field list' >>> 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:1054) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) >>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) >>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) >>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) >>> at >>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) >>> at >>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313) >>> at >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) >>> at >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) >>> at >>> com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:1121) >>> ... 61 more >>> >>> Nov 25, 2014 11:26:38 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Shutting down log4j >>> Nov 25, 2014 11:28:34 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Set web app root system property: 'webapp.root' = >>> [/usr/share/cloudstack-management/webapps/client/] >>> Nov 25, 2014 11:28:34 AM org.apache.catalina.core.ApplicationContext log >>> INFO: Initializing log4j from [classpath:log4j-cloud.xml] >>> Nov 25, 2014 11:29:20 AM org.apache.catalina.core.StandardContext >>> listenerStart >>> SEVERE: Exception sending context initialized event to listener instance >>> of class >>> org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener >>> com.cloud.utils.exception.CloudRuntimeException: DB Exception on: >>> com.mysql.jdbc.JDBC4PreparedStatement@504b9025: SELECT snapshot_policy.id, >>> snapshot_policy.volume_id, snapshot_policy.schedule, >>> snapshot_policy.timezone, snapshot_policy.interval, >>> snapshot_policy.max_snaps, snapshot_policy.active, snapshot_policy.uuid, >>> snapshot_policy.display FROM snapshot_policy >>> at >>> com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:1127) >>> at >>> com.cloud.utils.db.GenericDaoBase.listAllIncludingRemoved(GenericDaoBase.java:1107) >>> at >>> com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1143) >>> at >>> com.cloud.utils.db.GenericDaoBase.listAll(GenericDaoBase.java:1136) >>> 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) >>> at >>> com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) >>> at >>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) >>> at >>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >>> at >>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >>> at com.sun.proxy.$Proxy176.listAll(Unknown Source) >>> at >>> com.cloud.storage.snapshot.SnapshotSchedulerImpl.start(SnapshotSchedulerImpl.java:396) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle$1.with(CloudStackExtendedLifeCycle.java:75) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.with(CloudStackExtendedLifeCycle.java:153) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.startBeans(CloudStackExtendedLifeCycle.java:72) >>> at >>> org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycleStart.run(CloudStackExtendedLifeCycleStart.java:46) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet$1.with(DefaultModuleDefinitionSet.java:105) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:245) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:250) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:233) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.startContexts(DefaultModuleDefinitionSet.java:97) >>> at >>> org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:80) >>> at >>> org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37) >>> at >>> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.init(CloudStackSpringContext.java:70) >>> at >>> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:57) >>> at >>> org.apache.cloudstack.spring.module.factory.CloudStackSpringContext.<init>(CloudStackSpringContext.java:61) >>> at >>> org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52) >>> at >>> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4210) >>> at >>> org.apache.catalina.core.StandardContext.start(StandardContext.java:4709) >>> at >>> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) >>> at >>> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) >>> at >>> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) >>> at >>> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079) >>> at >>> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002) >>> at >>> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506) >>> at >>> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) >>> at >>> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) >>> at >>> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) >>> at >>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) >>> at >>> org.apache.catalina.core.StandardHost.start(StandardHost.java:822) >>> at >>> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) >>> at >>> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) >>> at >>> org.apache.catalina.core.StandardService.start(StandardService.java:525) >>> at >>> org.apache.catalina.core.StandardServer.start(StandardServer.java:754) >>> at org.apache.catalina.startup.Catalina.start(Catalina.java:595) >>> 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 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.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:243) >>> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >>> Unknown column 'snapshot_policy.display' in 'field list' >>> 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:1054) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) >>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) >>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) >>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) >>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825) >>> at >>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156) >>> at >>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313) >>> at >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) >>> at >>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) >>> at >>> com.cloud.utils.db.GenericDaoBase.executeList(GenericDaoBase.java:1121) >>> ... 61 more >>> >>> >>> It looks like the issue may be a query failure on the snapshot_policy >>> table. Any ideas? >>> >>> >>> Thanks, >>> >>> >>> >>> Willard Rathjen >>> Cloud Systems Engineer >>> >>> Office +1.800.735.7104 <tel:+1.800.735.7104> | Direct +1.515.612.7813 >>> <tel:+1.515.612.7813> >>> willard.rath...@appcore.com <mailto:willard.rath...@appcore.com> | >>> www.appcore.com <http://www.appcore.com/> >>> >>> ---------------------------------------------------------------------- >>> The information in this message is intended for the named recipients >>> only. It may contain information that is privileged, confidential or >>> otherwise protected from disclosure. If you are not the intended recipient, >>> you are hereby notified that any disclosure, copying, distribution, or the >>> taking of any action in reliance on the contents of this message is >>> strictly prohibited. If you have received this e-mail in error, do not >>> print it or disseminate it or its contents. In such event, please notify >>> the sender by return e-mail and delete the e-mail file immediately >>> thereafter. Thank you. >>> >>> >>> >>> >>
