Support for Nagios products and services
https://support.nagios.com/forum/
mguthrie wrote:This could be completely unrelated, but can you set your PHP timezone just to rule that out as a possibility.
FAQ is for an unrelated issue, but it has the instructions for setting the timezone.
http://support.nagios.com/wiki/index.ph ... e.22_Error
What versions of mysql are you guys running?Code: Select all
yum list installed | grep mysql
mguthrie wrote:Would you guys be willing to test a fix for this?
Make a backup and replace the following file with the attached file that is zipped.
/usr/local/nagiosxi/html/includes/utils-xmlreports.inc.php
Code: Select all
php /usr/local/nagiosxi/cron/dbmaint.phpCode: Select all
[root@ceeprgpmon01 ~]# php /usr/local/nagiosxi/cron/dbmaint.php
CREATING: /usr/local/nagiosxi/var/dbmaint.lock
CLEANING ndoutils TABLE 'commenthistory'...
SQL: DELETE FROM nagios_commenthistory WHERE entry_time < FROM_UNIXTIME(1318141372)
CLEANING ndoutils TABLE 'processevents'...
SQL: DELETE FROM nagios_processevents WHERE event_time < FROM_UNIXTIME(1318141372)
CLEANING ndoutils TABLE 'externalcommands'...
SQL: DELETE FROM nagios_externalcommands WHERE entry_time < FROM_UNIXTIME(1349072572)
CLEANING ndoutils TABLE 'logentries'...
SQL: DELETE FROM nagios_logentries WHERE logentry_time < FROM_UNIXTIME(1341901372)
CLEANING ndoutils TABLE 'notifications'...
SQL: DELETE FROM nagios_notifications WHERE start_time < FROM_UNIXTIME(1341901372)
CLEANING ndoutils TABLE 'contactnotifications'...
SQL: DELETE FROM nagios_contactnotifications WHERE start_time < FROM_UNIXTIME(1341901372)
CLEANING ndoutils TABLE 'contactnotificationmethods'...
SQL: DELETE FROM nagios_contactnotificationmethods WHERE start_time < FROM_UNIXTIME(1341901372)
CLEANING ndoutils TABLE 'statehistory'...
SQL: DELETE FROM nagios_statehistory WHERE state_time < FROM_UNIXTIME(1286605372)
CLEANING ndoutils TABLE 'timedevents'...
SQL: DELETE FROM nagios_timedevents WHERE event_time < FROM_UNIXTIME(1349677072)
CLEANING ndoutils TABLE 'systemcommands'...
SQL: DELETE FROM nagios_systemcommands WHERE start_time < FROM_UNIXTIME(1349677072)
CLEANING ndoutils TABLE 'servicechecks'...
SQL: DELETE FROM nagios_servicechecks WHERE start_time < FROM_UNIXTIME(1349677072)
CLEANING ndoutils TABLE 'hostchecks'...
SQL: DELETE FROM nagios_hostchecks WHERE start_time < FROM_UNIXTIME(1349677072)
CLEANING ndoutils TABLE 'eventhandlers'...
SQL: DELETE FROM nagios_eventhandlers WHERE start_time < FROM_UNIXTIME(1349677072)
LASTOPT: 1349675401
INTERVAL: 60
NOW: 1349677372
OPTTIME: 1349679001
CLEANING nagiosxi TABLE 'commands'...
SQL: DELETE FROM xi_commands WHERE processing_time < 1349648572::abstime::timestamp without time zone
CLEANING nagiosxi TABLE 'events'...
SQL: DELETE FROM xi_events WHERE processing_time < 1349648572::abstime::timestamp without time zone
SQL1: SELECT xi_meta.meta_id FROM xi_meta LEFT JOIN xi_events ON xi_meta.metaobj_id=xi_events.event_id WHERE metatype_id='1' AND event_id IS NULL
SQL2: DELETE FROM xi_meta WHERE meta_id IN (SELECT xi_meta.meta_id FROM xi_meta LEFT JOIN xi_events ON xi_meta.metaobj_id=xi_events.event_id WHERE metatype_id='1' AND event_id IS NULL)
CLEANING nagiosxi TABLE 'auditlog'...
SQL: DELETE FROM xi_auditlog WHERE log_time < 1347085372::abstime::timestamp without time zone
CLEANING nagiosql TABLE 'logbook'...
SQL: DELETE FROM tbl_logbook WHERE time < FROM_UNIXTIME(1349648572)
Repair Complete: Removing Lock File
mguthrie wrote:Can you post the output you get from running the following script:Code: Select all
php /usr/local/nagiosxi/cron/dbmaint.php
Code: Select all
mysql -pnagiosxi nagios
select count(*) from nagios_notifications;
exitmguthrie wrote:In your Admin->Performance Settings->Database(Tab), how long are you keeping notifications?
So far we haven't been able to recreate this. Can you run the following from your terminal and let us know how many notifications are stored in the backend?
Code: Select all
mysql -pnagiosxi nagios select count(*) from nagios_notifications; exit
mguthrie wrote:Ok, that's a substantial amount of notifications to sift through since that query does multiple joins and groupings. I'm betting that's the issue there, so we may need to do some optimization on that query. I might also recommend tuning down how long ndoutils keeps those notifications, to maybe 30 days instead of 90. A much better suggestion would be to look at at what is causing that many notifications, if they're just getting sent to nowhere or getting ignored, I would really recommend re-examining what is done with those. With almost 900 notifications going out per day, that's a lot of extra work for a Nagios server to do if those alerts are going unread. However, if those are legitimate alerts and people are reading and responding to them, then I would just recommend tuning the backend so it doesn't store them as long.