Hi experts
I was trying to upgrade cloudstack 4.7.1. to 4.15.1 and Followed
https://docs.cloudstack.apache.org/en/latest/upgrading/upgrade/upgrade-4.7.html
After the upgrade I got
/2021-08-31 19:27:26,990 DEBUG [c.c.u.d.ScriptRunner] (main:null) --;//
//2021-08-31 19:27:26,990 DEBUG [c.c.u.d.ScriptRunner] (main:null) --
Schema upgrade from 4.7.1 to 4.8.0;//
//2021-08-31 19:27:26,990 DEBUG [c.c.u.d.ScriptRunner] (main:null) --;//
//2021-08-31 19:27:26,990 DEBUG [c.c.u.d.ScriptRunner] (main:null) ALTER
TABLE `cloud`.`nicira_nvp_router_map` DROP INDEX `logicalrouter_uuid` //
//2021-08-31 19:27:26,998 ERROR [c.c.u.d.ScriptRunner] (main:null) Error
executing: ALTER TABLE `cloud`.`nicira_nvp_router_map` DROP INDEX `logic//
//alrouter_uuid` //
//2021-08-31 19:27:26,998 ERROR [c.c.u.d.ScriptRunner] (main:null)
java.sql.SQLSyntaxErrorException: Can't DROP 'logicalrouter_uuid'; check
that //
//column/key exists//
//2021-08-31 19:27:26,999 ERROR [c.c.u.DatabaseUpgradeChecker]
(main:null) Unable to execute upgrade script/
/....../
/2021-08-31 19:27:27,008 DEBUG [c.c.u.d.T.Transaction] (main:null)
Rolling back the transaction: Time = 15 Name = Upgrade; called by
-TransactionLegacy.rollback:888-TransactionLegacy.removeUpTo:831-TransactionLegacy.close:655-DatabaseUpgradeChecker.upgrade:308-DatabaseUpgradeChecker.check:377-CloudStackExtendedLifeCycle.checkIntegrity:64-CloudStackExtendedLifeCycle.start:54-DefaultLifecycleProcessor.doStart:178-DefaultLifecycleProcessor.access$200:54-DefaultLifecycleProcessor$LifecycleGroup.start:356-Iterable.forEach:75-DefaultLifecycleProcessor.startBeans:155
/
I am new to cloudstack . Please help me to resolve the issue
TIA
Biswajit
