[
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)
