Rayees Namathponnan created CLOUDSTACK-2548:
-----------------------------------------------
Summary: [Automation] Failed to delete public IP range
Key: CLOUDSTACK-2548
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2548
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Network Controller
Affects Versions: 4.2.0
Environment: Master build : Latest
Issue found : During BVT automation run on KVM
Reporter: Rayees Namathponnan
Priority: Blocker
Fix For: 4.2.0
Test case : test/integration/smoke/test_public_ip_range.py
Steps to reproduce
Step 1 : Create advance zone, and add IP range [In my case added
10.223.122.124 to 10.223.122.126]
Step 2 : Delete this IP range
Actual Result
Release IP range operation failed with below error
"One of the ips in the range is used to provide Dhcp service to this subnet.
cannot delete this range as"
If you look the DB, ip range 10.223.122.124 to 10.223.122.126 is not
allocated
mysql> select * from user_ip_address where state!="Free";
+----+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+
| id | uuid | account_id | domain_id |
public_ip_address | data_center_id | source_nat | allocated |
vlan_db_id | one_to_one_nat | vm_id | state | mac_address |
source_network_id | network_id | physical_network_id | is_system | vpc_id |
dnat_vmip |
+----+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+
| 2 | ddd29f48-54ba-4b76-b493-c629481111f1 | 38 | 1 |
10.223.122.67 | 1 | 1 | 2013-05-16 18:01:34 |
1 | 0 | NULL | Allocated | 60 | 200 |
241 | 200 | 0 | NULL | NULL |
| 3 | e4f7899b-1d5b-4c7c-91bd-38af7db1945a | 4 | 1 |
10.223.122.68 | 1 | 1 | 2013-05-16 03:54:34 |
1 | 0 | NULL | Releasing | 61 | 200 |
209 | 200 | 0 | NULL | NULL |
| 4 | ab3b333a-bad2-427f-ad7d-6d9f3cac5336 | 1 | 1 |
10.223.122.69 | 1 | 0 | 2013-05-16 04:56:39 |
1 | 0 | NULL | Allocated | 62 | 200 |
NULL | 200 | 0 | NULL | NULL |
| 6 | 73fe34aa-bdce-4f58-bc54-40fe6584a2da | 2 | 1 |
10.223.122.71 | 1 | 1 | 2013-05-16 05:43:59 |
1 | 0 | NULL | Allocated | 64 | 200 |
230 | 200 | 0 | NULL | NULL |
| 23 | b97b3062-a82d-487a-8d56-4355ce72d3c7 | 2 | 1 |
10.223.122.88 | 1 | 1 | 2013-05-16 05:23:12 |
1 | 0 | NULL | Allocated | 81 | 200 |
227 | 200 | 0 | NULL | NULL |
| 32 | 3d1f0625-90a0-4632-9cfb-aed018efa51c | 2 | 1 |
10.223.122.97 | 1 | 1 | 2013-05-16 05:52:11 |
1 | 0 | NULL | Allocated | 90 | 200 |
232 | 200 | 0 | NULL | NULL |
| 52 | 851757d9-92f2-493c-98f6-3bd01b0c2d3b | 1 | 1 |
10.223.122.117 | 1 | 0 | 2013-05-16 04:54:09 |
1 | 0 | NULL | Allocated | 110 | 200 |
NULL | 200 | 0 | NULL | NULL |
| 60 | eede24f6-6587-4f75-8e2a-7063ffd2c833 | 1 | 1 |
10.223.121.132 | 2 | 0 | 2013-05-16 03:39:09 |
2 | 0 | NULL | Allocated | 61 | 204 |
NULL | 201 | 0 | NULL | NULL |
| 63 | a720338f-15f8-4d47-acc0-da6a2917406d | 1 | 1 |
10.223.121.135 | 2 | 0 | 2013-05-16 03:39:17 |
2 | 0 | NULL | Allocated | 64 | 204 |
NULL | 201 | 0 | NULL | NULL |
+----+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+
9 rows 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
