Hi,
I hope you have created a backup of db before the upgrade, please
restart the cloudstack management and provide the full log in pastebin a d
provide detailed about your setup.
Regards
Cristian
On Tue, Aug 31, 2021, 9:08 PM Biswajit Banerjee
<biswajit_l...@tetrain.com.invalid> wrote:
> 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
>
>
