ok, this is also an upgrade issue. If all is well you installed them first. You must have downloaded the new systemvm templates and installed them as per the upgrade instructions (didn't read them myself this time so i'd have to check) and the upgrade will then mark them as the current templates for systemVMs. This error indicates that something in that process went wrong.
On Fri, Feb 9, 2018 at 10:44 AM, Jevgeni Zolotarjov <j.zolotar...@gmail.com> wrote: > I have a backup and noone is accessing the installation during upgrade > process > > Now: > I moved 1 bit further. > > Now I am having this error > 2018-02-09 09:38:05,475 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > ALTER TABLE cloud.ldap_configuration ADD COLUMN domain_id BIGINT(20) > DEFAULT NULL > 2018-02-09 09:38:05,476 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > ALTER TABLE cloud.ldap_trust_map ADD COLUMN account_id BIGINT(20) DEFAULT 0 > 2018-02-09 09:38:05,478 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > ALTER TABLE cloud.ldap_trust_map DROP FOREIGN KEY > fk_ldap_trust_map__domain_id > 2018-02-09 09:38:05,481 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > DROP INDEX uk_ldap_trust_map__domain_id ON cloud.ldap_trust_map > 2018-02-09 09:38:05,482 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > CREATE UNIQUE INDEX uk_ldap_trust_map__bind_location ON ldap_trust_map > (domain_id, account_id) > 2018-02-09 09:38:05,488 ERROR [c.c.u.PropertiesUtil] (main:null) (logid:) > Unable to find properties file: commands.properties > 2018-02-09 09:38:05,489 DEBUG [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) No commands.properties file was found, enabling dynamic roles by > setting dynamic.apichecker.enabled to true if not already enabled. > 2018-02-09 09:38:05,490 DEBUG [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) Done validating base64 content of user data > 2018-02-09 09:38:05,490 DEBUG [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) Updating System Vm template IDs > 2018-02-09 09:38:05,493 DEBUG [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) Updating LXC System Vms > 2018-02-09 09:38:05,493 WARN [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) 4.11.0.0LXC SystemVm template not found. LXC hypervisor is not > used, so not failing upgrade > 2018-02-09 09:38:05,494 DEBUG [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) Updating Hyperv System Vms > 2018-02-09 09:38:05,495 WARN [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) 4.11.0.0Hyperv SystemVm template not found. Hyperv hypervisor is > not used, so not failing upgrade > 2018-02-09 09:38:05,496 DEBUG [c.c.u.d.Upgrade41000to41100] (main:null) > (logid:) Updating KVM System Vms > 2018-02-09 09:38:05,497 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Unable to upgrade the database > com.cloud.utils.exception.CloudRuntimeException: 4.11.0.0KVM SystemVm > template not found. Cannot upgrade system Vms > at > com.cloud.upgrade.dao.Upgrade41000to41100.updateSystemVmTemplates( > Upgrade41000to41100.java:270) > at > com.cloud.upgrade.dao.Upgrade41000to41100.performDataMigration( > Upgrade41000to41100.java:71) > at > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade( > DatabaseUpgradeChecker.java:561) > 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) > > > > On Fri, Feb 9, 2018 at 11:42 AM, Daan Hoogland <daan.hoogl...@gmail.com> > wrote: > > > 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 > > > -- Daan
