*FYI:* The solution was a simple one! After setting up
cloudstack-management (/cloudstack-setup-databases &&
usr/bin/cloudstack-setup-management): I simply watched the manager's log
file /var/log/cloudstack/management/management-server.log and waited for
cloudstack-management to stop spewing log messages about "upgrading the
database".
After that: I was able to access the UI and begin configuring CloudStack!
HTH,
Eric P.
Portland, Oregon
On Fri, Jun 5, 2020 at 3:49 AM Paul Angus <paul.an...@shapeblue.com> wrote:
> 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.an...@shapeblue.com
> www.shapeblue.com
> 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
> @shapeblue
>
>
>
>
> -----Original Message-----
> From: Practical XenServer <practicalxenser...@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 <
> practicalxenser...@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
> >
>
