cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Murali Reddy (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CLOUDSTACK-6753) [OVS] DB Schema changes are not as per FS doc for Region Level VPC and stretechd L2 Subnet
Date Fri, 13 Jun 2014 12:42:02 GMT

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-6753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Murali Reddy resolved CLOUDSTACK-6753.
--------------------------------------

    Resolution: Not a Problem

> [OVS] DB Schema changes are not as per FS doc for Region Level VPC and stretechd L2 Subnet
> ------------------------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-6753
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6753
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Management Server, Network Controller
>    Affects Versions: 4.4.0
>         Environment: latest build from 4.4 with commit e6961fd21bb6d793302c234d0f409f66dc498072
>            Reporter: Sanjeev N
>            Assignee: Murali Reddy
>            Priority: Critical
>              Labels: ovs
>             Fix For: 4.4.0
>
>
> [OVS] DB Schema changes are not as per FS doc for Region Level VPC and stretechd L2 Subnet.
> As per the FS doc for "Region level VPC and guest network spanning multiple zones" support
following DB Schema changes have been proposed:
> DB schema changes
>     a new column span_multiple_zones shall be added to 'networks' table. when 'span_multiple_zones'
is false, network in confined to a single zone and 'networks.data_center_id' shall be used
to check the zone corresponding to the network. 
>                  (ALTER TABLE `cloud`.`networks` ADD COLUMN 'span_multiple_zones' boolean
default false)
>     when a network is created with network offering that has 'stretchedl2subnet' capability
'span_multiple_zones' flag shall be set for the network
>     a new table 'network_zones_map' shall be added that shall track the details of the
zones a network is spanning
>                  CREATE  TABLE `cloud`.'network_zones_map' (
>                        `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT ,
>                        `network_id` BIGINT(20) UNSIGNED NULL , 
>                        `data_center_id` bigint(20) unsigned NOT NULL)
>     a new column 'region_level_vpc' shall be added to the vpc table, when 'region_level_vpc'
is false, VPC in confined to a single zone and 'vpc.zone_id' shall be used to check the zone
corresponding to the VPC.
>     when a VPC is created with offering that has 'regionlevelvpc' capability, 'region_level_vpc'
column for the VPC shall be set to true
>     a new table 'vpc_zones_map' shall be added that shall track the details of the zones
a VPC is spanning
>                  CREATE  TABLE `cloud`.'vpc_zones_map' (
>                        `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT ,
>                        `vpc_id` BIGINT(20) UNSIGNED NULL , 
>                        `data_center_id` bigint(20) unsigned NOT NULL)
> Issues:
> ======
> #1 networks table has new column called "streched_l2" but FS says "span_multiple_zones"
> #2 network_zones_map & vpc_zones_map tables are not present in Cloud DB.
> Following is the db schema for netowrks table:
> mysql> desc networks;
> +-----------------------+---------------------+------+-----+---------+----------------+
> | Field                 | Type                | Null | Key | Default | Extra        
 |
> +-----------------------+---------------------+------+-----+---------+----------------+
> | id                    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment
|
> | name                  | varchar(255)        | YES  |     | NULL    |              
 |
> | uuid                  | varchar(40)         | YES  | UNI | NULL    |              
 |
> | display_text          | varchar(255)        | YES  |     | NULL    |              
 |
> | traffic_type          | varchar(32)         | NO   |     | NULL    |              
 |
> | broadcast_domain_type | varchar(32)         | NO   |     | NULL    |              
 |
> | broadcast_uri         | varchar(255)        | YES  |     | NULL    |              
 |
> | gateway               | varchar(15)         | YES  |     | NULL    |              
 |
> | cidr                  | varchar(18)         | YES  |     | NULL    |              
 |
> | mode                  | varchar(32)         | YES  |     | NULL    |              
 |
> | network_offering_id   | bigint(20) unsigned | NO   | MUL | NULL    |              
 |
> | physical_network_id   | bigint(20) unsigned | YES  |     | NULL    |              
 |
> | data_center_id        | bigint(20) unsigned | NO   | MUL | NULL    |              
 |
> | guru_name             | varchar(255)        | NO   |     | NULL    |              
 |
> | state                 | varchar(32)         | NO   |     | NULL    |              
 |
> | related               | bigint(20) unsigned | NO   | MUL | NULL    |              
 |
> | domain_id             | bigint(20) unsigned | NO   | MUL | NULL    |              
 |
> | account_id            | bigint(20) unsigned | NO   | MUL | NULL    |              
 |
> | dns1                  | varchar(255)        | YES  |     | NULL    |              
 |
> | dns2                  | varchar(255)        | YES  |     | NULL    |              
 |
> | guru_data             | varchar(1024)       | YES  |     | NULL    |              
 |
> | set_fields            | bigint(20) unsigned | NO   |     | 0       |              
 |
> | acl_type              | varchar(15)         | YES  |     | NULL    |              
 |
> | network_domain        | varchar(255)        | YES  |     | NULL    |              
 |
> | reservation_id        | char(40)            | YES  |     | NULL    |              
 |
> | guest_type            | char(32)            | YES  |     | NULL    |              
 |
> | restart_required      | int(1) unsigned     | NO   |     | 0       |              
 |
> | created               | datetime            | NO   |     | NULL    |              
 |
> | removed               | datetime            | YES  | MUL | NULL    |              
 |
> | specify_ip_ranges     | int(1) unsigned     | NO   |     | 0       |              
 |
> | vpc_id                | bigint(20) unsigned | YES  | MUL | NULL    |              
 |
> | ip6_gateway           | varchar(50)         | YES  |     | NULL    |              
 |
> | ip6_cidr              | varchar(50)         | YES  |     | NULL    |              
 |
> | network_cidr          | varchar(18)         | YES  |     | NULL    |              
 |
> | display_network       | tinyint(1)          | NO   |     | 1       |              
 |
> | network_acl_id        | bigint(20) unsigned | YES  |     | NULL    |              
 |
> | streched_l2           | tinyint(1)          | YES  |     | 0       |              
 |
> +-----------------------+---------------------+------+-----+---------+----------------+
> 37 rows in set (0.00 sec)
> mysql> select * from network_zones_map;
> ERROR 1146 (42S02): Table 'cloud.network_zones_map' doesn't exist
> mysql> select * from vpc_zones_map;
> ERROR 1146 (42S02): Table 'cloud.vpc_zones_map' doesn't exist
> mysql>



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message