[Bug 994034] Re: Cannot deallocate floating addresses as cloudadmin

2012-05-04 Thread Andrew Glen-Young
*** This bug is a duplicate of bug 897140 *** https://bugs.launchpad.net/bugs/897140 ** This bug has been marked a duplicate of bug 897140 unassociated floating IPs not visible to admin -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscrib

[Bug 994034] Re: Cannot deallocate floating addresses as cloudadmin

2012-05-03 Thread Andrew Glen-Young
I ran the following SQL query to work around the issue: sql> UPDATE floating_ips SET deleted_at = NULL, fixed_ip_id = NULL, project_id = NULL, host = NULL where floating_ips.deleted = 0 AND floating_ips.auto_assigned = 0 and host is NULL; -- You received this bug notification because you are a m