incubator-cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Will Chan <will.c...@citrix.com>
Subject RE: DB upgrade to 4.0 version
Date Tue, 14 Aug 2012 00:10:30 GMT
Ewan, I will help chase the Citrix proposed features (minus Netcaler team) to add in upgrades
scripts for their respective features.  I assume you can take care of the rest?

Will

> -----Original Message-----
> From: Alena Prokharchyk [mailto:Alena.Prokharchyk@citrix.com]
> Sent: Monday, August 13, 2012 4:31 PM
> To: cloudstack-dev@incubator.apache.org
> Cc: Hugo Trippaers
> Subject: DB upgrade to 4.0 version
> 
> I started looking at the DB upgrade part of the code for 4.0 release, and
> fixed the following:
> 
> 1) joined 3.0.2->3.0.3 and 3.0.3->4.0 upgrade paths to one: 3.0.2 to 4.0.
> Did it because asf/master was branched when no 3.0.3 was released yet,
> and we shouldn't have merged 302->303 to asf/master.
> So whoever is going to make the upgrade to 4.0 Apache cloudStack, can do
> it from the any version up to 3.0.2 inclusively.
> 
> 2) Added upgrade code for the VPC feature
> 
> 
> Hugo, I hit some error in your code during the unittest for db upgrade:
> 
> mysql -u root cloud < ./setup/db/db/schema-302to40.sql ERROR 1242
> (21000) at line 237: Subquery returns more than 1 row
> 
> It seems to be related to commit
> 420f08ab4a37fa485e6318a5c2683732b5744d7e,
> and the following query returns more than one row:
> 
> mysql> select CONCAT(CONCAT('DROP INDEX ', A.CONSTRAINT_NAME), ' ON
> physical_network_service_providers' ) from
> information_schema.key_column_usage A JOIN
> information_schema.key_column_usage B ON B.table_name =
> 'physical_network_service_providers' AND B.COLUMN_NAME =
> 'provider_name'
> AND A.COLUMN_NAME ='physical_network_id' AND
> B.CONSTRAINT_NAME=A.CONSTRAINT_NAME where A.table_name =
> 'physical_network_service_providers';+-------------------------------------
> --------------------------------------------------------+
> | CONCAT(CONCAT('DROP INDEX ', A.CONSTRAINT_NAME), ' ON
> physical_network_service_providers' ) |
> +-----------------------------------------------------------------------
> +---
> -------------------+
> | DROP INDEX physical_network_id ON
> physical_network_service_providers
>                    |
> | DROP INDEX physical_network_id ON
> physical_network_service_providers
>                    |
> | DROP INDEX physical_network_id ON
> physical_network_service_providers
>                    |
> | DROP INDEX physical_network_id ON
> physical_network_service_providers
>                    |
> +-----------------------------------------------------------------------
> +---
> -------------------+
> 4 rows in set (0.00 sec)
> 
> 
> 
> 
> So could you please take a look and let me know if I did something wrong,
> or is it a real bug? Steps I've made to reproduce the problem:
> 
> * deployed cloudStack 3.0.2, haven't added any resources, no dataCenters,
> nothing
> * ran schema-302to40.sql against this DB.
> 
> 
> 
> Thank you,
> Alena.


Mime
View raw message