CAM records munged on netbox removal

Bug #258297 reported by Morten Brekkevold
2
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://sourceforge.net/tracker/index.php?func=detail&aid=1899476&group_id=107608&atid=648170]

Revision history for this message
Morten Brekkevold (mbrekkevold) wrote :

Originator: YES

Fixed in r4385. Will be part of NAV 3.3.3.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.