Hello, There are 2 IPs from that range in user_ip+address table but vm_id for all records is null. How do I determine which vms are using them?
On Fri, May 21, 2021 at 3:41 PM Pearl d'Silva <[email protected]> wrote: > Hi Fariborz, > > Can you try listing for public IPs that are still allocated by querying > the following: > > select * from user_ip_address where data_center_id = <data_center_id> and > allocated is not null; > > If it does return some IPs that are marked as allocated and are within the > public IP range that you are attempting to delete, set those entries as > removed by updating the 'allocated' field of the 'user_ip_address' table as > null. Once this is done, you should be able to delete the Ip range. > > I'm not sure if there is a way to do the same via the UI. > > Thanks, > Pearl > ________________________________ > From: Fariborz Navidan <[email protected]> > Sent: Friday, May 21, 2021 4:16 PM > To: [email protected] <[email protected]> > Subject: Re: Delete IP range > > Zone is disabled and no system VM and router exists but still the same > error. > > On Fri, May 21, 2021 at 3:12 PM Fariborz Navidan <[email protected]> > wrote: > > > I have done the same. Still get this error message. > > > > Please help > > > > On Fri, May 21, 2021 at 11:55 AM Andrija Panic <[email protected]> > > wrote: > > > >> You should disable the zone and then delete SSVM and CPVM - otherwise > ACS > >> will try to create it again and use 2 IPs again. > >> Then remove the range, then enable the Zone again. > >> > >> Otherwise, you can check the table in DB user_ip_address (or similar) > and > >> try to read which IP is used atm - but probably it's just the SSVM and > >> CPVM > >> which have been recreated. > >> > >> On Fri, 21 May 2021 at 08:44, Fariborz Navidan <[email protected]> > >> wrote: > >> > >> > Hello, > >> > > >> > We have migrated our server and public IPs has been changed. I need to > >> > migrate all IP ranges to the new one. I have added a new IP range and > >> > changed IP of all VMs. I need to force system VMS to use new IP range. > >> I'm > >> > trying delete the old IP range so that cloudstack assign IPs from the > >> new > >> > range. I just destroyed all system VMs but when I try to delete old IP > >> > range, I get error "2 IPs are used". How do I determine where IPs are > >> used? > >> > > >> > Please advise. > >> > Regards. > >> > > >> > >> > >> -- > >> > >> Andrija Panić > >> > > > > > >
