On Thu, Apr 15, 2010 at 03:04:31PM +0200, Stokkenes Vidar wrote:
Hello everyone,
For a very long time, I've had problems with slow loading ipdevinfo pages (typically when opening a switch listed in "Reports" -> All IP Devices)
Does this switch have any CAM records associated with it?
There is a known issue in ipdevinfo that will cause it to take forever to load a page for a device that has no CAM records - typically servers or pure layer 3 devices (routers).
I see now this hasn't been registered as a bug in Launchpad, but it has been fixed for NAV 3.6. PostgreSQL creates a crappy query plan for a simple query that wants to find the first CAM entry from a device, and it ends up scanning all CAM records (often millions), just to find out that there are no rows.
If this seems to be a match for your problem, you can find the fix w/details here: http://metanav.uninett.no/hg/default/rev/b2d0a4699bb1