my host in Centos7. I upgraded just by changing the URL in repository and yum update
How do I upgrade systemvm templates now? On Fri, Feb 9, 2018 at 11:49 AM, Daan Hoogland <daan.hoogl...@gmail.com> wrote: > 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 >
