Kiran Koneti created CLOUDSTACK-2150:
----------------------------------------
Summary: 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
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
