Hi Eric,
This sounds like you had a failed install/upgrade and then tried again. The second time,
CloudStack came to adding a column ('size'), but found that it was already there and stopped.
paul.angus@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
-----Original Message-----
From: Practical XenServer <practicalxenserver@gmail.com>
Sent: 05 June 2020 05:43
To: users@cloudstack.apache.org
Subject: Re: cloudstack-management fails: com.cloud.utils.exception.CloudRuntimeException:
Unable to upgrade the database
*In one about "Unable to upgrade the database" message on the list*:
Someone else had inquired about whether or not mysql-connector-python had been installed.
I found that it was installed as a dependency while installing the cloudstack-management package...
[root@san-1 ~]# yum list installed | grep 'cloud\|mysql'
cloudstack-common.x86_64 4.14.0.0-1.el7
@cloudstack
cloudstack-management.x86_64 4.14.0.0-1.el7
@cloudstack
mysql-connector-python.x86_64 8.0.20-1.el7
@mysql-connectors-community
mysql-connector-python-cext.x86_64 8.0.20-1.el7 @mysql-connectors-community
mysql80-community-release.noarch el7-3
installed
*In another message about "*Unable to upgrade the database*" on the list*:
One person recommended completely removing the database and creating it anew.
So I dropped the CloudStack database and re-created it using the /usr/bin/cloudstack-setup-databases
tool:
/usr/bin/cloudstack-setup-databases cloudstack:#########@localhost --deploy-as=root:#########
And, *at least initially*, this seems to have repaired the situation.
I will update the list with my efforts to add a host *once I'm able to install/configure an
agent reliably*.
Eric P.
Portland, Oregon
On Fri, Jun 5, 2020 at 5:05 AM Practical XenServer < practicalxenserver@gmail.com> wrote:
> After successfully installing and starting Version 4.14 of the
> Management server on a *fresh* installation of CentOS-7: The
> management server halts after accessing the WWW interface for the first time...
>
> 2020-06-05 03:30:20,067 ERROR [c.c.u.d.ScriptRunner] (main:null)
> (logid:) Error executing: alter table vm_template add size bigint
> unsigned
> 2020-06-05 03:30:20,068 ERROR [c.c.u.d.ScriptRunner] (main:null)
> (logid:)
> java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> 2020-06-05 03:30:20,070 ERROR [c.c.u.DatabaseUpgradeChecker]
> (main:null)
> (logid:) Unable to execute upgrade script
> java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> ...SNIP...
> Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> ...SNIP...
> ... 50 more
> 2020-06-05 03:30:20,099 DEBUG [c.c.u.d.T.Transaction] (main:null)
> (logid:) Rolling back the transaction: Time = 35 Name = Upgrade;
> called by
> -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-Trans
> actionLegacy.close:657-DatabaseUpgradeChecker.upgrade:271-DatabaseUpgr
> adeChecker.check:340-CloudStackExtendedLifeCycle.checkIntegrity:65-Clo
> udStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:18
> 2-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$Li
> fecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-Defaul
> tLifecycleProcessor.onRefresh:122
> 2020-06-05 03:30:20,100 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-06-05 03:30:20,102 WARN [o.e.j.w.WebAppContext] (main:null)
> (logid:) Failed startup of context o.e.j.w.WebAppContext@d23e042
> {/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 ...SNIP...
> Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> ...SNIP...
> ... 50 more
> 2020-06-05 03:30:20,099 DEBUG [c.c.u.d.T.Transaction] (main:null)
> (logid:) Rolling back the transaction: Time = 35 Name = Upgrade;
> called by
> -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-Trans
> actionLegacy.close:657-DatabaseUpgradeChecker.upgrade:271-DatabaseUpgr
> adeChecker.check:340-CloudStackExtendedLifeCycle.checkIntegrity:65-Clo
> udStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:18
> 2-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$Li
> fecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-Defaul
> tLifecycleProcessor.onRefresh:122
> 2020-06-05 03:30:20,100 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-06-05 03:30:20,102 WARN [o.e.j.w.WebAppContext] (main:null)
> (logid:) Failed startup of context o.e.j.w.WebAppContext@d23e042
> {/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
>
> Restarting the service causes *slightly* different error messages in
> /var/log/cloudstack/management/management-server.log but they're still
> pretty much the same as the previous (i.e., "Unable to upgrade the
> database"):
>
> 2020-06-05 03:44:44,641 ERROR [c.c.u.d.ScriptRunner] (main:null)
> (logid:) Error executing: alter table vm_template add size bigint
> unsigned
> 2020-06-05 03:44:44,642 ERROR [c.c.u.d.ScriptRunner] (main:null)
> (logid:)
> java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> 2020-06-05 03:44:44,643 ERROR [c.c.u.DatabaseUpgradeChecker]
> (main:null)
> (logid:) Unable to execute upgrade script
> java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> ...SNIP...
> 2020-06-05 03:44:44,655 ERROR [c.c.u.DatabaseUpgradeChecker]
> (main:null)
> (logid:) Unable to upgrade the database
> com.cloud.utils.exception.CloudRuntimeException: Unable to execute
> upgrade script ...SNIP...
> Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> ...SNIP...
> ... 50 more
> 2020-06-05 03:44:44,669 DEBUG [c.c.u.d.T.Transaction] (main:null)
> (logid:) Rolling back the transaction: Time = 34 Name = Upgrade;
> called by
> -TransactionLegacy.rollback:890-TransactionLegacy.removeUpTo:833-Trans
> actionLegacy.close:657-DatabaseUpgradeChecker.upgrade:271-DatabaseUpgr
> adeChecker.check:340-CloudStackExtendedLifeCycle.checkIntegrity:65-Clo
> udStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:18
> 2-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$Li
> fecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-Defaul
> tLifecycleProcessor.onRefresh:122
> 2020-06-05 03:44:44,672 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-06-05 03:44:44,674 WARN [o.e.j.w.WebAppContext] (main:null)
> (logid:) Failed startup of context o.e.j.w.WebAppContext@d23e042
> {/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 ...SNIP...
> Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
> upgrade the database ...SNIP...
> ... 47 more
> Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to
> execute upgrade script ...SNIP...
> ... 48 more
> Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name 'size'
> ...SNIP...
> ... 50 more
> 2020-06-05 03:44:44,676 INFO [o.e.j.s.h.ContextHandler] (main:null)
> (logid:) Started
> o.e.j.s.h.MovedContextHandler@7ce69770{/,null,AVAILABLE}
> 2020-06-05 03:44:44,693 INFO [o.e.j.s.AbstractConnector] (main:null)
> (logid:) Started ServerConnector@7ea9e1e2{HTTP/1.1,[http/1.1]}{
> 0.0.0.0:8080}
> 2020-06-05 03:44:44,694 INFO [o.e.j.s.Server] (main:null) (logid:)
> Started @6322ms
>
> Meanwhile: The WWW interface has gone from the CloudStack Sign-in Page
> to...
> HTTP ERROR 503 Service Unavailable
> URI: /client/
> STATUS: 503
> MESSAGE: Service Unavailable
> SERVLET: -
>
> *Using a script:* I've re-installed CentOS twice - *for a total of
> three
> attempts* - and gotten the same result.
>
> What might be causing this?
>
> TIA,
> Eric Pretorious
> Portland, Oregon
>
|