Thanks Cristian
Yes DB Backup for Cloud and Cloud user was done before upgrade.
Details are
* Hypervisor - Xen 7.0.
* Zone 3
* Host 11
* Management VM - Centos 7
Log is accessible at
https://drive.google.com/file/d/1bFte0zlNOT64D55R6NLEhCZ_0u5Q7A7p/view?usp=sharing
On 31/08/21 11:48 pm, Cristian Ciobanu wrote:
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
