ARP records aren't closed when router goes down

[Morten Brekkevold]

As described by Matej Gregr on the nav-users list:

> Hello,
> I noticed, that NAV does not close arp entries after monitored node
> become unavailable. For example: There is an active mac address
> 11:22:33:44:55:66 with end_time set to infinity. When the monitored node
> goes down, the mac address remains in active state, so you can find it
> using machinetracker as a still active address, which apparently is not
> true.
>
> I suggest, that there should be another rule in database, enssuring that
> arp entries will be closed.
>
> Something like:
>
> CREATE OR REPLACE RULE netbox_status_close_arp AS ON UPDATE TO netbox
> WHERE NEW.up='n'
> DO UPDATE arp SET end_time=NOW()
> WHERE netboxid=OLD.netboxid AND end_time='infinity';

[Morten Brekkevold (mbrekkevold)]

fix here: http://metanav.uninett.no/hg/default/rev/6141946f75bb