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

[Andrew Glen-Young]

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