mail2lawi commented on issue #7358: URL: https://github.com/apache/cloudstack/issues/7358#issuecomment-1483085144
> 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 -- 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]
