update user_ip_address set allocated=NULL where id=<id> On Tue, May 12, 2015 at 9:04 AM, ilya <[email protected]> wrote:
> Have you destroyed router vm for this network? > > I'd instead try to identify what holds up the network instead of deleting > by force. > > > On 5/11/15 3:36 PM, raja sekhar wrote: > >> Hi All, >> >> I have created a shared network in ACS 4.3.1. >> When ever i want to remove the network from UI, it is showing error unable >> to remove network. There are no vm's under this network. >> I tried to remove the network from backend by executing these commands in >> DB. >> >> update networks set state='Destroy',removed=now() where id=315; >> update vm_instance set state='Stopped' where id=393; >> update vm_instance set removed=now() where id=393; >> update domain_router set public_ip_address='NULL' where id=393; >> update nics set state='Deallocating' where id=747; >> update nics set removed=now() where id=747; >> >> Now the network is removed from ui, but the public ip is not getting free. >> what is the procedure and commands to be executed in order to free the >> public ip from backend. >> >> >> Regards, >> Rajasekhar. >> >> >
