[ https://issues.apache.org/jira/browse/CLOUDSTACK-2150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bharat Kumar resolved CLOUDSTACK-2150. -------------------------------------- Resolution: Fixed 7f2f25d640b47c8e72381bfc318a7bbbb1ca2bfd > DB table entries of phisical network is not proper.Shows Duplicate entries. > ----------------------------------------------------------------------------- > > Key: CLOUDSTACK-2150 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2150 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Affects Versions: 4.2.0 > Reporter: Kiran Koneti > Assignee: Bharat Kumar > Fix For: 4.2.0 > > > Created a network with the vlan range 921-925;then added a Vlan range from > 930-934; > The db table entries shows correctly. > Then added the IP range from 921-934; then the db entries show the same range > twice ,as shown below. > mysql> select * from physical_network; > +-----+--------------------------------------+--------------------+----------------+-----------------+-------+-----------+------------------------+---------+---------------------+---------+ > | id | uuid | name | > data_center_id | vnet | speed | domain_id | broadcast_domain_range > | state | created | removed | > +-----+--------------------------------------+--------------------+----------------+-----------------+-------+-----------+------------------------+---------+---------------------+---------+ > | 200 | b1dff739-f682-4678-a526-53bd9e4ce086 | Physical Network 1 | > 1 | 921-934;921-934 | NULL | NULL | ZONE | Enabled > | 2013-04-19 18:14:14 | NULL | > +-----+--------------------------------------+--------------------+----------------+-----------------+-------+-----------+------------------------+---------+---------------------+---------+ > 1 row in set (0.00 sec) > Then deleted the range from 926 -934;then one entry is deleted in the table > but the second entry still shows 921-934.The below table explains the same. > mysql> select * from physical_network; > +-----+--------------------------------------+--------------------+----------------+-----------------+-------+-----------+------------------------+---------+---------------------+---------+ > | id | uuid | name | > data_center_id | vnet | speed | domain_id | broadcast_domain_range > | state | created | removed | > +-----+--------------------------------------+--------------------+----------------+-----------------+-------+-----------+------------------------+---------+---------------------+---------+ > | 200 | b1dff739-f682-4678-a526-53bd9e4ce086 | Physical Network 1 | > 1 | 921-925;921-934 | NULL | NULL | ZONE | Enabled > | 2013-04-19 18:14:14 | NULL | > +-----+--------------------------------------+--------------------+----------------+-----------------+-------+-----------+------------------------+---------+---------------------+---------+ > 1 row in set (0.00 sec) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira