[Bug 934118] [NEW] Floating ips not available to instances after upgrade

Andrew Glen-Young 934118 at bugs.launchpad.net
Fri Feb 17 11:19:20 UTC 2012

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

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.


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
Server Team, which is subscribed to nova in Ubuntu.

  Floating ips not available to instances after upgrade

To manage notifications about this bug go to:

More information about the Ubuntu-server-bugs mailing list