Recurring downtime adding hundreds of comments

[westernuniv]

I see in the release notes for 2012R2.5:
"Fix the broken recurring downtime script -SW"

Is this fix addressing the issue seen here?

[slansing]

Not that fix specifically but I do recall running into this issue on a previous 2012 version and we had fixed it at that time. I would definitely recommend upgrading as it will serve to add new features and bug fixes.

[WillemDH]

Hello,

Last week I tested the history tab component, which is really nice. Bit it seems it's making the services who have the issue described in this thread, really really slow... When I go to the history tab, there are literally thousands of downtime comments, which is not very good for my performance.. Any idea how to cleanup the downtime history of services?
Is there any progress towards a fix for this issue?

Grtz

Willem

[nscott]

How many hosts/services do you need to do this to? This is information that is kept in the ndoutils SQL database. I hesitate to give you raw SQL that would solve you problem, but I think that is how the problem would have to be solved. Depending on what you want done (like if you don't mind losing ALL downtime history for every host, only downtime history longer than 4 months ago) we might be able to come up with a usable solution.

[WillemDH]

Well,

This would need to be done for about 12 services. We only use the recurring downtime for one servicegroup, see screenshot and for the moment, it only contains 12 services, who belong to two hosts.

When I click one of those services it can take up to 10 seconds before they open.

As we only use Nagios for about 8 months and still use SCOM 2007 R2 parallel, it would not be a disaster to just delete all downtime history older than for example one month or even one week... Just let me know what you think is most easy to implement.

[abrist]

We should be able to find some way to either suppress the comments or just bulk delete them. I will see what I can dig up tomorrow.

[WillemDH]

I still have this issue. Some service take more than 30 seconds to open, as the recurring downtime is still creating lots of comments. Any update on how I should clean this up?

[westernuniv]

If you are looking to remove all comments, I had luck with the following:

http://exchange.nagios.org/directory/Ad ... Ex/details

Important to note that this will remove ALL comments - not just ones as a result of the scheduled downtime. It is a fairly basic script so you could modify it to be more selective on what comments to delete.

[lmiltchev]

This script would work fine in Nagios Core. In XI, however, if you have comments in the database, after Applying Configuration they will reappear.

[westernuniv]

Right.... I guess my memory is a bit more fuzzy that I thought. Removing the scheduled downtimes in XI, the comments were removed from the DB.