Availability reports not loading

[hales8181]

We are seeing an issue with loading availability reports. When trying to load reports, the page is hanging and makes the whole Nagios XI server hang and occasionally causing a message to appear that the database needs repairing.

We have tried repairing the database (this allows us to then access Nagios), and updated to 5.7.2, but we still have the same issue.

We have found that the size of the archive files in /usr/local/nagios/var/archives has changed - until the 28th of August, the were generally under 500kb in size for each day, whereas since then they're anything from 20mb to 50mb, so we are assuming that this is the cause of the issue as the reports are trying to parse these larger files.

We need to resolve the issue, but we also need to keep the availability reports as we need to provide reporting to our clients.

Thanks

[hales8181]

Looking at the differences in the archive files, what I'm seeing is that in the smaller log files:
[1598405727] ndomod: Shutdown complete.
[1598405727] Event broker module '/usr/local/nagios/bin/ndomod.o' deinitialized successfully.
[1598405728] Nagios 4.4.5 starting... (PID=15282)
[1598405728] Local time is Wed Aug 26 01:35:28 GMT 2020
[1598405728] LOG VERSION: 2.0

This is happening every hour,
in the newer, much larger files, this seems to be happening every 20 seconds or so...I am unsure what has changed, but we need to try and figure out how to set it back and also to trim these entries out of the log files if they're not used for reporting to allow for the availabilty reports to be generated.

[hales8181]

I figured out the cause of this I think, we had a process that was applying configuration too frequently. I've stopped this from happening for now.

I do still have a problem in that I need to load availability reports, but due to this chunk of files that are too large, they're not loading. Is there a safe way of removing the line items that are causing the bloat?

[lmiltchev]

[1598405727] ndomod: Shutdown complete.
[1598405727] Event broker module '/usr/local/nagios/bin/ndomod.o' deinitialized successfully.
[1598405728] Nagios 4.4.5 starting... (PID=15282)
[1598405728] Local time is Wed Aug 26 01:35:28 GMT 2020
[1598405728] LOG VERSION: 2.0

Did you downgrade NDO? Can you PM me your latest profile?

Admin > System Profile > Download Profile

Running the availability report on a large system can take a very long time, especially if you are selecting a large timeperiod. You need to make sure that the page won't time out. I would recommend that you increase the resource limits in the php.ini file as much as needed. Read more on the topic here:

https://support.nagios.com/kb/article/n ... e-611.html