Hi all
Have anyone such problems while updating?
----------------------
2021-01-17 01:42:47,466 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:)
ALTER TABLE `cloud`.`project_account` ADD COLUMN `user_id` bigint unsigned
COMMENT 'ID of user to be added to the project' AFTER `account_id`, ADD
CONSTRAINT `fk_project_account__user_id` FOREIGN KEY
`fk_project_account__user_id`(`user_id`) REFERENCES `user`(`id`) ON DELETE
CASCADE, ADD COLUMN `project_role_id` bigint unsigned COMMENT 'Project
role id' AFTER `project_account_id`, ADD CONSTRAINT
`fk_project_account__project_role_id` FOREIGN KEY (`project_role_id`)
REFERENCES `project_role` (`id`) ON DELETE SET NULL, DROP FOREIGN KEY
`fk_project_account__account_id`, DROP INDEX `account_id`
2021-01-17 01:42:47,480 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: ALTER TABLE `cloud`.`project_account` ADD COLUMN
`user_id` bigint unsigned COMMENT 'ID of user to be added to the project'
AFTER `account_id`, ADD CONSTRAINT `fk_project_account__user_id` FOREIGN
KEY `fk_project_account__user_id`(`user_id`) REFERENCES `user`(`id`) ON
DELETE CASCADE, ADD COLUMN `project_role_id` bigint unsigned COMMENT
'Project role id' AFTER `project_account_id`, ADD CONSTRAINT
`fk_project_account__project_role_id` FOREIGN KEY (`project_role_id`)
REFERENCES `project_role` (`id`) ON DELETE SET NULL, DROP FOREIGN KEY
`fk_project_account__account_id`, DROP INDEX `account_id`
2021-01-17 01:42:47,480 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
java.sql.SQLSyntaxErrorException: Can't DROP 'fk_project_account__account_id';
check that column/key exists
2021-01-17 01:42:47,483 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null)
(logid:) Unable to execute upgrade script
java.sql.SQLSyntaxErrorException: Can't DROP 'fk_project_account__account_id';
check that column/key exists
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:203)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(
DatabaseUpgradeChecker.java:258)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(
DatabaseUpgradeChecker.java:342)
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:182)
at org.springframework.context.support.DefaultLifecycleProcessor.
access$200(DefaultLifecycleProcessor.java:53)
at org.springframework.context.support.DefaultLifecycleProcessor$
LifecycleGroup.start(DefaultLifecycleProcessor.java:360)
at org.springframework.context.support.DefaultLifecycleProcessor.
startBeans(DefaultLifecycleProcessor.java:158)
at org.springframework.context.support.DefaultLifecycleProcessor.
onRefresh(DefaultLifecycleProcessor.java:122)
at org.springframework.context.support.AbstractApplicationContext.
finishRefresh(AbstractApplicationContext.java:894)
at org.springframework.context.support.AbstractApplicationContext.
refresh(AbstractApplicationContext.java:553)
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:51)
at org.eclipse.jetty.server.handler.ContextHandler.
callContextInitialized(ContextHandler.java:933)
at org.eclipse.jetty.servlet.ServletContextHandler.
callContextInitialized(ServletContextHandler.java:553)
at org.eclipse.jetty.server.handler.ContextHandler.
startContext(ContextHandler.java:892)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(
ServletContextHandler.java:356)
at org.eclipse.jetty.webapp.WebAppContext.startWebapp(
WebAppContext.java:1445)
at org.eclipse.jetty.webapp.WebAppContext.startContext(
WebAppContext.java:1409)
at org.eclipse.jetty.server.handler.ContextHandler.
doStart(ContextHandler.java:825)
at org.eclipse.jetty.servlet.ServletContextHandler.doStart(
ServletContextHandler.java:275)
at org.eclipse.jetty.webapp.WebAppContext.doStart(
WebAppContext.java:524)
at org.eclipse.jetty.util.component.AbstractLifeCycle.
start(AbstractLifeCycle.java:72)
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:425)
at org.eclipse.jetty.util.component.AbstractLifeCycle.
start(AbstractLifeCycle.java:72)
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:72)
at org.eclipse.jetty.util.component.ContainerLifeCycle.
start(ContainerLifeCycle.java:169)
at org.eclipse.jetty.server.Server.start(Server.java:407)
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:371)
at org.eclipse.jetty.util.component.AbstractLifeCycle.
start(AbstractLifeCycle.java:72)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:188)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:104)
2021-01-17 01:42:47,485 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:209)
at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(
DatabaseUpgradeChecker.java:258)
at com.cloud.upgrade.DatabaseUpgradeChecker.check(
DatabaseUpgradeChecker.java:342)
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:182)
at org.springframework.context.support.DefaultLifecycleProcessor.
access$200(DefaultLifecycleProcessor.java:53)
at org.springframework.context.support.DefaultLifecycleProcessor$
LifecycleGroup.start(DefaultLifecycleProcessor.java:360)
at org.springframework.context.support.DefaultLifecycleProcessor.
startBeans(DefaultLifecycleProcessor.java:158)
at org.springframework.context.support.DefaultLifecycleProcessor.
onRefresh(DefaultLifecycleProcessor.java:122)
at org.springframework.context.support.AbstractApplicationContext.
finishRefresh(AbstractApplicationContext.java:894)
at org.springframework.context.support.AbstractApplicationContext.
refresh(AbstractApplicationContext.java:553)
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:51)
at org.eclipse.jetty.server.handler.ContextHandler.
callContextInitialized(ContextHandler.java:933)
at org.eclipse.jetty.servlet.ServletContextHandler.
callContextInitialized(ServletContextHandler.java:553)
at org.eclipse.jetty.server.handler.ContextHandler.
startContext(ContextHandler.java:892)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(
ServletContextHandler.java:356)
at org.eclipse.jetty.webapp.WebAppContext.startWebapp(
WebAppContext.java:1445)
at org.eclipse.jetty.webapp.WebAppContext.startContext(
WebAppContext.java:1409)
at org.eclipse.jetty.server.handler.ContextHandler.
doStart(ContextHandler.java:825)
at org.eclipse.jetty.servlet.ServletContextHandler.doStart(
ServletContextHandler.java:275)
at org.eclipse.jetty.webapp.WebAppContext.doStart(
WebAppContext.java:524)
at org.eclipse.jetty.util.component.AbstractLifeCycle.
start(AbstractLifeCycle.java:72)
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:425)
at org.eclipse.jetty.util.component.AbstractLifeCycle.
start(AbstractLifeCycle.java:72)
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:72)
at org.eclipse.jetty.util.component.ContainerLifeCycle.
start(ContainerLifeCycle.java:169)
at org.eclipse.jetty.server.Server.start(Server.java:407)
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:371)
at org.eclipse.jetty.util.component.AbstractLifeCycle.
start(AbstractLifeCycle.java:72)
at org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:188)
at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:104)
Caused by: java.sql.SQLSyntaxErrorException: Can't DROP
'fk_project_account__account_id'; check that column/key exists
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:203)
... 50 more
2021-01-17 01:42:47,498 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:)
Rolling back the transaction: Time = 27 Name = Upgrade; called by
-TransactionLegacy.rollback:888-TransactionLegacy.removeUpTo:831-
TransactionLegacy.close:655-DatabaseUpgradeChecker.upgrade:273-
DatabaseUpgradeChecker.check:342-CloudStackExtendedLifeCycle.
checkIntegrity:64-CloudStackExtendedLifeCycle.start:54-
DefaultLifecycleProcessor.doStart:182-DefaultLifecycleProcessor.
access$200:53-DefaultLifecycleProcessor$LifecycleGroup.start:360-
DefaultLifecycleProcessor.startBeans:158-DefaultLifecycleProcessor.
onRefresh:122
----------------------
THank's
