You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Biswajit Banerjee <bi...@tetrain.com.INVALID> on 2021/09/01 02:10:42 UTC
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, 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 <bi...@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
>> <bi...@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
>>>
>>>
>
Re: Upgrade of Cloudstack 4.7.1 to 4.15.1 Failed
Posted by Cristian Ciobanu <cr...@istream.today>.
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
<bi...@tetrain.com.invalid> 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, cristian.c@istream.today 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 <bi...@tetrain.com.INVALID>
> > Sent: Wednesday, September 1, 2021 5:11 AM
> > To: users@cloudstack.apache.org
> > 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, 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 <bi...@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
> >>> <bi...@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/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
> >>>>
> >>>>
> >
>
Re: Upgrade of Cloudstack 4.7.1 to 4.15.1 Failed
Posted by Biswajit Banerjee <bi...@tetrain.com.INVALID>.
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, cristian.c@istream.today 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 <bi...@tetrain.com.INVALID>
> Sent: Wednesday, September 1, 2021 5:11 AM
> To: users@cloudstack.apache.org
> 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, 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 <bi...@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
>>> <bi...@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/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
>>>>
>>>>
>
RE: Upgrade of Cloudstack 4.7.1 to 4.15.1 Failed
Posted by cr...@istream.today.
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 <bi...@tetrain.com.INVALID>
Sent: Wednesday, September 1, 2021 5:11 AM
To: users@cloudstack.apache.org
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, 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 <bi...@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
>> <bi...@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/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
>>>
>>>
>