[ https://issues.apache.org/jira/browse/CLOUDSTACK-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13667780#comment-13667780 ]
Bharat Kumar commented on CLOUDSTACK-2548: ------------------------------------------ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=commitdiff;h=47a562a2c043c32fdf1f3108552cfce170b8b27e > [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 > Assignee: Bharat Kumar > 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