Nagios Support Forum

Hello Experts,

Lately we have been facing issues with Nagios XI Database Maintenance getting into stale state quite frequently.

Please find below inforamtion in dbmaint.log

tail dbmaint.log
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 < 1478071801::abstime::timestamp without time zone
CLEANING nagiosql TABLE 'logbook'...
SQL: DELETE FROM tbl_logbook WHERE time < FROM_UNIXTIME(1480635001)

Repair Complete: Removing Lock File


Also i see dbmaint.lock_old still under /usr/local/nagiosxi/var

More information :
Linux Distribution and version? Red Hat Enterprise Linux Server release 6.7 (Santiago)
32 or 64bit? 64bit
VMware Image or Manual Install of XI? Manual
Are there special configurations on your system ? No

Looking forward for help in finding the cause of this.

TIA
Prajul

Can you login to the XI server as root, run the following commands and post the output?