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
