Nova-manage fixed list fails to return correct information

after delete a network, then create a network, command "nova-manage fixed list " should return a list with newly created IPs, but currently that command returns with an error message as follows:

"Command failed, please check log for more info"

Here are the steps to reproduce.

$ nova-manage version list
2012.2-dev (2012.2-LOCALBRANCH:LOCALREVISION)

devstack install (July 17, 2012).

$nova-manage fixed list
network IP address hostname host
10.0.0.0/24 10.0.0.0 None None
10.0.0.0/24 10.0.0.1 None None
10.0.0.0/24 10.0.0.2 None None
10.0.0.0/24 10.0.0.3 None None
10.0.0.0/24 10.0.0.4 None None
........

$nova-manage network list
id IPv4 IPv6 start address DNS1 DNS2 VlanID project uuid
1 10.0.0.0/24 None 10.0.0.2 8.8.4.4 None None None 0440a6eb-9407-4aeb-a9db-05c38211ee0a

$nova-manage network delete 10.0.0.0/24

$nova-manage fixed list
network IP address hostname host
Command failed, please check log for more info

$ nova-manage network list
id IPv4 IPv6 start address DNS1 DNS2 VlanID project uuid
Command failed, please check log for more info

$ nova-manage network create private --fixed_range_v4=10.0.0.0/24

$ nova-manage network list
id IPv4 IPv6 start address DNS1 DNS2 VlanID project uuid
2 10.0.0.0/24 None 10.0.0.2 8.8.4.4 None None None 94f61850-cccf-457e-b17b-b521db03b9aa

this is expected.

$ nova-manage fixed list
nova-manage fixed list
network IP address hostname host
Command failed, please check log for more info

The fixes should be in file nova/bin/nova-manage, the logic of getting fixed IP list does not seem to be quite right especially when the fixed_ips table contains IPs marked as being deleted.