Hi Sailaja,

Thanks for your response, How can I check for the exception which were logged 
during the upgrade?

Amin
Sent from my iPad

> On Nov 8, 2013, at 5:41 PM, "Sailaja Mada" <sailaja.m...@citrix.com> wrote:
> 
> Hi,
> 
> I have observed " Duplicate column name 'hypervisor_version' "  only when I 
> tried to restart the Management server second time which was failed to start 
> for the first time soon after upgrade .
> 
> Analysis : 
> 
> The first script that gets executed during 2.2.14 to 4.2 is 
> "/usr/share/cloudstack-management/setup/db/schema-2214to30.sql"  . In this 
> sql script , the first sql stmt is :
> ============================================================
> ALTER TABLE `cloud`.`host` ADD COLUMN `hypervisor_version` varchar(32) 
> COMMENT 'hypervisor version' AFTER hypervisor_type;
> ======================================================================================================
> 
> There is a possibility that the schema-2214to30.sql got executed already 
> during the first attempt of upgrade.  This would have created 
> "hypervisor_version" column which resulted duplicate entry failure during 
> second attempt. 
> 
> Can you please check for Exceptions which were logged during first attempt of 
> upgrade. 
> 
> Thanks ,
> Sailaja.M 
> 
> -----Original Message-----
> From: Amin Samir [mailto:aminsamira...@hotmail.com] 
> Sent: 08 November 2013 12:56
> To: users@cloudstack.apache.org
> Subject: Upgrade from 2.2.14 to 4.2 fails
> 
> Hello,
> I am new to cloudstack and I have an assignment to upgrade a current 
> production environment from 2.2.14 to 4.2, I follow the exact 4.2 release 
> documentation and then the upgrade fails the output of the log file states 
> the following:
> 
> Duplicate column name 'hypervisor_version' &  Unable to execute upgrade 
> script: /usr/share/cloudstack-management/setup/db/schema-2214to30.sql & 
> System integrity check failed. Refuse to startup
> 
> Could anyone help please with the aforementioned issue?
> I am also not sure how to collaborate with the team is it the right way to 
> send an inquiry mail to users@cloudstack.apache.org? or there are other ways 
> to ask questions?
> Amin SamirSystems Administrator                         

Reply via email to