Hi, If this is a production environment, you should hire someone with experience in cloudstack. You can find all these details on internet, how to remove, install...
Regards, Cristian On Wed, Sep 1, 2021, 9:59 AM Biswajit Banerjee <[email protected]> wrote: > Hi Cristian, > > Please Help me to remove the current version , will it work like "yum > remove cloudstack-management" > > Can Please help me to restore changes ( some Hint ) to Hypervisor . > > Please ignore my ignorance . I am new to cloudstack and hypervisor . > > Thanks > > > On 01/09/21 11:47 am, [email protected] wrote: > > Hi, > > > > My suggestion for you is to restore your cloudstack: > > > > - remove this version > > - drop the db > > - install the previous version > > - restore the db > > > > If you did any changes to hypervisors, restore the changes. > > > > After you're back to the previous version, test it, see if everything > is fine, after this you can create another backup and follow the upgrade > documentation. > > > > > > Regards, > > Cristian > > > > -----Original Message----- > > From: Biswajit Banerjee <[email protected]> > > Sent: Wednesday, September 1, 2021 5:11 AM > > To: [email protected] > > Subject: Re: Upgrade of Cloudstack 4.7.1 to 4.15.1 Failed > > > > Hi Cristian Thank for the support > > > > On 01/09/21 12:26 am, [email protected] 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 <[email protected]> > >> Sent: Tuesday, August 31, 2021 9:36 PM > >> To: [email protected] > >> 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 > >>> <[email protected]> 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/upgra > >>>> de-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-Tra > >>>> nsactionLegacy.close:655-DatabaseUpgradeChecker.upgrade:308-Database > >>>> UpgradeChecker.check:377-CloudStackExtendedLifeCycle.checkIntegrity: > >>>> 64-CloudStackExtendedLifeCycle.start:54-DefaultLifecycleProcessor.do > >>>> Start:178-DefaultLifecycleProcessor.access$200:54-DefaultLifecyclePr > >>>> ocessor$LifecycleGroup.start:356-Iterable.forEach:75-DefaultLifecycl > >>>> eProcessor.startBeans:155 > >>>> / > >>>> > >>>> I am new to cloudstack . Please help me to resolve the issue > >>>> > >>>> > >>>> TIA > >>>> > >>>> Biswajit > >>>> > >>>> > > >
