Comment 5 for bug 1513485

Revision history for this message
LaMont Jones (lamont) wrote :

@Matt,

Inside of "maas-region-admin dbshell", can you run the following query? (It should return zero rows..)

select username,sip.ip,sip.created,sip.updated from maasserver_staticipaddress as sip join auth_user on user_id=auth_user.id join maasserver_nodegroupinterface on management != 0 and inet(sip.ip) >= inet(ip_range_low) and inet(sip.ip) <= inet(ip_range_high) where alloc_type=4 order by sip.ip;

If it returns any rows, those user IP reservations should be released. (The bug is that we let you move the dynamic range on top of user reserved IPs.) If it returns zero rows, and you are still experiencing the issue, it's most interesting.