Sanjeev, My zone is Adv+SG and I do not want to remove the whole network, just a vlaniprange from it. I managed to delete it from the DB via phpMyAdmin.
Lucian -- Sent from the Delta quadrant using Borg technology! Nux! www.nux.ro ----- Original Message ----- > From: "Sanjeev Neelarapu" <sanjeev.neelar...@citrix.com> > To: dev@cloudstack.apache.org > Sent: Wednesday, 4 March, 2015 04:32:03 > Subject: RE: Cannot delete range as IP is being used for providing dhcp > service in this subnet > Hi Nux, > > In shared network we keep the guestipaddress that router gets in allocated > state > even after destroying VR. However, the network deletion should be allowed > after > destroying VR. If not may be a defect. > > Thanks, > Sanjeev > > -----Original Message----- > From: ilya musayev [mailto:ilya.mailing.li...@gmail.com] > Sent: Wednesday, March 04, 2015 7:29 AM > To: dev@cloudstack.apache.org > Subject: Re: Cannot delete range as IP is being used for providing dhcp > service > in this subnet > > I assume you can make sense of these queries, install something like MySQL > Workbench - or tool you like the most for sql work so you can make changes in > place without knowing much of SQL. > > Here are snippets i wrote that may help > > First find the network ID you need to clean up SELECT * from cloud.networks > > check what i used to check what network uses which IPs. > SELECT name,ip4_address FROM cloud.nics,cloud.vm_instance where broadcast_uri > like "%106" and nics.instance_id=vm_instance.id and nics.state not like > "Deallocating"; > > Check what IPs are used by specific network, you can alter them to Free once > you > find the disparity SELECT * FROM cloud.user_ip_address where > source_network_id=221 and state not like "Free"; > > Same on NICs table, set them to Deallocating if they are set to Reserved or > Allocated - and append the removed date SELECT * FROM cloud.nics where > network_id=212 and state not like "Deallocating" and removed is null; > > On 3/3/15 5:17 PM, Nux! wrote: >> I have disabled the zone hours ago and killed the VR. I still cannot remove >> that >> range, same error. >> I'll let it do its thing overnight and try again tomorrow morning. >> >> At this point the waiting times are kind of bad and I'd rather dive in the >> DB if >> there's a reasonable way of doing it that way. >> >> Lucian >> >> -- >> Sent from the Delta quadrant using Borg technology! >> >> Nux! >> www.nux.ro >> >> ----- Original Message ----- >>> From: "Nux!" <n...@li.nux.ro> >>> To: dev@cloudstack.apache.org >>> Sent: Tuesday, 3 March, 2015 23:18:24 >>> Subject: Re: Cannot delete range as IP is being used for providing >>> dhcp service in this subnet Hi Marcus, >>> >>> Yes, shared guest networks. >>> >>> I'll try your way. >>> >>> -- >>> Sent from the Delta quadrant using Borg technology! >>> >>> Nux! >>> www.nux.ro >>> >>> ----- Original Message ----- >>>> From: "Marcus" <shadow...@gmail.com> >>>> To: dev@cloudstack.apache.org >>>> Sent: Tuesday, 3 March, 2015 22:20:05 >>>> Subject: Re: Cannot delete range as IP is being used for providing >>>> dhcp service in this subnet We're not talking guest networks, right? >>>> In the past I've been able to remove these by disabling the zone, >>>> then deleting the router and/or applicable system vms. Disabling the >>>> zone ensures the system vms don't come back up. The vms do have to >>>> expunge though before you'll have any luck. >>>> >>>> On Tue, Mar 3, 2015 at 2:06 PM, Somesh Naidu <somesh.na...@citrix.com> >>>> wrote: >>>>> Lucian, >>>>> >>>>> Not sure if you can get past that without destroying that network >>>>> (or manipulating the DB). >>>>> >>>>> I am not sure if network restart with cleanup true releases the VR >>>>> IP so you probably could try that. If it does, then we'd have to >>>>> figure how to avoid the new IP getting chosen from the same IP range. >>>>> >>>>> Regards, >>>>> Somesh >>>>> >>>>> >>>>> -----Original Message----- >>>>> From: Nux! [mailto:n...@li.nux.ro] >>>>> Sent: Tuesday, March 03, 2015 2:31 PM >>>>> To: dev >>>>> Subject: [4.5] Cannot delete range as IP is being used for >>>>> providing dhcp service in this subnet >>>>> >>>>> Hi, >>>>> >>>>> I'm having this problem, I've added a secondary subnet/range in my >>>>> Adv+SG zone and now I want to delete it. >>>>> All the VMs using it have been deleted (and I've been waiting for a >>>>> while for the explunge/cleanup jobs to run), yet I am getting this error: >>>>> >>>>> "Cannot delete vlan range 2 as 192.168.203.102 is being used for >>>>> providing dhcp service in this subnet. Delete all VMs in this subnet and >>>>> try >>>>> again" >>>>> >>>>> All the VMs are deleted, only the virtual router is using IPs from that >>>>> range. >>>>> >>>>> root@r-4-VM:~# ip a|grep 192.168 >>>>> inet 192.168.203.102/24 brd 192.168.203.255 scope global eth0:55 >>>>> inet 192.168.203.103/24 brd 192.168.203.255 scope global >>>>> secondary eth0:56 >>>>> >>>>> How can I make the VR let go of those IPs? >>>>> >>>>> Lucian >>>>> >>>>> -- >>>>> Sent from the Delta quadrant using Borg technology! >>>>> >>>>> Nux! > >>>> www.nux.ro
