updated subject with [SOLVED] tag

On 16-Oct-2013, at 10:48 AM, Daniel Hertanu <d...@unixmob.com> wrote:

> I think I've seen a suggestion earlier about adding the world "solved" in
> the subject whenever someone finds a solution for its problem.
> 
> So, regarding this management IP pool issue, I'm not sure that's the
> definitive solution but it did work for me. Having all management IPs used,
> CloudStack was failing to start the console proxy VM.
> I created a dump of cloud DB and start looking for my management IPs. I
> found a table called op_dc_ip_address_alloc with references to all my
> management IPs. Long story short, 2 of the 4 IP addresses were still
> showing as reserved so I simply run this:
> 
> mysql> update op_dc_ip_address_alloc set
> nic_id=NULL,reservation_id=NULL,taken=NULL where id=1;
> 
> The id in the command above was the id corresponding to the IPs that were
> still showing as reserved.
> 
> In the next 30 seconds CloudStack started also the console proxy VM and
> everything came back to normal.
> 
> I suggest creating a full backup of the database before changing anything
> though.
> 
> 
> Daniel
> 
> On Thu, Sep 26, 2013 at 2:24 AM, Daniel Hertanu <d...@unixmob.com> wrote:
> 
>> I posted here: http://pastebin.com/uJ6jR73D the logs, maybe someone else
>> have seen this behavior before. Just to remind the issue, CS 4.1, XenServer
>> 6.1, when the only existing host is rebooted without being in maintenance
>> mode (and stays down for a while), all the management IPs get used (in this
>> case there were 171 management IPs, all show as in use now).
>> 
>> Thanks,
>> 
>> Daniel
>> 
>> 
>> On Wed, Sep 25, 2013 at 8:56 PM, Musayev, Ilya <imusa...@webmd.net> wrote:
>> 
>>> Dan,
>>> 
>>> Ping me on IRC, nick serverchief
>>> 
>>> Regards
>>> ilya
>>> 
>>> 
>>>> -----Original Message-----
>>>> From: Daniel Hertanu [mailto:d...@unixmob.com]
>>>> Sent: Wednesday, September 25, 2013 6:44 AM
>>>> To: users@cloudstack.apache.org
>>>> Subject: Re: Management IP address pool exhausted
>>>> 
>>>> Hi
>>>> 
>>>> So I re-installed CS, reboot Xen host without entering it first in
>>> Maintenace
>>>> Mode, then got the management IP pool fully used. I followed again your
>>>> indications but to no avail.
>>>> In the meantime SSVM has reached number 112 (s-112-VM).
>>>> 
>>>> I would really appreciate any other idea.
>>>> 
>>>> Thanks,
>>>> 
>>>> Daniel
>>>> 
>>>> 
>>>> On Wed, Sep 25, 2013 at 9:36 AM, Daniel Hertanu <d...@unixmob.com>
>>>> wrote:
>>>> 
>>>>> Hello Ilya
>>>>> 
>>>>> I submit an issue describing the bug:
>>>>> https://issues.apache.org/jira/browse/CLOUDSTACK-4735 (I picked CS
>>>>> version 4.1.0 as 4.1.1 is reported as non existent, but I've seen this
>>>>> behavior before since version 3).
>>>>> 
>>>>> I followed your indications but it didn't work. After changing those
>>>>> records in the database, CS would still give the same error. I revert
>>>>> back to the initial db content, but this time nothing came back
>>>>> (initially the SSVM was still running, it was CPVM that didn't start).
>>>>> After this step I tried some tricks on my own and I ended up with a
>>> botched
>>>> environment.
>>>>> So I'll do a fresh install, reboot the host and try your suggestions
>>>>> again.
>>>>> 
>>>>> Thanks,
>>>>> 
>>>>> Daniel
>>>>> 
>>>>> 
>>>>> On Tue, Sep 24, 2013 at 10:46 PM, Musayev, Ilya
>>>> <imusa...@webmd.net>wrote:
>>>>> 
>>>>>> I'm not certain if this is hypervisor specific - I've seen the same
>>>>>> issue for vSphere - but I though it was me, I think we may need to
>>>>>> revise the system vm ip space decommission process.
>>>>>> 
>>>>>> Shanker and/or Daniel,
>>>>>> 
>>>>>> Do you mind creating a ticket in issues.apache.org and write out
>>> ways
>>>>>> to reproduce this issue.
>>>>>> 
>>>>>> ---
>>>>>> 
>>>>>> *NOTE* this is purely from memory and some notes I had - proceed at
>>>>>> your own risk....
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> In the meantime, lets clean up what you have.
>>>>>> 
>>>>>> The goal is to release the IPs that are still marked as reserved and
>>>>>> allocated.
>>>>>> 
>>>>>> I'd recommend installing mysql workbench
>>>>>> 
>>>>>> There are few tables we need to review:
>>>>>> 1) Stop cloudstack management server
>>>>>> 2) Backup mysql db first.
>>>>>> 
>>>>>> Note the id of management network referenced in cloud.networks
>>>>>>   Select id from cloud.networks where traffic_type="Management"
>>>>>> In my case, Management network has ID of 205
>>>>>>  SELECT * FROM cloud.nics where network_id=205; Alter to
>>>>>> Deallocating the ones that are marked as Reserved.
>>>>>> 
>>>>>> Do the same for cloud.user_ip_address  SELECT * FROM
>>>>>> cloud.user_ip_address where source_network_id=205; Alter from
>>>>>> Allocated to Free
>>>>>> 
>>>>>> Stop any systemvms if running, and alter the state from Running to
>>>>>> Stopped or Expunging in cloud.vm_instance table. This will recreate
>>>>>> the systemvm from scratch.
>>>>>> 
>>>>>> I think this should have you covered, if not, revert back the mysql
>>> db.
>>>>>> Do mysql dump and grep for IPs that should have been released.
>>>>>> 
>>>>>> Let me know,
>>>>>> 
>>>>>> Regards
>>>>>> ilya
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>>> -----Original Message-----
>>>>>>> From: Shanker Balan [mailto:shanker.ba...@shapeblue.com]
>>>>>>> Sent: Tuesday, September 24, 2013 9:44 AM
>>>>>>> To: <users@cloudstack.apache.org>
>>>>>>> Subject: Re: Management IP address pool exhausted
>>>>>>> 
>>>>>>> 
>>>>>>> On 24-Sep-2013, at 6:37 PM, Daniel Hertanu <d...@unixmob.com>
>>>> wrote:
>>>>>>> 
>>>>>>>> Hello Ilya
>>>>>>>> 
>>>>>>>> I repeated the issue by rebooting the Xen host without having it
>>>>>>>> in maintenance mode in CS. At this moment I have the SSVM up and
>>>>>>>> running and a virtual router (not related to the management IPs,
>>> I
>>>> know).
>>>>>>>> Console Proxy VM can't be started because:
>>>>>>>> 
>>>>>>>> 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
>>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>> 
>>>>>>> Hi Ilya,
>>>>>>> 
>>>>>>> I have run into the same issue too. It is easily reproducible by
>>>>>>> having
>>>>>> only one
>>>>>>> host in the Zone and rebooting it without enabling maintenance mode
>>>>>>> on
>>>>>> it.
>>>>>>> 
>>>>>>> This issue exists for both XenServer and KVM host when I tried.
>>>>>>> 
>>>>>>> 
>>>>>>> --
>>>>>>> @shankerbalan
>>>>>>> 
>>>>>>> M: +91 98860 60539 | O: +91 (80) 67935867
>>>>>>> shanker.ba...@shapeblue.com | www.shapeblue.com |
>>>>>>> Twitter:@shapeblue ShapeBlue Services India LLP, 22nd floor, Unit
>>>>>>> 2201A, World Trade Centre, Bangalore - 560 055
>>>>>>> 
>>>>>>> This email and any attachments to it may be confidential and are
>>>>>> intended
>>>>>>> solely for the use of the individual to whom it is addressed. Any
>>>>>>> views
>>>>>> or
>>>>>>> opinions expressed are solely those of the author and do not
>>>>>>> necessarily represent those of Shape Blue Ltd or related companies.
>>>>>>> If you are not
>>>>>> the
>>>>>>> intended recipient of this email, you must neither take any action
>>>>>>> based upon its contents, nor copy or show it to anyone. Please
>>>>>>> contact the
>>>>>> sender if
>>>>>>> you believe you have received this email in error. Shape Blue Ltd
>>>>>>> is a company incorporated in England & Wales. ShapeBlue Services
>>>>>>> India LLP
>>>>>> is a
>>>>>>> company incorporated in India and is operated under license from
>>>>>>> Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company
>>>>>>> incorporated
>>>>>> in
>>>>>>> Brasil and is operated under license from Shape Blue Ltd. ShapeBlue
>>>>>>> is a registered trademark.
>>>>>> 
>>>>>> 
>>>>>> 
>>>>> 
>>> 
>>> 
>> 

Reply via email to