xuanyuanaosheng commented on issue #7358: URL: https://github.com/apache/cloudstack/issues/7358#issuecomment-1611072037
> > > Can you take a look in /var/log/cloudstack/management/management-server.log and /var/log/cloudstack/management/access.log? > > > Look for errors and exceptions being thrown. > > > > > > Just for FYI this is the error on MySQL 5.7.1 > > ``` > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) init = null > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 4.17.2.0 Code Version = 4.18.0.0 > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed from 4.17.2.0 to 4.18.0.0 > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: ALTER TABLE `cloud`.`networks` ADD COLUMN `public_mtu` bigint unsigned comment "MTU for VR public interface" > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu' > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute upgrade script > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu' > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:226) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:310) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:64) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:54) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:178) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:54) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:356) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at java.base/java.lang.Iterable.forEach(Iterable.java:75) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:155) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:123) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:935) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586) > > Mar 24 12:11:54 mgmt1.svr.co java[2802]: at org.apache.cloudstack.spring.module.model.impl.DefaultModuleDefinitionSet.loadContext(DefaultModuleDefinitionSet.java:144) > > ``` > > > > > > > > > > > > > > > > > > > > > > > > Let me downgrade to 5.5 and retry > > Just to update, the error is triggered in the last step when setting up the management server, i.e. when one runs the `cloudstack-setup-management` command > > If you failed to upgrade, some tables have already been changed, so you need to roll back to your database backup/snapshot before retry. If the database has no backup, how to fix this issue ? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
