Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

Database Maintenance (dbmaint) stale (430 seconds old)

https://support.nagios.com/forum/viewtopic.php?t=63416

Page 1 of 1

Database Maintenance (dbmaint) stale (430 seconds old)

Posted: Sat Sep 04, 2021 3:00 pm
by dflick
[root@pbrpc-midland-netmon-pri ~]# time /usr/bin/php -q /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(1567713231)
CLEANING ndoutils TABLE 'processevents'...
SQL: DELETE FROM nagios_processevents WHERE event_time < FROM_UNIXTIME(1599249231)
CLEANING ndoutils TABLE 'externalcommands'...
SQL: DELETE FROM nagios_externalcommands WHERE entry_time < FROM_UNIXTIME(1630180431)
CLEANING ndoutils TABLE 'logentries'...
SQL: DELETE FROM nagios_logentries WHERE logentry_time < FROM_UNIXTIME(1623009231)
CLEANING ndoutils TABLE 'notifications'...
SQL: DELETE FROM nagios_notifications WHERE start_time < FROM_UNIXTIME(1623009231)
CLEANING ndoutils TABLE 'contactnotifications'...
SQL: DELETE FROM nagios_contactnotifications WHERE start_time < FROM_UNIXTIME(1623009231)
CLEANING ndoutils TABLE 'contactnotificationmethods'...
SQL: DELETE FROM nagios_contactnotificationmethods WHERE start_time < FROM_UNIXTIME(1623009231)
CLEANING ndoutils TABLE 'statehistory'...
SQL: DELETE FROM nagios_statehistory WHERE state_time < FROM_UNIXTIME(1567713231)
CLEANING ndoutils TABLE 'timedevents'...
SQL: DELETE FROM nagios_timedevents WHERE event_time < FROM_UNIXTIME(1630784931)
CLEANING ndoutils TABLE 'systemcommands'...
SQL: DELETE FROM nagios_systemcommands WHERE start_time < FROM_UNIXTIME(1630784931)
CLEANING ndoutils TABLE 'servicechecks'...
SQL: DELETE FROM nagios_servicechecks WHERE start_time < FROM_UNIXTIME(1630784931)
CLEANING ndoutils TABLE 'hostchecks'...
SQL: DELETE FROM nagios_hostchecks WHERE start_time < FROM_UNIXTIME(1630784931)
CLEANING ndoutils TABLE 'eventhandlers'...
SQL: DELETE FROM nagios_eventhandlers WHERE start_time < FROM_UNIXTIME(1630784931)
LASTOPT: 1630783802
INTERVAL: 60
NOW: 1630785231
OPTTIME: 1630787402
CLEANING nagiosxi TABLE 'commands'...
SQL: DELETE FROM xi_commands WHERE processing_time < FROM_UNIXTIME(1630756431) AND status_code = 2
CLEANING nagiosxi TABLE 'events'...
SQL: DELETE FROM xi_events WHERE processing_time < FROM_UNIXTIME(1630756431) AND status_code = 2
CLEANING nagiosxi TABLE 'auth_tokens'...
SQL: DELETE FROM xi_auth_tokens WHERE auth_valid_until < FROM_UNIXTIME(1630698831)
CLEANING nagiosxi TABLE 'cmp_trapdata_log'...
SQL: DELETE FROM xi_cmp_trapdata_log WHERE trapdata_log_datetime < FROM_UNIXTIME(1623009231)
CLEANING nagiosxi TABLE 'cmp_scheduledreports_log'...
SQL: DELETE FROM xi_cmp_scheduledreports_log WHERE report_run < FROM_UNIXTIME(1599249231)
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: Deleted 0 (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 < FROM_UNIXTIME(1615233231)
CLEANING nagiosql TABLE 'logbook'...
SQL: DELETE FROM tbl_logbook WHERE time < FROM_UNIXTIME(1630756431)




Repair Complete: Removing Lock File

real 0m0.243s
user 0m0.087s
sys 0m0.025s
[root@pbrpc-midland-netmon-pri ~]# ll /usr/local/nagiosxi/var/
total 76316
drwxrwxr-x. 2 nagios nagios 66 Mar 20 09:48 certs
-rw-------. 1 nagios nagios 3067399 Sep 4 14:53 cleaner.log
-rw-r--r--. 1 nagios nagios 5822304 Apr 17 03:20 cleaner.log-20210417
-rw-------. 1 nagios nagios 31576 Aug 31 03:28 cleaner.log-20210831.gz
-rw-------. 1 nagios nagios 2111501 Sep 4 14:53 cmdsubsys.log
-rw-r--r--. 1 nagios nagios 5260810 May 22 03:06 cmdsubsys.log-20210522
-rw-------. 1 nagios nagios 79389 Aug 18 03:20 cmdsubsys.log-20210818.gz
drwsrwsr-x. 2 apache nagios 82 Apr 18 00:00 components
-rw-r--r--. 1 nagios nagios 6 Sep 4 14:53 corelog.data
-rw-r--r--. 1 nagios nagios 0 Sep 4 14:53 corelog.diff
-rw-rw-r--. 1 nagios nagios 1735 Jul 9 10:26 corelog.newobjects
-rw-------. 1 nagios nagios 3784237 Sep 4 14:50 dbmaint.log
-rw-r--r--. 1 nagios nagios 5966998 Apr 14 03:15 dbmaint.log-20210414
-rw-------. 1 nagios nagios 250600 Sep 1 03:35 dbmaint.log-20210901.gz
-rw-------. 1 nagios nagios 158175 Sep 4 14:53 deadpool.log
-rw-r--r--. 1 nagios nagios 5345198 May 28 03:26 deadpool.log-20210528
-rw-------. 1 nagios nagios 18177 Sep 3 03:43 deadpool.log-20210903.gz
-rw-------. 1 nagios nagios 528314 Sep 4 14:54 event_handler.log
-rw-r--r--. 1 nagios nagios 5387087 Apr 30 03:42 event_handler.log-20210430
-rw-------. 1 nagios nagios 84949 Sep 2 03:08 event_handler.log-20210902.gz
-rw-------. 1 nagios nagios 1260119 Sep 4 14:53 eventman.log
-rw-r--r--. 1 nagios nagios 5498833 May 14 03:47 eventman.log-20210514
-rw-------. 1 nagios nagios 138338 Aug 25 03:07 eventman.log-20210825.gz
-rw-r--r--. 1 nagios nagios 233328 Sep 4 14:53 feedproc.log
-rw-r--r--. 1 nagios nagios 69500 Aug 29 03:18 feedproc.log-20210829.gz
drwxrwxr-x. 2 nagios nagios 20 Mar 19 14:18 keys
-rw-r--r--. 1 nagios nagios 138522 Sep 3 16:53 nom.log
-rw-rw-rw-. 1 nagios nagios 0 Mar 19 14:18 NXTI_Write_Test
-rw-------. 1 nagios nagios 1570539 Sep 4 14:53 perfdataproc.log
-rw-r--r--. 1 nagios nagios 5307984 May 24 03:30 perfdataproc.log-20210524
-rw-------. 1 nagios nagios 228683 Aug 22 03:48 perfdataproc.log-20210822.gz
-rw-r--r--. 1 nagios nagios 100172 Sep 4 14:01 recurringdowntime.log
-rw-r--r--. 1 nagios nagios 1187 Aug 17 01:26 reportengine.log
-rw-r--r--. 1 nagios nagios 0 Mar 19 14:18 scheduledreporting.log
-rw-r--r--. 1 nagios nagios 0 Mar 19 14:19 snmptt_service_results.log
drwxrwxr-x. 2 nagios nagios 22 Aug 26 16:09 subsys
-rw-------. 1 nagios nagios 10011951 Sep 4 14:53 sysstat.log
-rw-r--r--. 1 nagios nagios 9826177 Mar 20 03:44 sysstat.log-20210320
-rw-------. 1 nagios nagios 694264 Sep 4 03:20 sysstat.log-20210904.gz
drwxrwxr-x. 2 nagios nagios 6 Mar 19 14:17 upgrades
-rw-r--r--. 1 nagios nagios 0 Mar 19 14:18 wkhtmltox.log
-rw-r--r--. 1 nagios nagios 7 Mar 19 14:18 xi-itype
-rw-r--r--. 1 nagios nagios 12146 Aug 23 16:15 xi-sys.cfg
-rw-r--r--. 1 nagios nagios 37 Mar 19 14:18 xi-uuid
-rw-r--r--. 1 nagios nagios 196 Aug 23 16:15 xiversion
[root@pbrpc-midland-netmon-pri ~]# systemctl status crond
● crond.service - Command Scheduler
Loaded: loaded (/usr/lib/systemd/system/crond.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2021-08-26 16:09:32 CDT; 1 weeks 1 days ago
Main PID: 1150 (crond)
Tasks: 1 (limit: 62370)
Memory: 51.7M
CGroup: /system.slice/crond.service
└─1150 /usr/sbin/crond -n

Sep 04 14:05:01 pbrpc-midland-netmon-pri CROND[2205595]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:10:01 pbrpc-midland-netmon-pri CROND[2231044]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:15:01 pbrpc-midland-netmon-pri CROND[2256412]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:20:01 pbrpc-midland-netmon-pri CROND[2281738]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:25:01 pbrpc-midland-netmon-pri CROND[2307017]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:30:01 pbrpc-midland-netmon-pri CROND[2332379]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:35:01 pbrpc-midland-netmon-pri CROND[2357491]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:40:02 pbrpc-midland-netmon-pri CROND[2383106]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:45:01 pbrpc-midland-netmon-pri CROND[2408182]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
Sep 04 14:50:01 pbrpc-midland-netmon-pri CROND[2433873]: (root) CMD (LANG=C LC_ALL=C /usr/bin/mrtg /etc/mrtg/mrtg.cfg ->
[root@pbrpc-midland-netmon-pri ~]# chage -l nagios
Last password change : Mar 19, 2021
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : 0
Maximum number of days between password change : 99999
Number of days of warning before password expires : 7
[root@pbrpc-midland-netmon-pri ~]# tail -50 /usr/local/nagiosxi/var/dbmaint.log
SQL: DELETE FROM nagios_commenthistory WHERE entry_time < FROM_UNIXTIME(1567713001)
CLEANING ndoutils TABLE 'processevents'...
SQL: DELETE FROM nagios_processevents WHERE event_time < FROM_UNIXTIME(1599249001)
CLEANING ndoutils TABLE 'externalcommands'...
SQL: DELETE FROM nagios_externalcommands WHERE entry_time < FROM_UNIXTIME(1630180201)
CLEANING ndoutils TABLE 'logentries'...
SQL: DELETE FROM nagios_logentries WHERE logentry_time < FROM_UNIXTIME(1623009001)
CLEANING ndoutils TABLE 'notifications'...
SQL: DELETE FROM nagios_notifications WHERE start_time < FROM_UNIXTIME(1623009001)
CLEANING ndoutils TABLE 'contactnotifications'...
SQL: DELETE FROM nagios_contactnotifications WHERE start_time < FROM_UNIXTIME(1623009001)
CLEANING ndoutils TABLE 'contactnotificationmethods'...
SQL: DELETE FROM nagios_contactnotificationmethods WHERE start_time < FROM_UNIXTIME(1623009001)
CLEANING ndoutils TABLE 'statehistory'...
SQL: DELETE FROM nagios_statehistory WHERE state_time < FROM_UNIXTIME(1567713001)
CLEANING ndoutils TABLE 'timedevents'...
SQL: DELETE FROM nagios_timedevents WHERE event_time < FROM_UNIXTIME(1630784701)
CLEANING ndoutils TABLE 'systemcommands'...
SQL: DELETE FROM nagios_systemcommands WHERE start_time < FROM_UNIXTIME(1630784701)
CLEANING ndoutils TABLE 'servicechecks'...
SQL: DELETE FROM nagios_servicechecks WHERE start_time < FROM_UNIXTIME(1630784701)
CLEANING ndoutils TABLE 'hostchecks'...
SQL: DELETE FROM nagios_hostchecks WHERE start_time < FROM_UNIXTIME(1630784701)
CLEANING ndoutils TABLE 'eventhandlers'...
SQL: DELETE FROM nagios_eventhandlers WHERE start_time < FROM_UNIXTIME(1630784701)
LASTOPT: 1630783802
INTERVAL: 60
NOW: 1630785001
OPTTIME: 1630787402
CLEANING nagiosxi TABLE 'commands'...
SQL: DELETE FROM xi_commands WHERE processing_time < FROM_UNIXTIME(1630756201) AND status_code = 2
CLEANING nagiosxi TABLE 'events'...
SQL: DELETE FROM xi_events WHERE processing_time < FROM_UNIXTIME(1630756201) AND status_code = 2
CLEANING nagiosxi TABLE 'auth_tokens'...
SQL: DELETE FROM xi_auth_tokens WHERE auth_valid_until < FROM_UNIXTIME(1630698601)
CLEANING nagiosxi TABLE 'cmp_trapdata_log'...
SQL: DELETE FROM xi_cmp_trapdata_log WHERE trapdata_log_datetime < FROM_UNIXTIME(1623009001)
CLEANING nagiosxi TABLE 'cmp_scheduledreports_log'...
SQL: DELETE FROM xi_cmp_scheduledreports_log WHERE report_run < FROM_UNIXTIME(1599249001)
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: Deleted 0 (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 < FROM_UNIXTIME(1615233001)
CLEANING nagiosql TABLE 'logbook'...
SQL: DELETE FROM tbl_logbook WHERE time < FROM_UNIXTIME(1630756201)




Repair Complete: Removing Lock File
[root@pbrpc-midland-netmon-pri ~]# tail -50 /var/log/cron
Sep 4 14:50:01 pbrpc-midland-netmon-pri CROND[2433883]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php >> /usr/local/nagiosxi/var/event_handler.log 2>&1)
Sep 4 14:50:01 pbrpc-midland-netmon-pri CROND[2433882]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php >> /usr/local/nagiosxi/var/eventman.log 2>&1)
Sep 4 14:50:01 pbrpc-midland-netmon-pri CROND[2433894]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/snmptt_service_results.php >> /usr/local/nagiosxi/var/snmptt_service_results.log 2>&1)
Sep 4 14:50:01 pbrpc-midland-netmon-pri CROND[2433891]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php >> /usr/local/nagiosxi/var/reportengine.log 2>&1)
Sep 4 14:50:01 pbrpc-midland-netmon-pri CROND[2433893]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php >> /usr/local/nagiosxi/var/sysstat.log 2>&1)
Sep 4 14:50:01 pbrpc-midland-netmon-pri CROND[2433897]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/nom.php >> /usr/local/nagiosxi/var/nom.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438450]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/deadpool.php >> /usr/local/nagiosxi/var/deadpool.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438451]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php >> /usr/local/nagiosxi/var/eventman.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438452]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php >> /usr/local/nagiosxi/var/perfdataproc.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438453]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php >> /usr/local/nagiosxi/var/feedproc.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438458]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/nom.php >> /usr/local/nagiosxi/var/nom.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438459]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php >> /usr/local/nagiosxi/var/event_handler.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438460]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php >> /usr/local/nagiosxi/var/sysstat.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438461]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php >> /usr/local/nagiosxi/var/cmdsubsys.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438468]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/snmptt_service_results.php >> /usr/local/nagiosxi/var/snmptt_service_results.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438466]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php >> /usr/local/nagiosxi/var/reportengine.log 2>&1)
Sep 4 14:51:01 pbrpc-midland-netmon-pri CROND[2438467]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php >> /usr/local/nagiosxi/var/cleaner.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444030]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/deadpool.php >> /usr/local/nagiosxi/var/deadpool.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444031]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/snmptt_service_results.php >> /usr/local/nagiosxi/var/snmptt_service_results.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444036]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php >> /usr/local/nagiosxi/var/feedproc.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444034]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php >> /usr/local/nagiosxi/var/event_handler.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444038]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php >> /usr/local/nagiosxi/var/reportengine.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444035]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php >> /usr/local/nagiosxi/var/cmdsubsys.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444037]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/nom.php >> /usr/local/nagiosxi/var/nom.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444046]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php >> /usr/local/nagiosxi/var/sysstat.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444045]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php >> /usr/local/nagiosxi/var/cleaner.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444047]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php >> /usr/local/nagiosxi/var/eventman.log 2>&1)
Sep 4 14:52:01 pbrpc-midland-netmon-pri CROND[2444051]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php >> /usr/local/nagiosxi/var/perfdataproc.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448695]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/nom.php >> /usr/local/nagiosxi/var/nom.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448714]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php >> /usr/local/nagiosxi/var/feedproc.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448719]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php >> /usr/local/nagiosxi/var/cleaner.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448721]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/deadpool.php >> /usr/local/nagiosxi/var/deadpool.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448725]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php >> /usr/local/nagiosxi/var/sysstat.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448724]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php >> /usr/local/nagiosxi/var/eventman.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448726]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/snmptt_service_results.php >> /usr/local/nagiosxi/var/snmptt_service_results.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448728]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php >> /usr/local/nagiosxi/var/perfdataproc.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448720]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php >> /usr/local/nagiosxi/var/event_handler.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448727]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php >> /usr/local/nagiosxi/var/reportengine.log 2>&1)
Sep 4 14:53:01 pbrpc-midland-netmon-pri CROND[2448735]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php >> /usr/local/nagiosxi/var/cmdsubsys.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454244]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php >> /usr/local/nagiosxi/var/perfdataproc.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454245]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php >> /usr/local/nagiosxi/var/feedproc.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454242]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cleaner.php >> /usr/local/nagiosxi/var/cleaner.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454243]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/deadpool.php >> /usr/local/nagiosxi/var/deadpool.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454250]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/event_handler.php >> /usr/local/nagiosxi/var/event_handler.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454251]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php >> /usr/local/nagiosxi/var/cmdsubsys.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454252]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php >> /usr/local/nagiosxi/var/reportengine.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454256]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php >> /usr/local/nagiosxi/var/eventman.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454257]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/snmptt_service_results.php >> /usr/local/nagiosxi/var/snmptt_service_results.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454249]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/nom.php >> /usr/local/nagiosxi/var/nom.log 2>&1)
Sep 4 14:54:01 pbrpc-midland-netmon-pri CROND[2454254]: (nagios) CMD (/usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php >> /usr/local/nagiosxi/var/sysstat.log 2>&1)

Re: Database Maintenance (dbmaint) stale (430 seconds old)

Posted: Tue Sep 07, 2021 2:59 pm
by ssax
Please PM me a copy of your profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.

Send the FULL output of these commands (as root):
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pnagiosxi in the first AND second commands if your DB is contained/stored on another server and/or you've changed the root mysql password

Code: Select all

mysql -h 127.0.0.1 -uroot -pnagiosxi -e 'SELECT NOW(); SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;'
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
date
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
grep "date.timezone =" /etc/php.ini
grep timezone /var/lib/pgsql/data/postgresql.conf

Re: Database Maintenance (dbmaint) stale (430 seconds old)

Posted: Tue Sep 07, 2021 3:19 pm
by jochilly
Created ticket 238352 with requested information. Will post final resolution to forum once the issue is resolved.

Re: Database Maintenance (dbmaint) stale (430 seconds old)

Posted: Tue Sep 07, 2021 5:11 pm
by benjaminsmith
Created ticket 238352 with requested information. Will post final resolution to forum once the issue is resolved.
Sounds good. We'll keep this post open.

Re: Database Maintenance (dbmaint) stale (430 seconds old)

Posted: Wed Sep 08, 2021 11:19 am
by tgriep
What I found is that the Chicago timezone file was corrupted.
/usr/share/zoneinfo/America/Chicago

It was zero bytes.

Fixed the file by reinstalling the time zone package on the server.

Code: Select all

dnf reinstall tzdata
All times are UTC-05:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited