Monitoring Windows 2016 Scheduled Tasks

[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.

[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

[lmiltchev]

Did the errors clear in the db log after running the repair script? Show the output of the following command:

Code: Select all

tail /var/log/mariadb/mariadb.log

Can you also PM me the "/usr/local/nagios/var/status.dat" file?

[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

[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

Code: Select all

systemctl stop mariadb.service

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

Code: Select all

systemctl start mariadb.service

4. Check the log again

Code: Select all

tail /var/log/mariadb/mariadb.log

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

[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 ~]#

Does it work if you test it under the CCM? -> Yes, I was always checking this way.

[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.