After creating an instance, associating a floating IP with that instance, and then deleting that instance without first disassociating the floating IP I have found that the IPs seem to remain in an allocated state:

[root@controller ~]# nova floating-ip-list
+--------------+-----------+----------+---------+
| Ip           | Server Id | Fixed Ip | Pool    |
+--------------+-----------+----------+---------+
| xx.xx.xx.236 |           | -        | ext-net |
| xx.xx.xx.237 |           | -        | ext-net |
+--------------+-----------+----------+---------+
[root@controller ~]# neutron floatingip-list
+--------------------------------------+------------------+---------------------+---------+
| id                                   | fixed_ip_address | floating_ip_address | port_id |
+--------------------------------------+------------------+---------------------+---------+
| 10f9c38b-8b6d-43fc-b79f-5cda72ab5a57 |                  | xx.xx.xx.234        |         |
| 2797a70d-1806-4898-8452-69a003a3d541 |                  | xx.xx.xx.233        |         |
| 7c8cfe87-01b1-438a-aa5e-06126588792e |                  | xx.xx.xx.236        |         |
| 93d28815-ce60-476b-8891-7c4bbd75c73b |                  | xx.xx.xx.235        |         |
| bdaabeb0-d5ad-453d-bce5-7a9ae70b3687 |                  | xx.xx.xx.237        |         |
+--------------------------------------+------------------+---------------------+---------+

How do I correct this error? I image I have to manually edit the database I would just like to know where. Thanks.