Page 2 of 2
Re: Monitoring Windows 2016 Scheduled Tasks
Posted: Wed Apr 15, 2020 1:08 pm
by lmiltchev
Thanks for the profile! I didn't find anything wrong with your service definition. I have a similarly defined check, which works just fine. One thing I noticed is this error in your db log:
200415 18:30:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_contactnotifications, retrying
I haven't seen this before, so I don't know what is causing it and if it even has anything to do with the issue that you are having. In any case, it wouldn't hurt to run the db repair script, just to be on the safe side:
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Can you run the following commands and show the output in code wraps?
Code: Select all
ls -laS /var/lib/mysql
du -a /var/lib/mysql/nagios | sort -n -r
du -a /var/lib/mysql/nagiosql | sort -n -r
du -a /var/lib/mysql/nagiosxi | sort -n -r
One thing you can try is going to the Core Config Manager (CCM), then going to: Tools > Config File Management, and clicking on
Delete Files,
Write Configs, and
Verify Files (in this exact order). If there are no config errors, apply configuration. If there are errors, post them on the forum.
Re: Monitoring Windows 2016 Scheduled Tasks
Posted: Thu Apr 16, 2020 2:49 am
by ClemClem
DB repair is done. Reboot.
Delete Files, Write Configs, and Verify Files ->
no errors.
Still
the same problem with the service
.
code wraps:
Code: Select all
ls -laS /var/lib/mysql
total 28744
-rw-rw----. 1 mysql mysql 18874368 Apr 16 09:45 ibdata1
-rw-rw----. 1 mysql mysql 5242880 Apr 16 09:45 ib_logfile0
-rw-rw----. 1 mysql mysql 5242880 Apr 16 09:45 ib_logfile1
-rw-rw----. 1 mysql mysql 16384 Apr 16 09:30 aria_log.00000001
drwx------. 2 mysql mysql 16384 Apr 16 09:20 nagiosql
drwx------. 2 mysql mysql 12288 Apr 16 09:30 nagios
drwxr-xr-x. 8 mysql mysql 4096 Apr 16 09:31 .
drwxr-xr-x. 36 root root 4096 Jul 8 2019 ..
drwx------. 2 mysql mysql 4096 May 15 2019 mysql
drwx------. 2 mysql mysql 4096 Apr 16 09:20 nagiosxi
drwx------. 2 mysql mysql 4096 May 15 2019 performance_schema
drwx------. 2 mysql mysql 4096 May 15 2019 test
-rw-rw----. 1 mysql mysql 52 Apr 16 09:30 aria_log_control
srwxrwxrwx 1 mysql mysql 0 Apr 16 09:31 mysql.sock
[root@localhost ~]# du -a /var/lib/mysql/nagios | sort -n -r
207592 /var/lib/mysql/nagios
69232 /var/lib/mysql/nagios/nagios_logentries.MYD
38576 /var/lib/mysql/nagios/nagios_statehistory.MYD
35492 /var/lib/mysql/nagios/nagios_logentries.MYI
15188 /var/lib/mysql/nagios/nagios_notifications.MYD
12820 /var/lib/mysql/nagios/nagios_statehistory.MYI
5248 /var/lib/mysql/nagios/nagios_notifications.MYI
5220 /var/lib/mysql/nagios/nagios_contactnotifications.TMM
4876 /var/lib/mysql/nagios/nagios_contactnotifications.MYI
3984 /var/lib/mysql/nagios/nagios_contactnotificationmethods.MYI
3828 /var/lib/mysql/nagios/nagios_contactnotificationmethods.MYD
3404 /var/lib/mysql/nagios/nagios_contactnotifications.MYD
2020 /var/lib/mysql/nagios/nagios_commenthistory.MYD
1372 /var/lib/mysql/nagios/nagios_eventhandlers.MYD
760 /var/lib/mysql/nagios/nagios_flappinghistory.MYD
740 /var/lib/mysql/nagios/nagios_servicestatus.MYD
640 /var/lib/mysql/nagios/nagios_objects.MYD
556 /var/lib/mysql/nagios/nagios_objects.MYI
528 /var/lib/mysql/nagios/nagios_servicestatus.MYI
396 /var/lib/mysql/nagios/nagios_services.MYD
228 /var/lib/mysql/nagios/nagios_processevents.MYD
192 /var/lib/mysql/nagios/nagios_commenthistory.MYI
124 /var/lib/mysql/nagios/nagios_flappinghistory.MYI
116 /var/lib/mysql/nagios/nagios_customvariablestatus.MYD
108 /var/lib/mysql/nagios/nagios_customvariables.MYI
108 /var/lib/mysql/nagios/nagios_customvariables.MYD
100 /var/lib/mysql/nagios/nagios_eventhandlers.MYI
100 /var/lib/mysql/nagios/nagios_conninfo.MYD
96 /var/lib/mysql/nagios/nagios_customvariablestatus.MYI
84 /var/lib/mysql/nagios/nagios_services.MYI
64 /var/lib/mysql/nagios/nagios_hoststatus.MYD
60 /var/lib/mysql/nagios/nagios_service_contacts.MYI
60 /var/lib/mysql/nagios/nagios_hoststatus.MYI
48 /var/lib/mysql/nagios/nagios_processevents.MYI
44 /var/lib/mysql/nagios/nagios_hosts.MYD
32 /var/lib/mysql/nagios/nagios_service_contacts.MYD
28 /var/lib/mysql/nagios/nagios_systemcommands.MYD
20 /var/lib/mysql/nagios/nagios_servicestatus.frm
20 /var/lib/mysql/nagios/nagios_hoststatus.frm
20 /var/lib/mysql/nagios/nagios_commands.MYD
16 /var/lib/mysql/nagios/nagios_systemcommands.MYI
16 /var/lib/mysql/nagios/nagios_servicegroup_members.MYI
16 /var/lib/mysql/nagios/nagios_hosts.frm
12 /var/lib/mysql/nagios/nagios_timeperiod_timeranges.frm
12 /var/lib/mysql/nagios/nagios_timeperiods.frm
12 /var/lib/mysql/nagios/nagios_timedevents.frm
12 /var/lib/mysql/nagios/nagios_timedeventqueue.frm
12 /var/lib/mysql/nagios/nagios_systemcommands.frm
12 /var/lib/mysql/nagios/nagios_statehistory.frm
12 /var/lib/mysql/nagios/nagios_services.frm
12 /var/lib/mysql/nagios/nagios_service_parentservices.frm
12 /var/lib/mysql/nagios/nagios_servicegroups.frm
12 /var/lib/mysql/nagios/nagios_servicegroup_members.frm
12 /var/lib/mysql/nagios/nagios_serviceescalations.frm
12 /var/lib/mysql/nagios/nagios_serviceescalation_contacts.frm
12 /var/lib/mysql/nagios/nagios_serviceescalation_contactgroups.frm
12 /var/lib/mysql/nagios/nagios_servicedependencies.frm
12 /var/lib/mysql/nagios/nagios_service_contacts.frm
12 /var/lib/mysql/nagios/nagios_service_contactgroups.frm
12 /var/lib/mysql/nagios/nagios_servicechecks.frm
12 /var/lib/mysql/nagios/nagios_scheduleddowntime.frm
12 /var/lib/mysql/nagios/nagios_runtimevariables.frm
12 /var/lib/mysql/nagios/nagios_programstatus.frm
12 /var/lib/mysql/nagios/nagios_processevents.frm
12 /var/lib/mysql/nagios/nagios_objects.frm
12 /var/lib/mysql/nagios/nagios_notifications.frm
12 /var/lib/mysql/nagios/nagios_logentries.frm
12 /var/lib/mysql/nagios/nagios_instances.frm
12 /var/lib/mysql/nagios/nagios_hosts.MYI
12 /var/lib/mysql/nagios/nagios_host_parenthosts.frm
12 /var/lib/mysql/nagios/nagios_hostgroups.frm
12 /var/lib/mysql/nagios/nagios_hostgroup_members.frm
12 /var/lib/mysql/nagios/nagios_hostescalations.frm
12 /var/lib/mysql/nagios/nagios_hostescalation_contacts.frm
12 /var/lib/mysql/nagios/nagios_hostescalation_contactgroups.frm
12 /var/lib/mysql/nagios/nagios_hostdependencies.frm
12 /var/lib/mysql/nagios/nagios_host_contacts.frm
12 /var/lib/mysql/nagios/nagios_host_contactgroups.frm
12 /var/lib/mysql/nagios/nagios_hostchecks.frm
12 /var/lib/mysql/nagios/nagios_flappinghistory.frm
12 /var/lib/mysql/nagios/nagios_externalcommands.frm
12 /var/lib/mysql/nagios/nagios_eventhandlers.frm
12 /var/lib/mysql/nagios/nagios_downtimehistory.frm
12 /var/lib/mysql/nagios/nagios_dbversion.frm
12 /var/lib/mysql/nagios/nagios_customvariablestatus.frm
12 /var/lib/mysql/nagios/nagios_customvariables.frm
12 /var/lib/mysql/nagios/nagios_contactstatus.frm
12 /var/lib/mysql/nagios/nagios_contacts.frm
12 /var/lib/mysql/nagios/nagios_contactnotifications.frm
12 /var/lib/mysql/nagios/nagios_contactnotificationmethods.frm
12 /var/lib/mysql/nagios/nagios_contact_notificationcommands.frm
12 /var/lib/mysql/nagios/nagios_contactgroups.frm
12 /var/lib/mysql/nagios/nagios_contactgroup_members.frm
12 /var/lib/mysql/nagios/nagios_contact_addresses.frm
12 /var/lib/mysql/nagios/nagios_conninfo.MYI
12 /var/lib/mysql/nagios/nagios_conninfo.frm
12 /var/lib/mysql/nagios/nagios_configfilevariables.MYD
12 /var/lib/mysql/nagios/nagios_configfilevariables.frm
12 /var/lib/mysql/nagios/nagios_configfiles.frm
12 /var/lib/mysql/nagios/nagios_comments.frm
12 /var/lib/mysql/nagios/nagios_commenthistory.frm
12 /var/lib/mysql/nagios/nagios_commands.frm
12 /var/lib/mysql/nagios/nagios_acknowledgements.frm
8 /var/lib/mysql/nagios/nagios_servicegroup_members.MYD
8 /var/lib/mysql/nagios/nagios_hostgroup_members.MYI
8 /var/lib/mysql/nagios/nagios_host_contacts.MYI
8 /var/lib/mysql/nagios/nagios_contact_notificationcommands.MYI
8 /var/lib/mysql/nagios/nagios_contact_notificationcommands.MYD
8 /var/lib/mysql/nagios/nagios_configfiles.MYI
8 /var/lib/mysql/nagios/nagios_commands.MYI
4 /var/lib/mysql/nagios/nagios_timeperiod_timeranges.MYI
4 /var/lib/mysql/nagios/nagios_timeperiod_timeranges.MYD
4 /var/lib/mysql/nagios/nagios_timeperiods.MYI
4 /var/lib/mysql/nagios/nagios_timeperiods.MYD
4 /var/lib/mysql/nagios/nagios_timedevents.MYI
4 /var/lib/mysql/nagios/nagios_timedeventqueue.MYI
4 /var/lib/mysql/nagios/nagios_service_parentservices.MYI
4 /var/lib/mysql/nagios/nagios_servicegroups.MYI
4 /var/lib/mysql/nagios/nagios_servicegroups.MYD
4 /var/lib/mysql/nagios/nagios_serviceescalations.MYI
4 /var/lib/mysql/nagios/nagios_serviceescalation_contacts.MYI
4 /var/lib/mysql/nagios/nagios_serviceescalation_contactgroups.MYI
4 /var/lib/mysql/nagios/nagios_servicedependencies.MYI
4 /var/lib/mysql/nagios/nagios_service_contactgroups.MYI
4 /var/lib/mysql/nagios/nagios_service_contactgroups.MYD
4 /var/lib/mysql/nagios/nagios_servicechecks.MYI
4 /var/lib/mysql/nagios/nagios_scheduleddowntime.MYI
4 /var/lib/mysql/nagios/nagios_runtimevariables.MYI
4 /var/lib/mysql/nagios/nagios_runtimevariables.MYD
4 /var/lib/mysql/nagios/nagios_programstatus.MYI
4 /var/lib/mysql/nagios/nagios_programstatus.MYD
4 /var/lib/mysql/nagios/nagios_instances.MYI
4 /var/lib/mysql/nagios/nagios_instances.MYD
4 /var/lib/mysql/nagios/nagios_host_parenthosts.MYI
4 /var/lib/mysql/nagios/nagios_host_parenthosts.MYD
4 /var/lib/mysql/nagios/nagios_hostgroups.MYI
4 /var/lib/mysql/nagios/nagios_hostgroups.MYD
4 /var/lib/mysql/nagios/nagios_hostgroup_members.MYD
4 /var/lib/mysql/nagios/nagios_hostescalations.MYI
4 /var/lib/mysql/nagios/nagios_hostescalation_contacts.MYI
4 /var/lib/mysql/nagios/nagios_hostescalation_contactgroups.MYI
4 /var/lib/mysql/nagios/nagios_hostdependencies.MYI
4 /var/lib/mysql/nagios/nagios_host_contacts.MYD
4 /var/lib/mysql/nagios/nagios_host_contactgroups.MYI
4 /var/lib/mysql/nagios/nagios_host_contactgroups.MYD
4 /var/lib/mysql/nagios/nagios_hostchecks.MYI
4 /var/lib/mysql/nagios/nagios_externalcommands.MYI
4 /var/lib/mysql/nagios/nagios_externalcommands.MYD
4 /var/lib/mysql/nagios/nagios_downtimehistory.MYI
4 /var/lib/mysql/nagios/nagios_dbversion.MYI
4 /var/lib/mysql/nagios/nagios_dbversion.MYD
4 /var/lib/mysql/nagios/nagios_contactstatus.MYI
4 /var/lib/mysql/nagios/nagios_contactstatus.MYD
4 /var/lib/mysql/nagios/nagios_contacts.MYI
4 /var/lib/mysql/nagios/nagios_contacts.MYD
4 /var/lib/mysql/nagios/nagios_contactgroups.MYI
4 /var/lib/mysql/nagios/nagios_contactgroups.MYD
4 /var/lib/mysql/nagios/nagios_contactgroup_members.MYI
4 /var/lib/mysql/nagios/nagios_contactgroup_members.MYD
4 /var/lib/mysql/nagios/nagios_contact_addresses.MYI
4 /var/lib/mysql/nagios/nagios_configfilevariables.MYI
4 /var/lib/mysql/nagios/nagios_configfiles.MYD
4 /var/lib/mysql/nagios/nagios_comments.MYI
4 /var/lib/mysql/nagios/nagios_acknowledgements.MYI
4 /var/lib/mysql/nagios/nagios_acknowledgements.MYD
4 /var/lib/mysql/nagios/db.opt
0 /var/lib/mysql/nagios/nagios_timedevents.MYD
0 /var/lib/mysql/nagios/nagios_timedeventqueue.MYD
0 /var/lib/mysql/nagios/nagios_service_parentservices.MYD
0 /var/lib/mysql/nagios/nagios_serviceescalations.MYD
0 /var/lib/mysql/nagios/nagios_serviceescalation_contacts.MYD
0 /var/lib/mysql/nagios/nagios_serviceescalation_contactgroups.MYD
0 /var/lib/mysql/nagios/nagios_servicedependencies.MYD
0 /var/lib/mysql/nagios/nagios_servicechecks.MYD
0 /var/lib/mysql/nagios/nagios_scheduleddowntime.MYD
0 /var/lib/mysql/nagios/nagios_hostescalations.MYD
0 /var/lib/mysql/nagios/nagios_hostescalation_contacts.MYD
0 /var/lib/mysql/nagios/nagios_hostescalation_contactgroups.MYD
0 /var/lib/mysql/nagios/nagios_hostdependencies.MYD
0 /var/lib/mysql/nagios/nagios_hostchecks.MYD
0 /var/lib/mysql/nagios/nagios_downtimehistory.MYD
0 /var/lib/mysql/nagios/nagios_contact_addresses.MYD
0 /var/lib/mysql/nagios/nagios_comments.MYD
[root@localhost ~]# du -a /var/lib/mysql/nagiosql | sort -n -r
23028 /var/lib/mysql/nagiosql
9220 /var/lib/mysql/nagiosql/tbl_variabledefinition.ibd
2048 /var/lib/mysql/nagiosql/tbl_service.ibd
480 /var/lib/mysql/nagiosql/tbl_lnkServiceToServicetemplate.ibd
432 /var/lib/mysql/nagiosql/tbl_lnkServiceToVariabledefinition.ibd
416 /var/lib/mysql/nagiosql/tbl_lnkServiceToContact.ibd
240 /var/lib/mysql/nagiosql/tbl_info.ibd
176 /var/lib/mysql/nagiosql/tbl_lnkServiceToHost.ibd
144 /var/lib/mysql/nagiosql/tbl_host.ibd
112 /var/lib/mysql/nagiosql/tbl_user.ibd
112 /var/lib/mysql/nagiosql/tbl_timeperiod.ibd
112 /var/lib/mysql/nagiosql/tbl_settings.ibd
112 /var/lib/mysql/nagiosql/tbl_servicetemplate.ibd
112 /var/lib/mysql/nagiosql/tbl_servicegroup.ibd
112 /var/lib/mysql/nagiosql/tbl_serviceextinfo.ibd
112 /var/lib/mysql/nagiosql/tbl_serviceescalation.ibd
112 /var/lib/mysql/nagiosql/tbl_servicedependency.ibd
112 /var/lib/mysql/nagiosql/tbl_hosttemplate.ibd
112 /var/lib/mysql/nagiosql/tbl_hostgroup.ibd
112 /var/lib/mysql/nagiosql/tbl_hostextinfo.ibd
112 /var/lib/mysql/nagiosql/tbl_hostescalation.ibd
112 /var/lib/mysql/nagiosql/tbl_hostdependency.ibd
112 /var/lib/mysql/nagiosql/tbl_domain.ibd
112 /var/lib/mysql/nagiosql/tbl_contacttemplate.ibd
112 /var/lib/mysql/nagiosql/tbl_contact.ibd
112 /var/lib/mysql/nagiosql/tbl_contactgroup.ibd
112 /var/lib/mysql/nagiosql/tbl_command.ibd
96 /var/lib/mysql/nagiosql/tbl_timedefinition.ibd
96 /var/lib/mysql/nagiosql/tbl_submenu.ibd
96 /var/lib/mysql/nagiosql/tbl_session_locks.ibd
96 /var/lib/mysql/nagiosql/tbl_session.ibd
96 /var/lib/mysql/nagiosql/tbl_permission_inactive.ibd
96 /var/lib/mysql/nagiosql/tbl_permission.ibd
96 /var/lib/mysql/nagiosql/tbl_mainmenu.ibd
96 /var/lib/mysql/nagiosql/tbl_logbook.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkTimeperiodToTimeperiod.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceToServicegroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceToHostgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToVariabledefinition.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToServicetemplate.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToServicegroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToHostgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToContact.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicegroupToService.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicegroupToServicegroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToService.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToServicegroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToHostgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToContact.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToService_S.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToServicegroup_S.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToServicegroup_DS.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToService_DS.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHost_H.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHostgroup_H.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHostgroup_DH.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHost_DH.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostToVariabledefinition.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostToHosttemplate.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostToHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostToHostgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostToContact.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToVariabledefinition.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToHosttemplate.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToHostgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToContact.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostgroupToHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostgroupToHostgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToHostgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToContact.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHost_H.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHostgroup_H.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHostgroup_DH.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHost_DH.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContactToVariabledefinition.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContactToContacttemplate.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContactToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContactToCommandService.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContactToCommandHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToVariabledefinition.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToContacttemplate.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToContactgroup.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToCommandService.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToCommandHost.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContactgroupToContact.ibd
96 /var/lib/mysql/nagiosql/tbl_lnkContactgroupToContactgroup.ibd
24 /var/lib/mysql/nagiosql/tbl_domain.frm
20 /var/lib/mysql/nagiosql/tbl_hosttemplate.frm
20 /var/lib/mysql/nagiosql/tbl_host.frm
20 /var/lib/mysql/nagiosql/tbl_hostextinfo.frm
20 /var/lib/mysql/nagiosql/tbl_contacttemplate.frm
20 /var/lib/mysql/nagiosql/tbl_contact.frm
16 /var/lib/mysql/nagiosql/tbl_servicetemplate.frm
16 /var/lib/mysql/nagiosql/tbl_servicegroup.frm
16 /var/lib/mysql/nagiosql/tbl_service.frm
16 /var/lib/mysql/nagiosql/tbl_serviceextinfo.frm
16 /var/lib/mysql/nagiosql/tbl_hostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_variabledefinition.frm
12 /var/lib/mysql/nagiosql/tbl_user.frm
12 /var/lib/mysql/nagiosql/tbl_timeperiod.frm
12 /var/lib/mysql/nagiosql/tbl_timedefinition.frm
12 /var/lib/mysql/nagiosql/tbl_submenu.frm
12 /var/lib/mysql/nagiosql/tbl_settings.frm
12 /var/lib/mysql/nagiosql/tbl_session_locks.frm
12 /var/lib/mysql/nagiosql/tbl_session.frm
12 /var/lib/mysql/nagiosql/tbl_serviceescalation.frm
12 /var/lib/mysql/nagiosql/tbl_servicedependency.frm
12 /var/lib/mysql/nagiosql/tbl_permission_inactive.frm
12 /var/lib/mysql/nagiosql/tbl_permission.frm
12 /var/lib/mysql/nagiosql/tbl_mainmenu.frm
12 /var/lib/mysql/nagiosql/tbl_logbook.frm
12 /var/lib/mysql/nagiosql/tbl_lnkTimeperiodToTimeperiod.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceToVariabledefinition.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceToServicetemplate.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceToServicegroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceToHostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceToHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceToContact.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToVariabledefinition.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToServicetemplate.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToServicegroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToHostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicetemplateToContact.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicegroupToServicegroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicegroupToService.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToServicegroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToService.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToHostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServiceescalationToContact.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToService_S.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToServicegroup_S.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToServicegroup_DS.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToService_DS.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHost_H.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHostgroup_H.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHostgroup_DH.frm
12 /var/lib/mysql/nagiosql/tbl_lnkServicedependencyToHost_DH.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostToVariabledefinition.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostToHosttemplate.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostToHostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostToHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostToContact.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToVariabledefinition.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToHosttemplate.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToHostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHosttemplateToContact.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostgroupToHostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostgroupToHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToHostgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostescalationToContact.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHost_H.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHostgroup_H.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHostgroup_DH.frm
12 /var/lib/mysql/nagiosql/tbl_lnkHostdependencyToHost_DH.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContactToVariabledefinition.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContactToContacttemplate.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContactToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContactToCommandService.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContactToCommandHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToVariabledefinition.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToContacttemplate.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToCommandService.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContacttemplateToCommandHost.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContactgroupToContactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_lnkContactgroupToContact.frm
12 /var/lib/mysql/nagiosql/tbl_info.frm
12 /var/lib/mysql/nagiosql/tbl_hostescalation.frm
12 /var/lib/mysql/nagiosql/tbl_hostdependency.frm
12 /var/lib/mysql/nagiosql/tbl_contactgroup.frm
12 /var/lib/mysql/nagiosql/tbl_command.frm
4 /var/lib/mysql/nagiosql/db.opt
[root@localhost ~]# du -a /var/lib/mysql/nagiosxi | sort -n -r^C
Re: Monitoring Windows 2016 Scheduled Tasks
Posted: Thu Apr 16, 2020 9:46 am
by lmiltchev
Did the errors clear in the db log after running the repair script? Show the output of the following command:
Can you also PM me the "/usr/local/nagios/var/status.dat" file?
Re: Monitoring Windows 2016 Scheduled Tasks
Posted: Fri Apr 17, 2020 3:56 am
by ClemClem
I think the DB is fixed. But you have still this:
Code: Select all
[root@localhost ~]# tail /var/log/mariadb/mariadb.log
200417 0:10:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 1:15:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 2:20:01 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 3:25:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 4:30:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 5:35:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 6:40:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 7:45:01 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 8:50:01 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
200417 9:55:02 [Warning] Warning: Optimize table got errno 17 on nagios.nagios_ contactnotifications, retrying
Re: Monitoring Windows 2016 Scheduled Tasks
Posted: Fri Apr 17, 2020 9:18 am
by lmiltchev
Having all these messages in the log is not normal. Let's try the following.
I think the DB is fixed. But you have still this:...
1. Stop mariadb
2. Move the "nagios_contactnotifications.TMM" file to the /tmp directory
Code: Select all
mv /var/lib/mysql/nagios/nagios_contactnotifications.TMM /tmp
3. Start mariadb
4. Check the log again
Note: After starting mariadb, you may need to rerun:
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
I looked through the status.dat but didn't see any issues. The service is configured correctly - not sure why you would have:
Code: Select all
plugin_output=Unknown command(s): check_tasksched
You said the command was working when you run it from the command line, correct? Does it work if you test it under the CCM?
CCM > Services > Check Task get_eurofxref > Run Check Command > Run Check Command
Re: Monitoring Windows 2016 Scheduled Tasks
Posted: Tue Apr 21, 2020 2:51 am
by ClemClem
Hello, result:
Code: Select all
/var/log/mariadb/mariadb.log
200421 9:48:01 InnoDB: Initializing buffer pool, size = 128.0M
200421 9:48:01 InnoDB: Completed initialization of buffer pool
200421 9:48:01 InnoDB: highest supported file format is Barracuda.
200421 9:48:01 InnoDB: Waiting for the background threads to start
200421 9:48:02 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 3897718267893
200421 9:48:02 [Note] Plugin 'FEEDBACK' is disabled.
200421 9:48:02 [Note] Server socket created on IP: '0.0.0.0'.
200421 9:48:02 [Note] Event Scheduler: Loaded 0 events
200421 9:48:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.64-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
[root@localhost ~]#
->
Yes, I was always checking this way.
Re: Monitoring Windows 2016 Scheduled Tasks
Posted: Tue Apr 21, 2020 9:10 am
by lmiltchev
Since your db errors have been fixed, and your check works when run from the command line, let's try running the "Config File Management" tool one more time:
CCM > Tools > Config File Management > Delete Files > Write Configs > Verify Files > Apply Configuration
Next, go to
Home > Service Status, click on your service, then click on the "Force an immediate check" and see if you would get the expected output.
If the issue is still present, please open a support ticket via our support center here:
https://support.nagios.com/tickets/. We may need to schedule a remote sessions to further troubleshoot this issue.