How to purge sticky ip in the subnet?

Users
1

There are lots of sticky IP addresses observed several months ago (not in use anymore), but I cannot find a way to purge them.

2

You mean “neighbours”?

3

image
image3026Ă—252 52.6 KB

Used IP addresses at /MAAS/r/subnet/1.

4

IP addresses within the “dynamic reserved range” still been occupied by hosts that have been released.

MAAS 3.4/stable 3.4.2-14353-g.5a5221d57

5

Sticky IPs are the static IPs defined by the user. Please ensure you don’t have these IP allocated to machines

6

Thanks for your message. But in my situation, no machine uses these IP addresses, and the “last seen” value seems to be several months ago.

7

I’d suggest to run this query

 SELECT *
FROM   maasserver_staticipaddress
JOIN   maasserver_interface_ip_addresses
ON     maasserver_staticipaddress.id=maasserver_interface_ip_addresses.staticipaddress_id
JOIN   maasserver_interface
ON     maasserver_interface.id=maasserver_interface_ip_addresses.interface_id
JOIN   maasserver_nodeconfig
ON     maasserver_nodeconfig.id = maasserver_interface.node_config_id
JOIN   maasserver_node
ON     maasserver_node.id = maasserver_nodeconfig.node_id
WHERE  ip='192.168.0.154';

and see if you get a result. If not, start removing some joins and spot if you have orphan resources

8

Thank you. It seems to be an orphan IP record. Should I manually delete this record from the db?

9

Would be interesting to know how you ended up with an orphan IP but yeah, I’d say that’s the only way

1 Like
10

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.