Deleting node overly load intensive

Description

Redhat 9, opennms-1.1.3-0.20040429.0, tomcat4-4.1.18-full.1jpp java 1.4.02.
Deleting a node via the web interface can become very load intensive. In
particular deleting a node that had many ip interfaces will bring load up to the
75 range. We do have an exorbitant amount of nodes and services moving around
due to limited resources, so things change alot more than they should

Regards,
Ted

Environment

Operating System: Linux Platform: PC

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:

Ted Kaczmarek September 7, 2004 at 8:17 PM

CVS 1.1.4 seems to have addressed this, great work Matt.

Ted

Ted Kaczmarek June 17, 2004 at 10:02 PM

would /etc/sysconfig/i18n having
SUPPORTED="en_US.iso885915:en_US:en"

as opposed to

SUPPORTED="en_US.UTF-8:en_US:en"

make a difference ?

Regards,
Ted

Ted Kaczmarek June 10, 2004 at 11:28 PM

I setup my dev box to mirror my other box minus customcat and extra
categories/viewdisplay, also the main box has ICMP polls at 30 seconds and one
custom tcp service monitor at 30 seconds as well. The dev box is using all stock
300 second polls. The dev box db is not a mirror of the other box but fairly
close. It appears to have no excessive load issues when deleting a node. Also
noticed that rescans seem much faster on the dev box as well. I started
collecting vital's on the dev box but am fairly certain it does not see these
loads as nothing made me check it Since I now have something decent to
compare with will continue with trying to find what the major trigger is. Will
gather more info as I make the dev box mirror the one I see the loads with.
The dev box is a p700, old ide with 512mb, the other box is P4 2.4, scsi, with 1
gig.

Tarus Balog May 21, 2004 at 1:43 PM

Two notes on delete nodes:

1) We need to build a delete interface and delete service method

2) Check out the performance of SELECT and IN statements

Ted Kaczmarek May 20, 2004 at 5:53 PM

Suspect the fact that opennms is deleting services that never existed on the
node are adding extra load. I make this assumption based upon the events I see
being generated after a noe is deleted. I have an additional 7 custom pollers in
my case using tcp, which probable magnifies the problem.

Regards,
Ted

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

PagerDuty

Created May 3, 2004 at 7:01 AM
Updated January 27, 2017 at 4:31 PM
Resolved September 7, 2004 at 9:17 PM