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