Public bug reported: I have recently upgraded my Openstack installation from the version packaged in Oneiric to the one packaged in Precise. After the installation, no floating ip addresses were available to instances.
When running "euca-allocate-address" returns a NoMoreFloatingIps exception. Before the upgrade, I shutdown all running instances but I did not unallocate and unassign floating ip addresses. After the upgrade the floating_ips table in the Nova database had entries, but clearly these entries where seen as reserved by Nova. It seems as though the database migrations do not handle this case. Workaround: I needed to run the following SQL query to free up the floating ip addresses for allocation to instances: 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; ** Affects: nova (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/934118 Title: Floating ips not available to instances after upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/nova/+bug/934118/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs