before you continue Jevgeni, Do you have a good backup and is no-one able to access this installation with UI or API, when you roll back?
On Fri, Feb 9, 2018 at 10:15 AM, Ernie Janse van Rensburg < ernie.jvrensb...@shapeblue.com> wrote: > engine/schema/resources/META-INF/db/schema-41000to41100.sql: > > ________________________________ > From: Jevgeni Zolotarjov <j.zolotar...@gmail.com> > Sent: Friday, February 9, 2018 10:59:27 AM > To: users@cloudstack.apache.org > Subject: Re: cloudstack-management fails to start after upgrade 4.10 -> > 4.11 > > I dropped the column. But then another error like this appeared > > Please advise, where are the DB update script located? so I can manually > inspect that. > > On Fri, Feb 9, 2018 at 10:29 AM, Ernie Janse van Rensburg < > ernie.jvrensb...@shapeblue.com> wrote: > > > Hi Jevgeni > > > > > > It looks like there was a database error during the upgrade process. > > > > > > A SQL script that is trying to add a column 'for_vpc' to the TABLE > > 'cloud.network_offerings' but the column already exists, for some reason, > > so it fails because mysql does not allow 2 columns with the same name in > > the same table. > > > > > > The column might have already existed from a previous upgrade or from > > running the 4.11 upgrade more than once, and perhaps the SQL script is > not > > idempotent. > > > > > > I suggest to manually drop the column on the table and run the 4.11 > > upgrade process again. > > > > > > Regards > > > > > > Ernie > > > > ________________________________ > > From: Jevgeni Zolotarjov <j.zolotar...@gmail.com> > > Sent: Friday, February 9, 2018 10:10:59 AM > > To: users@cloudstack.apache.org > > Subject: cloudstack-management fails to start after upgrade 4.10 -> 4.11 > > > > cloudstack-management fails to start after upgrade from 4.10 to 4.11 > > > > management-server.log: > > 2018-02-09 07:49:50,842 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) > > (logid:) Running upgrade Upgrade41000to41100 to upgrade from > > 4.10.0.0-4.11.0.0 to 4.11.0.0 > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- Licensed to the Apache Software Foundation (ASF) under one > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- or more contributor license agreements. See the NOTICE file > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- distributed with this work for additional information > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- regarding copyright ownership. The ASF licenses this file > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- to you under the Apache License, Version 2.0 (the > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- "License"); you may not use this file except in compliance > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- with the License. You may obtain a copy of the License at > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- http://www.apache.org/licenses/LICENSE-2.0 > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- Unless required by applicable law or agreed to in writing, > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- software distributed under the License is distributed on an > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- KIND, either express or implied. See the License for the > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- specific language governing permissions and limitations > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- under the License. > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > --; > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- Schema upgrade from 4.10.0.0 to 4.11.0.0 > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > --; > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > -- Add For VPC flag > > 2018-02-09 07:49:50,846 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > > ALTER TABLE cloud.network_offerings ADD COLUMN for_vpc INT(1) NOT NULL > > DEFAULT 0 > > 2018-02-09 07:49:50,847 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > > Error executing: ALTER TABLE cloud.network_offerings ADD COLUMN for_vpc > > INT(1) NOT NULL DEFAULT 0 > > 2018-02-09 07:49:50,848 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate > > column > > name 'for_vpc' > > 2018-02-09 07:49:50,849 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) > > (logid:) Unable to execute upgrade script > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate > > column > > name 'for_vpc' > > at com.cloud.utils.db.ScriptRunner.runScript( > > ScriptRunner.java:185) > > at com.cloud.utils.db.ScriptRunner.runScript( > ScriptRunner.java:87) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript( > > DatabaseUpgradeChecker.java:459) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade( > > DatabaseUpgradeChecker.java:557) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check( > > DatabaseUpgradeChecker.java:641) > > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle. > > checkIntegrity(CloudStackExtendedLifeCycle.java:65) > > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle. > start( > > CloudStackExtendedLifeCycle.java:55) > > at > > org.springframework.context.support.DefaultLifecycleProcessor.doStart( > > DefaultLifecycleProcessor.java:183) > > at > > org.springframework.context.support.DefaultLifecycleProcessor. > access$200( > > DefaultLifecycleProcessor.java:52) > > at > > org.springframework.context.support.DefaultLifecycleProcessor$ > > LifecycleGroup.start(DefaultLifecycleProcessor.java:358) > > at > > org.springframework.context.support.DefaultLifecycleProcessor. > startBeans( > > DefaultLifecycleProcessor.java:159) > > at > > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh( > > DefaultLifecycleProcessor.java:123) > > at > > org.springframework.context.support.AbstractApplicationContext. > > finishRefresh(AbstractApplicationContext.java:884) > > at > > org.springframework.context.support.AbstractApplicationContext.refresh( > > AbstractApplicationContext.java:552) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > loadContext(DefaultModuleDefinitionSet.java:145) > > at > > org.apache.cloudstack.spring.module.model.impl. > > DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122) > > 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:233) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > loadContexts(DefaultModuleDefinitionSet.java:117) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > load(DefaultModuleDefinitionSet.java:79) > > at > > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory. > > loadModules(ModuleBasedContextFactory.java:37) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.init( > > CloudStackSpringContext.java:71) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.<init> > > (CloudStackSpringContext.java:58) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.<init> > > (CloudStackSpringContext.java:62) > > at > > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListene > > r.contextInitialized(CloudStackContextLoaderListener.java:52) > > at > > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized( > > ContextHandler.java:890) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized( > > ServletContextHandler.java:532) > > at > > org.eclipse.jetty.server.handler.ContextHandler. > > startContext(ContextHandler.java:853) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.startContext( > > ServletContextHandler.java:344) > > at > > org.eclipse.jetty.webapp.WebAppContext.startWebapp( > > WebAppContext.java:1515) > > at > > org.eclipse.jetty.webapp.WebAppContext.startContext( > > WebAppContext.java:1477) > > at > > org.eclipse.jetty.server.handler.ContextHandler. > > doStart(ContextHandler.java:785) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.doStart( > > ServletContextHandler.java:261) > > at > > org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:107) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at > > org.eclipse.jetty.server.handler.gzip.GzipHandler. > > doStart(GzipHandler.java:273) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:115) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at org.eclipse.jetty.server.Server.start(Server.java:418) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:107) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at org.eclipse.jetty.server.Server.doStart(Server.java:385) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at org.apache.cloudstack.ServerDaemon.start( > ServerDaemon.java:200) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java: > > 62) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke( > > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at > > org.apache.commons.daemon.support.DaemonLoader.start( > > DaemonLoader.java:241) > > 2018-02-09 07:49:50,851 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) > > (logid:) Unable to upgrade the database > > com.cloud.utils.exception.CloudRuntimeException: Unable to execute > upgrade > > script > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript( > > DatabaseUpgradeChecker.java:465) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade( > > DatabaseUpgradeChecker.java:557) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check( > > DatabaseUpgradeChecker.java:641) > > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle. > > checkIntegrity(CloudStackExtendedLifeCycle.java:65) > > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle. > start( > > CloudStackExtendedLifeCycle.java:55) > > at > > org.springframework.context.support.DefaultLifecycleProcessor.doStart( > > DefaultLifecycleProcessor.java:183) > > at > > org.springframework.context.support.DefaultLifecycleProcessor. > access$200( > > DefaultLifecycleProcessor.java:52) > > at > > org.springframework.context.support.DefaultLifecycleProcessor$ > > LifecycleGroup.start(DefaultLifecycleProcessor.java:358) > > at > > org.springframework.context.support.DefaultLifecycleProcessor. > startBeans( > > DefaultLifecycleProcessor.java:159) > > at > > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh( > > DefaultLifecycleProcessor.java:123) > > at > > org.springframework.context.support.AbstractApplicationContext. > > finishRefresh(AbstractApplicationContext.java:884) > > at > > org.springframework.context.support.AbstractApplicationContext.refresh( > > AbstractApplicationContext.java:552) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > loadContext(DefaultModuleDefinitionSet.java:145) > > at > > org.apache.cloudstack.spring.module.model.impl. > > DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122) > > 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:233) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > loadContexts(DefaultModuleDefinitionSet.java:117) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > load(DefaultModuleDefinitionSet.java:79) > > at > > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory. > > loadModules(ModuleBasedContextFactory.java:37) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.init( > > CloudStackSpringContext.java:71) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.<init> > > (CloudStackSpringContext.java:58) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.<init> > > (CloudStackSpringContext.java:62) > > at > > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListene > > r.contextInitialized(CloudStackContextLoaderListener.java:52) > > at > > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized( > > ContextHandler.java:890) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized( > > ServletContextHandler.java:532) > > at > > org.eclipse.jetty.server.handler.ContextHandler. > > startContext(ContextHandler.java:853) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.startContext( > > ServletContextHandler.java:344) > > at > > org.eclipse.jetty.webapp.WebAppContext.startWebapp( > > WebAppContext.java:1515) > > at > > org.eclipse.jetty.webapp.WebAppContext.startContext( > > WebAppContext.java:1477) > > at > > org.eclipse.jetty.server.handler.ContextHandler. > > doStart(ContextHandler.java:785) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.doStart( > > ServletContextHandler.java:261) > > at > > org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:107) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at > > org.eclipse.jetty.server.handler.gzip.GzipHandler. > > doStart(GzipHandler.java:273) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:115) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at org.eclipse.jetty.server.Server.start(Server.java:418) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:107) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at org.eclipse.jetty.server.Server.doStart(Server.java:385) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at org.apache.cloudstack.ServerDaemon.start( > ServerDaemon.java:200) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java: > > 62) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke( > > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at > > org.apache.commons.daemon.support.DaemonLoader.start( > > DaemonLoader.java:241) > > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > > Duplicate column name 'for_vpc' > > at com.cloud.utils.db.ScriptRunner.runScript( > > ScriptRunner.java:185) > > at com.cloud.utils.db.ScriptRunner.runScript( > ScriptRunner.java:87) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript( > > DatabaseUpgradeChecker.java:459) > > ... 54 more > > 2018-02-09 07:49:50,853 DEBUG [c.c.u.d.T.Transaction] (main:null) > (logid:) > > Rolling back the transaction: Time = 10 Name = Upgrade; called by > > -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832- > > TransactionLegacy.close:656-DatabaseUpgradeChecker.upgrade:572- > > DatabaseUpgradeChecker.check:641-CloudStackExtendedLifeCycle. > > checkIntegrity:65-CloudStackExtendedLifeCycle.start:55- > > DefaultLifecycleProcessor.doStart:183-DefaultLifecycleProcessor. > > access$200:52-DefaultLifecycleProcessor$LifecycleGroup.start:358- > > DefaultLifecycleProcessor.startBeans:159-DefaultLifecycleProcessor. > > onRefresh:123 > > 2018-02-09 07:49:50,854 WARN [o.a.c.s.m.c.ResourceApplicationContext] > > (main:null) (logid:) Exception encountered during context initialization > - > > cancelling refresh attempt: > > org.springframework.context.ApplicationContextException: Failed to start > > bean 'cloudStackLifeCycle'; nested exception is > > com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the > > database > > 2018-02-09 07:49:50,855 WARN [o.e.j.w.WebAppContext] (main:null) > (logid:) > > Failed startup of context o.e.j.w.WebAppContext@49c43f4e > > {/client,file:///usr/share/cloudstack-management/webapp/, > > UNAVAILABLE}{/usr/share/cloudstack-management/webapp} > > org.springframework.context.ApplicationContextException: Failed to start > > bean 'cloudStackLifeCycle'; nested exception is > > com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the > > database > > at > > org.springframework.context.support.DefaultLifecycleProcessor.doStart( > > DefaultLifecycleProcessor.java:186) > > at > > org.springframework.context.support.DefaultLifecycleProcessor. > access$200( > > DefaultLifecycleProcessor.java:52) > > at > > org.springframework.context.support.DefaultLifecycleProcessor$ > > LifecycleGroup.start(DefaultLifecycleProcessor.java:358) > > at > > org.springframework.context.support.DefaultLifecycleProcessor. > startBeans( > > DefaultLifecycleProcessor.java:159) > > at > > org.springframework.context.support.DefaultLifecycleProcessor.onRefresh( > > DefaultLifecycleProcessor.java:123) > > at > > org.springframework.context.support.AbstractApplicationContext. > > finishRefresh(AbstractApplicationContext.java:884) > > at > > org.springframework.context.support.AbstractApplicationContext.refresh( > > AbstractApplicationContext.java:552) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > loadContext(DefaultModuleDefinitionSet.java:145) > > at > > org.apache.cloudstack.spring.module.model.impl. > > DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:122) > > 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:233) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > loadContexts(DefaultModuleDefinitionSet.java:117) > > at > > org.apache.cloudstack.spring.module.model.impl. > DefaultModuleDefinitionSet. > > load(DefaultModuleDefinitionSet.java:79) > > at > > org.apache.cloudstack.spring.module.factory.ModuleBasedContextFactory. > > loadModules(ModuleBasedContextFactory.java:37) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.init( > > CloudStackSpringContext.java:71) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.<init> > > (CloudStackSpringContext.java:58) > > at > > org.apache.cloudstack.spring.module.factory. > CloudStackSpringContext.<init> > > (CloudStackSpringContext.java:62) > > at > > org.apache.cloudstack.spring.module.web.CloudStackContextLoaderListene > > r.contextInitialized(CloudStackContextLoaderListener.java:52) > > at > > org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized( > > ContextHandler.java:890) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized( > > ServletContextHandler.java:532) > > at > > org.eclipse.jetty.server.handler.ContextHandler. > > startContext(ContextHandler.java:853) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.startContext( > > ServletContextHandler.java:344) > > at > > org.eclipse.jetty.webapp.WebAppContext.startWebapp( > > WebAppContext.java:1515) > > at > > org.eclipse.jetty.webapp.WebAppContext.startContext( > > WebAppContext.java:1477) > > at > > org.eclipse.jetty.server.handler.ContextHandler. > > doStart(ContextHandler.java:785) > > at > > org.eclipse.jetty.servlet.ServletContextHandler.doStart( > > ServletContextHandler.java:261) > > at > > org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:545) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:107) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at > > org.eclipse.jetty.server.handler.gzip.GzipHandler. > > doStart(GzipHandler.java:273) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:115) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > start(ContainerLifeCycle.java:133) > > at org.eclipse.jetty.server.Server.start(Server.java:418) > > at > > org.eclipse.jetty.util.component.ContainerLifeCycle. > > doStart(ContainerLifeCycle.java:107) > > at > > org.eclipse.jetty.server.handler.AbstractHandler. > > doStart(AbstractHandler.java:113) > > at org.eclipse.jetty.server.Server.doStart(Server.java:385) > > at > > org.eclipse.jetty.util.component.AbstractLifeCycle. > > start(AbstractLifeCycle.java:68) > > at org.apache.cloudstack.ServerDaemon.start( > ServerDaemon.java:200) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java: > > 62) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke( > > DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:498) > > at > > org.apache.commons.daemon.support.DaemonLoader.start( > > DaemonLoader.java:241) > > Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to > > upgrade the database > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade( > > DatabaseUpgradeChecker.java:570) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check( > > DatabaseUpgradeChecker.java:641) > > at > > org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle. > > checkIntegrity(CloudStackExtendedLifeCycle.java:65) > > ... 51 more > > Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to > > execute upgrade script > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript( > > DatabaseUpgradeChecker.java:465) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade( > > DatabaseUpgradeChecker.java:557) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.check( > > DatabaseUpgradeChecker.java:641) > > ... 52 more > > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > > Duplicate column name 'for_vpc' > > at com.cloud.utils.db.ScriptRunner.runScript( > > ScriptRunner.java:185) > > at com.cloud.utils.db.ScriptRunner.runScript( > ScriptRunner.java:87) > > at > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript( > > DatabaseUpgradeChecker.java:459) > > ... 54 more > > > > > > > > > > Please help! > > > > ernie.jvrensb...@shapeblue.com > > www.shapeblue.com<http://www.shapeblue.com> > > , > > @shapeblue > > > > > > > > > > ernie.jvrensb...@shapeblue.com > www.shapeblue.com > , > @shapeblue > > > > -- Daan
