[jira] [Comment Edited] (CLOUDSTACK-4735) Management IP address pool exhausted

["Matty Courtney (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-4735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15097954#comment-15097954 ] 

Matty Courtney edited comment on CLOUDSTACK-4735 at 1/14/16 10:29 AM:
----------------------------------------------------------------------

I realize this bug is quite old, but I encountered it today so it seems to be still around.

For anyone that faces the same issue here is a generic SQL statement that will release any Management IP addresses that are reported as released by the nics table:

mysql> UPDATE cloud.op_dc_ip_address_alloc ip SET ip.reservation_id = NULL, ip.taken = NULL WHERE ip.nic_id IN (SELECT id FROM cloud.nics n WHERE n.removed IS NOT NULL) AND (ip.reservation_id IS NOT NULL OR ip.taken IS NOT NULL);


was (Author: mattycourtney):
I realize this bug is quite old, but I encountered it today so it seems to be still around.

For anyone that faces the same issue here is a generic SQL statement that will release any Management IP addresses that are reported as released by the nics table:

mysql> UPDATE cloud.op_dc_ip_address_alloc ip SET ip.reservation_id = NULL, ip.taken = NULL WHERE ip.nic_id IN (SELECT id FROM cloud.nics n WHERE n.removed IS NOT NULL);

> Management IP address pool exhausted
> ------------------------------------
>
>                 Key: CLOUDSTACK-4735
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4735
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: XenServer
>    Affects Versions: 4.1.0
>         Environment: Management server (CentOS 6.4 64 bit, CLoudStack 4.1.1), XenServer 6.1
>            Reporter: Daniel Hertanu
>
> With only one computing node in the Zone, rebooting it without enabling maintenance mode on it, determines the management IP addresses pool to be exhausted as a result of CloudStack attempting continuously to provision the system VMs. Regardless the expunge delay or interval values, the management IPs are not released anymore and the common error reported in the logs is:
> 2013-09-24 14:56:24,410 INFO  [cloud.vm.VirtualMachineManagerImpl] (Job-Executor-22:job-72) Insufficient capacity com.cloud.exception.InsufficientAddressCapacityException: Unable to get a management ip addressScope=interface com.cloud.dc.Pod; id=1



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)