ARP records aren't closed when router goes down

[jmbredal]

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';

---

Imported from Launchpad using lp2gh.

• date created: 2011-05-31T10:51:24Z
• owner: mbrekkevold
• assignee: mbrekkevold
• the launchpad url was https://bugs.launchpad.net/bugs/790600

[jmbredal]

(by mbrekkevold)
fix here: http://metanav.uninett.no/hg/default/rev/6141946f75bb

[jmbredal]

Translated changeset references:
http://metanav.uninett.no/hg/default/rev/6141946f75bb: 3e6f2df