*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-TransactionLegacy.close:657-DatabaseUpgradeChecker.upgrade:271-DatabaseUpgradeChecker.check:340-CloudStackExtendedLifeCycle.checkIntegrity:65-CloudStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:182-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$LifecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-DefaultLifecycleProcessor.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-TransactionLegacy.close:657-DatabaseUpgradeChecker.upgrade:271-DatabaseUpgradeChecker.check:340-CloudStackExtendedLifeCycle.checkIntegrity:65-CloudStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:182-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$LifecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-DefaultLifecycleProcessor.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-TransactionLegacy.close:657-DatabaseUpgradeChecker.upgrade:271-DatabaseUpgradeChecker.check:340-CloudStackExtendedLifeCycle.checkIntegrity:65-CloudStackExtendedLifeCycle.start:55-DefaultLifecycleProcessor.doStart:182-DefaultLifecycleProcessor.access$200:53-DefaultLifecycleProcessor$LifecycleGroup.start:360-DefaultLifecycleProcessor.startBeans:158-DefaultLifecycleProcessor.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
>
