Hi Cristian Thank for the support
On 01/09/21 12:26 am, cristian.c@istream.today wrote:
Hi,
1. You already had an error before the upgrade "Unable to create master
connection to host(10.10.105.102) , due to org.apache.xmlrpc.XmlRpcException: Failed to
read server's response: Received fatal alert: protocol_version" I do not recommend
upgrading without fixing the errors before.
I have upgrade 4 hosts in a Xen Hypervisor Pool , from hypervisor 7.0 to
XCP-NG 8.2 .One host 10.10.105.102 is shown in above error . I realized
that i have not followed
http://docs.cloudstack.apache.org/en/4.15.1.0/installguide/hypervisor/xenserver.html#upgrading-xenserver-versions
. I just upgraded .
To fix this , I have upgraded cloudstack 4.7.1 to 4.15.1 , but now issue
. Can this be fixed now ?
2. Here is your problem :
"2021-08-31 19:39:59,787 DEBUG [c.c.u.d.ScriptRunner] (main:null) ALTER TABLE
`cloud`.`nicira_nvp_router_map` DROP INDEX `logicalrouter_uuid`
2021-08-31 19:39:59,795 ERROR [c.c.u.d.ScriptRunner] (main:null) Error
executing: ALTER TABLE `cloud`.`nicira_nvp_router_map` DROP INDEX
`logicalrouter_uuid`
2021-08-31 19:39:59,795 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:39:59,796 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable
to execute upgrade script
java.sql.SQLSyntaxErrorException: Can't DROP 'logicalrouter_uuid'; check that
column/key exists"
3. Do a select in your table "nicira_nvp_router_map;" and see what you have inside.
You can try to stop the cloudstack, drop manually "DROP INDEX `logicalrouter_uuid" from
db and start again the cloudstack, see if works.
I will try this and update .
4. I assume that you have followed this documentation :
http://docs.cloudstack.apache.org/en/latest/upgrading/upgrade/upgrade-4.7.html ?
Yes i have followed . As hypervisor apart from Xen were not there so
have not registered the template for other hypervisors . Does this is a
issue ?
Regards,
Cristian
-----Original Message-----
From: Biswajit Banerjee <biswajit_l...@tetrain.com.INVALID>
Sent: Tuesday, August 31, 2021 9:36 PM
To: users@cloudstack.apache.org
Subject: Re: Upgrade of Cloudstack 4.7.1 to 4.15.1 Failed
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
