You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by GitBox <gi...@apache.org> on 2020/02/17 12:23:16 UTC

[GitHub] [cloudstack] borisstoyanov opened a new issue #3891: 4.11.3->4.14 upgrade issue

borisstoyanov opened a new issue #3891: 4.11.3->4.14 upgrade issue
URL: https://github.com/apache/cloudstack/issues/3891
 
 
   <!--
   Verify first that your issue/request is not already reported on GitHub.
   Also test if the latest release and master branch are affected too.
   Always add information AFTER of these HTML comments, but no need to delete the comments.
   -->
   
   ##### ISSUE TYPE
   <!-- Pick one below and delete the rest -->
    * Bug Report
   
   
   ##### COMPONENT NAME
   <!--
   Categorize the issue, e.g. API, VR, VPN, UI, etc.
   -->
   ~~~
   DB Upgrade
   ~~~
   
   ##### CLOUDSTACK VERSION
   <!--
   New line separated list of affected versions, commit ID for issues on master branch.
   -->
   
   ~~~
   
   ~~~
   
   ##### CONFIGURATION
   <!--
   Information about the configuration if relevant, e.g. basic network, advanced networking, etc.  N/A otherwise
   -->
   
   
   ##### OS / ENVIRONMENT
   <!--
   Information about the environment if relevant, N/A otherwise
   -->
   
   
   ##### SUMMARY
   <!-- Explain the problem/feature briefly -->
   The upgrade fails with the following exception
   ```
   2020-02-16 16:46:28,907 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) CREATE TABLE `vpc_offering_details` (   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,   `offering_id` bigint(20) unsigned NOT NULL COMMENT 'vpc offering id',   `name` varchar(255) NOT NULL,   `value` varchar(1024) NOT NULL,   `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the detail can be displayed to the end user',   PRIMARY KEY (`id`),   KEY `fk_vpc_offering_details__vpc_offering_id` (`offering_id`),   CONSTRAINT `fk_vpc_offering_details__vpc_offering_id` FOREIGN KEY (`offering_id`) REFERENCES `vpc_offerings` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
   2020-02-16 16:46:28,918 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: CREATE TABLE `vpc_offering_details` (   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,   `offering_id` bigint(20) unsigned NOT NULL COMMENT 'vpc offering id',   `name` varchar(255) NOT NULL,   `value` varchar(1024) NOT NULL,   `display` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'True if the detail can be displayed to the end user',   PRIMARY KEY (`id`),   KEY `fk_vpc_offering_details__vpc_offering_id` (`offering_id`),   CONSTRAINT `fk_vpc_offering_details__vpc_offering_id` FOREIGN KEY (`offering_id`) REFERENCES `vpc_offerings` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
   2020-02-16 16:46:28,919 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) java.sql.SQLSyntaxErrorException: Table 'vpc_offering_details' already exists
   2020-02-16 16:46:28,919 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute upgrade script
   java.sql.SQLSyntaxErrorException: Table 'vpc_offering_details' already 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:200)
   	at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:255)
   	at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:339)
   	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: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: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.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
   	at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:930)
   	at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:553)
   	at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:889)
   	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:822)
   	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:189)
   	at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:105)
   2020-02-16 16:46:28,921 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:206)
   	at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:255)
   	at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:339)
   	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: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: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.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
   	at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:930)
   	at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:553)
   	at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:889)
   	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:822)
   	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:189)
   	at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:105)
   Caused by: java.sql.SQLSyntaxErrorException: Table 'vpc_offering_details' already 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:200)
   	... 50 more
   2020-02-16 16:46:28,927 DEBUG [c.c.u.d.T.Transaction] (main:null) (logid:) Rolling back the transaction: Time = 319 Name =  Upgrade; called by -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-TransactionLegacy.close:657-DatabaseUpgradeChecker.upgrade:270-DatabaseUpgradeChecker.check:339-CloudStackExtendedLifeCycle.checkIntegrity:65-CloudStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:182-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$LifecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-DefaultLifecycleProcessor.onRefresh:122
   2020-02-16 16:46:28,933 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
   2020-02-16 16:46:28,934 WARN  [o.e.j.w.WebAppContext] (main:null) (logid:) Failed startup of context o.e.j.w.WebAppContext@14bdbc74{/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:185)
   	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: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.CloudStackContextLoaderListener.contextInitialized(CloudStackContextLoaderListener.java:52)
   	at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:930)
   	at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:553)
   	at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:889)
   	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:822)
   	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:189)
   	at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:105)
   Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
   	at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:268)
   	at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:339)
   	at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65)
   	... 47 more
   Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade script
   	at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:206)
   	at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:255)
   	at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:339)
   	... 48 more
   Caused by: java.sql.SQLSyntaxErrorException: Table 'vpc_offering_details' already 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:200)
   	... 50 more
   2020-02-16 16:46:28,942 INFO  [o.e.j.s.h.ContextHandler] (main:null) (logid:) Started o.e.j.s.h.MovedContextHandler@183ec003{/,null,AVAILABLE}
   2020-02-16 16:46:28,960 INFO  [o.e.j.s.AbstractConnector] (main:null) (logid:) Started ServerConnector@759d26fb{HTTP/1.1,[http/1.1]}{0.0.0.0:8080}
   2020-02-16 16:46:28,960 INFO  [o.e.j.s.Server] (main:null) (logid:) Started @5618ms
   ```
   
   <!-- You can also paste gist.github.com links for larger files -->
   
   ##### EXPECTED RESULTS
   <!-- What did you expect to happen when running the steps above? -->
   
   ~~~
   Upgrade to succeed 
   ~~~
   
   ##### ACTUAL RESULTS
   <!-- What actually happened? -->
   
   <!-- Paste verbatim command output between quotes below -->
   ~~~
   Upgrade fails
   ~~~
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [cloudstack] andrijapanicsb edited a comment on issue #3891: Upgrade script - vpc_offering_details add 'if not exist'

Posted by GitBox <gi...@apache.org>.
andrijapanicsb edited a comment on issue #3891: Upgrade script - vpc_offering_details add 'if not exist' 
URL: https://github.com/apache/cloudstack/issues/3891#issuecomment-587882777
 
 
   Not an issue, but I would say an (untested, unpredicateble) expectation that you can run upgrade again after the previous one failed.
   For DB consistency reasons, I vote this problem be closed (and voted -1 on the related PR)

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [cloudstack] andrijapanicsb closed issue #3891: Upgrade script - vpc_offering_details add 'if not exist'

Posted by GitBox <gi...@apache.org>.
andrijapanicsb closed issue #3891: Upgrade script - vpc_offering_details add 'if not exist' 
URL: https://github.com/apache/cloudstack/issues/3891
 
 
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [cloudstack] rhtyd commented on issue #3891: 4.11.3->4.14 upgrade issue

Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #3891: 4.11.3->4.14 upgrade issue
URL: https://github.com/apache/cloudstack/issues/3891#issuecomment-586984791
 
 
   I did a quick check, @borisstoyanov but this table did not exist in 4.11.3; but it is in 4.13 version (in `engine/schema/src/main/resources/META-INF/db/schema-41200to41300.sql:CREATE TABLE `vpc_offering_details` ...`)

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [cloudstack] andrijapanicsb commented on issue #3891: Upgrade script - vpc_offering_details add 'if not exist'

Posted by GitBox <gi...@apache.org>.
andrijapanicsb commented on issue #3891: Upgrade script - vpc_offering_details add 'if not exist' 
URL: https://github.com/apache/cloudstack/issues/3891#issuecomment-587882777
 
 
   Not an issue, but I would say an exectation that you can run upgrade again after the previous one failed.
   For DB consistency reasons, I vote this problem be closed (and voted -1 on the related PR)

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [cloudstack] andrijapanicsb commented on issue #3891: Upgrade script - vpc_offering_details add 'if not exist'

Posted by GitBox <gi...@apache.org>.
andrijapanicsb commented on issue #3891: Upgrade script - vpc_offering_details add 'if not exist' 
URL: https://github.com/apache/cloudstack/issues/3891#issuecomment-587894191
 
 
   Please see my comment on the PR #3892 .
   Closing as non-issue.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services