Doesn't seem to free up still when I destroy the instances. So I go in and try to manually cleanup fixed ip's for the 2 networks: +---------------------+---------------------+------------+---------+------+--------------+------------+-------------+-----------+--------+----------+----------------------+------+ | created_at | updated_at | deleted_at | deleted | id | address | network_id | instance_id | allocated | leased | reserved | virtual_interface_id | host | +---------------------+---------------------+------------+---------+------+--------------+------------+-------------+-----------+--------+----------+----------------------+------+ | 2012-04-30 12:40:50 | 2012-05-02 11:39:12 | NULL | 0 | 1297 | 172.16.65.16 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:39:12 | NULL | 0 | 1298 | 172.16.65.17 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:39:12 | NULL | 0 | 1299 | 172.16.65.18 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:08:38 | NULL | 0 | 1300 | 172.16.65.19 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:07:56 | NULL | 0 | 1301 | 172.16.65.20 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:11:05 | NULL | 0 | 1302 | 172.16.65.21 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:11:05 | NULL | 0 | 1303 | 172.16.65.22 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1304 | 172.16.65.23 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1305 | 172.16.65.24 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:48 | NULL | 0 | 1306 | 172.16.65.25 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1307 | 172.16.65.26 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1308 | 172.16.65.27 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:45 | NULL | 0 | 1309 | 172.16.65.28 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:44 | NULL | 0 | 1310 | 172.16.65.29 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:44 | NULL | 0 | 1311 | 172.16.65.30 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:44 | NULL | 0 | 1312 | 172.16.65.31 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:37:21 | NULL | 0 | 1313 | 172.16.65.16 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:37:21 | NULL | 0 | 1314 | 172.16.65.17 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:37:48 | NULL | 0 | 1315 | 172.16.65.18 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:07:50 | NULL | 0 | 1316 | 172.16.65.19 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:07:50 | NULL | 0 | 1317 | 172.16.65.20 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:10:46 | NULL | 0 | 1318 | 172.16.65.21 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:10:47 | NULL | 0 | 1319 | 172.16.65.22 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:23:49 | NULL | 0 | 1320 | 172.16.65.23 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:21 | NULL | 0 | 1321 | 172.16.65.24 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:22 | NULL | 0 | 1322 | 172.16.65.25 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:22 | NULL | 0 | 1323 | 172.16.65.26 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:22 | NULL | 0 | 1324 | 172.16.65.27 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1325 | 172.16.65.28 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1326 | 172.16.65.29 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1327 | 172.16.65.30 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1328 | 172.16.65.31 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | +---------------------+---------------------+------------+---------+------+--------------+------------+-------------+-----------+--------+----------+----------------------+------+ All looks ok right? Then I start 2-4 instances in the given network (8) and terminate them: mysql> select * from fixed_ips where network_id = '7' or network_id = 8; +---------------------+---------------------+------------+---------+------+--------------+------------+-------------+-----------+--------+----------+----------------------+------+ | created_at | updated_at | deleted_at | deleted | id | address | network_id | instance_id | allocated | leased | reserved | virtual_interface_id | host | +---------------------+---------------------+------------+---------+------+--------------+------------+-------------+-----------+--------+----------+----------------------+------+ | 2012-04-30 12:40:50 | 2012-05-02 11:43:29 | NULL | 0 | 1297 | 172.16.65.16 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:43:28 | NULL | 0 | 1298 | 172.16.65.17 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:43:28 | NULL | 0 | 1299 | 172.16.65.18 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:43:53 | NULL | 0 | 1300 | 172.16.65.19 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:07:56 | NULL | 0 | 1301 | 172.16.65.20 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:11:05 | NULL | 0 | 1302 | 172.16.65.21 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:11:05 | NULL | 0 | 1303 | 172.16.65.22 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1304 | 172.16.65.23 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1305 | 172.16.65.24 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:48 | NULL | 0 | 1306 | 172.16.65.25 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1307 | 172.16.65.26 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:24:49 | NULL | 0 | 1308 | 172.16.65.27 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:45 | NULL | 0 | 1309 | 172.16.65.28 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:44 | NULL | 0 | 1310 | 172.16.65.29 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:44 | NULL | 0 | 1311 | 172.16.65.30 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 12:40:50 | 2012-05-02 11:32:44 | NULL | 0 | 1312 | 172.16.65.31 | 7 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:42:50 | NULL | 0 | 1313 | 172.16.65.16 | 8 | 111 | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:42:50 | NULL | 0 | 1314 | 172.16.65.17 | 8 | 113 | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:42:50 | NULL | 0 | 1315 | 172.16.65.18 | 8 | 110 | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:42:50 | NULL | 0 | 1316 | 172.16.65.19 | 8 | 112 | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:07:50 | NULL | 0 | 1317 | 172.16.65.20 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:10:46 | NULL | 0 | 1318 | 172.16.65.21 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:10:47 | NULL | 0 | 1319 | 172.16.65.22 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:23:49 | NULL | 0 | 1320 | 172.16.65.23 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:21 | NULL | 0 | 1321 | 172.16.65.24 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:22 | NULL | 0 | 1322 | 172.16.65.25 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:22 | NULL | 0 | 1323 | 172.16.65.26 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:24:22 | NULL | 0 | 1324 | 172.16.65.27 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1325 | 172.16.65.28 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1326 | 172.16.65.29 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1327 | 172.16.65.30 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | | 2012-04-30 19:57:05 | 2012-05-02 11:25:22 | NULL | 0 | 1328 | 172.16.65.31 | 8 | NULL | 0 | 0 | 0 | NULL | NULL | +---------------------+---------------------+------------+---------+------+--------------+------------+-------------+-----------+--------+----------+----------------------+------+ mysql> select id, deleted from instances where id >= 110 and id <= 113; +-----+---------+ | id | deleted | +-----+---------+ | 110 | 1 | | 111 | 1 | | 112 | 1 | | 113 | 1 | +-----+---------+ So something is still messing up and this is making quantum quite useless since it doesn't free ips.