Re: SQL error and "can't upgrade database" when I try to upgrade CS 4.17.1.0 to 4.18.0.0

Fri, 24 Mar 2023 14:21:51 -0700 

Hi,
Please keep an eye on
https://github.com/apache/cloudstack/issues/7358

-Wei


On Friday, 24 March 2023, David Larsen <david.lar...@adcom.no> wrote:

> Hi
>
> Iā€™m running CS 4.17.1.0 on ubuntu 18.04 and MySQL 5.7.41, and tried to
> upgrade to 4.18.0.0
>
> Please see log bellow for details regarding sql error.
>
>
> 2023-03-24 15:07:42,669 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
> CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.vm_template', 'user_data_id',
> 'bigint unsigned DEFAULT NULL COMMENT "id of the us
>        er data"')
> 2023-03-24 15:07:43,075 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
> CALL `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template',
> 'user_data', 'id')
> 2023-03-24 15:07:43,213 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
> Error executing: CALL 
> `cloud`.`IDEMPOTENT_ADD_FOREIGN_KEY`('cloud.vm_template',
> 'user_data', 'id')
> 2023-03-24 15:07:43,214 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
> java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate
> key in table '#sql-500_158'
> 2023-03-24 15:07:43,216 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
> (logid:) Unable to execute upgrade script
> java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate
> key in table '#sql-500_158'
>         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:226)
>         at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(
> DatabaseUpgradeChecker.java:310)
>         at com.cloud.upgrade.DatabaseUpgradeChecker.check(
> DatabaseUpgradeChecker.java:401)
>         at org.apache.cloudstack.spring.lifecycle.
> CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.
> java:64)
>         at org.apache.cloudstack.spring.lifecycle.
> CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> doStart(DefaultLifecycleProcessor.java:178)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> access$200(DefaultLifecycleProcessor.java:54)
>         at org.springframework.context.support.DefaultLifecycleProcessor$
> LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
>         at java.base/java.lang.Iterable.forEach(Iterable.java:75)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> startBeans(DefaultLifecycleProcessor.java:155)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> onRefresh(DefaultLifecycleProcessor.java:123)
>         at org.springframework.context.support.AbstractApplicationContext.
> finishRefresh(AbstractApplicationContext.java:935)
>         at org.springframework.context.support.AbstractApplicationContext.
> refresh(AbstractApplicationContext.java:586)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.
> java:144)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:244)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:249)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:232)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.
> java:116)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78)
>         at org.apache.cloudstack.spring.module.factory.
> ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
>         at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.init(CloudStackSpringContext.java:70)
>         at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:57)
>         at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:61)
>         at org.apache.cloudstack.spring.module.web.
> CloudStackContextLoaderListener.contextInitialized(
> CloudStackContextLoaderListener.java:52)
>         at org.eclipse.jetty.server.handler.ContextHandler.
> callContextInitialized(ContextHandler.java:1073)
>         at org.eclipse.jetty.servlet.ServletContextHandler.
> callContextInitialized(ServletContextHandler.java:572)
>         at org.eclipse.jetty.server.handler.ContextHandler.
> contextInitialized(ContextHandler.java:1002)
>         at org.eclipse.jetty.servlet.ServletHandler.initialize(
> ServletHandler.java:765)
>         at org.eclipse.jetty.servlet.ServletContextHandler.startContext(
> ServletContextHandler.java:379)
>         at org.eclipse.jetty.webapp.WebAppContext.startWebapp(
> WebAppContext.java:1449)
>         at org.eclipse.jetty.webapp.WebAppContext.startContext(
> WebAppContext.java:1414)
>         at org.eclipse.jetty.server.handler.ContextHandler.
> doStart(ContextHandler.java:916)
>         at org.eclipse.jetty.servlet.ServletContextHandler.doStart(
> ServletContextHandler.java:288)
>         at org.eclipse.jetty.webapp.WebAppContext.doStart(
> WebAppContext.java:524)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> start(ContainerLifeCycle.java:169)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> doStart(ContainerLifeCycle.java:110)
>         at org.eclipse.jetty.server.handler.AbstractHandler.
> doStart(AbstractHandler.java:97)
>         at org.eclipse.jetty.server.handler.gzip.GzipHandler.
> doStart(GzipHandler.java:426)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> start(ContainerLifeCycle.java:169)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> doStart(ContainerLifeCycle.java:117)
>         at org.eclipse.jetty.server.handler.AbstractHandler.
> doStart(AbstractHandler.java:97)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> start(ContainerLifeCycle.java:169)
>         at org.eclipse.jetty.server.Server.start(Server.java:423)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> doStart(ContainerLifeCycle.java:110)
>         at org.eclipse.jetty.server.handler.AbstractHandler.
> doStart(AbstractHandler.java:97)
>         at org.eclipse.jetty.server.Server.doStart(Server.java:387)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:192)
>         at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:107)
> 2023-03-24 15:07:43,224 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:232)
>         at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(
> DatabaseUpgradeChecker.java:310)
>         at com.cloud.upgrade.DatabaseUpgradeChecker.check(
> DatabaseUpgradeChecker.java:401)
>         at org.apache.cloudstack.spring.lifecycle.
> CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.
> java:64)
>         at org.apache.cloudstack.spring.lifecycle.
> CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> doStart(DefaultLifecycleProcessor.java:178)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> access$200(DefaultLifecycleProcessor.java:54)
>         at org.springframework.context.support.DefaultLifecycleProcessor$
> LifecycleGroup.start(DefaultLifecycleProcessor.java:356)
>         at java.base/java.lang.Iterable.forEach(Iterable.java:75)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> startBeans(DefaultLifecycleProcessor.java:155)
>         at org.springframework.context.support.DefaultLifecycleProcessor.
> onRefresh(DefaultLifecycleProcessor.java:123)
>         at org.springframework.context.support.AbstractApplicationContext.
> finishRefresh(AbstractApplicationContext.java:935)
>         at org.springframework.context.support.AbstractApplicationContext.
> refresh(AbstractApplicationContext.java:586)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.
> java:144)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet$2.with(DefaultModuleDefinitionSet.java:121)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:244)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:249)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.withModule(DefaultModuleDefinitionSet.java:232)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.loadContexts(DefaultModuleDefinitionSet.
> java:116)
>         at org.apache.cloudstack.spring.module.model.impl.
> DefaultModuleDefinitionSet.load(DefaultModuleDefinitionSet.java:78)
>         at org.apache.cloudstack.spring.module.factory.
> ModuleBasedContextFactory.loadModules(ModuleBasedContextFactory.java:37)
>         at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.init(CloudStackSpringContext.java:70)
>         at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:57)
>         at org.apache.cloudstack.spring.module.factory.
> CloudStackSpringContext.<init>(CloudStackSpringContext.java:61)
>         at org.apache.cloudstack.spring.module.web.
> CloudStackContextLoaderListener.contextInitialized(
> CloudStackContextLoaderListener.java:52)
>         at org.eclipse.jetty.server.handler.ContextHandler.
> callContextInitialized(ContextHandler.java:1073)
>         at org.eclipse.jetty.servlet.ServletContextHandler.
> callContextInitialized(ServletContextHandler.java:572)
>         at org.eclipse.jetty.server.handler.ContextHandler.
> contextInitialized(ContextHandler.java:1002)
>         at org.eclipse.jetty.servlet.ServletHandler.initialize(
> ServletHandler.java:765)
>         at org.eclipse.jetty.servlet.ServletContextHandler.startContext(
> ServletContextHandler.java:379)
>         at org.eclipse.jetty.webapp.WebAppContext.startWebapp(
> WebAppContext.java:1449)
>         at org.eclipse.jetty.webapp.WebAppContext.startContext(
> WebAppContext.java:1414)
>         at org.eclipse.jetty.server.handler.ContextHandler.
> doStart(ContextHandler.java:916)
>         at org.eclipse.jetty.servlet.ServletContextHandler.doStart(
> ServletContextHandler.java:288)
>         at org.eclipse.jetty.webapp.WebAppContext.doStart(
> WebAppContext.java:524)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> start(ContainerLifeCycle.java:169)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> doStart(ContainerLifeCycle.java:110)
>         at org.eclipse.jetty.server.handler.AbstractHandler.
> doStart(AbstractHandler.java:97)
>         at org.eclipse.jetty.server.handler.gzip.GzipHandler.
> doStart(GzipHandler.java:426)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> start(ContainerLifeCycle.java:169)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> doStart(ContainerLifeCycle.java:117)
>         at org.eclipse.jetty.server.handler.AbstractHandler.
> doStart(AbstractHandler.java:97)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> start(ContainerLifeCycle.java:169)
>         at org.eclipse.jetty.server.Server.start(Server.java:423)
>         at org.eclipse.jetty.util.component.ContainerLifeCycle.
> doStart(ContainerLifeCycle.java:110)
>         at org.eclipse.jetty.server.handler.AbstractHandler.
> doStart(AbstractHandler.java:97)
>         at org.eclipse.jetty.server.Server.doStart(Server.java:387)
>         at org.eclipse.jetty.util.component.AbstractLifeCycle.
> start(AbstractLifeCycle.java:73)
>         at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:192)
>         at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:107)
> Caused by: java.sql.SQLIntegrityConstraintViolationException: Can't
> write; duplicate key in table '#sql-500_158'
>         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:226)
>         ... 52 more
> 2023-03-24 15:07:43,253 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:)
> Rolling back the transaction:
>
>
> Thanks šŸ˜Š
>
> -David
>
>
>
> -
>
>

Reply via email to