CAM records munged on netbox removal
Bug #258297 reported by
Morten Brekkevold
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Network Administration Visualized |
Fix Released
|
High
|
Morten Brekkevold |
Bug Description
A similar problem to bug SF#1899431 exists in the cam table. A trigger
sets end_time to current_timestamp when netboxid is set to null. Netboxid
is typically set to null only through a cascading mechanism when a netbox
is deleted.
The problem here is also that the end_time is updated even for already
closed records. This bug has been present at least since 2002, and has
amazingly gone undisocovered until now.
Kudos to Gro-Anita Vindheim of NTNU, who reported both bugs.
[http://
To post a comment you must log in.
Originator: YES
Fixed in r4385. Will be part of NAV 3.3.3.