cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Angus <paul.an...@shapeblue.com>
Subject RE: cloudstack-management fails: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
Date Fri, 05 Jun 2020 10:49:01 GMT
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
>
Mime
View raw message