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.
@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_ nodegroupinterf ace 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.