Nagios Support Forum

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

wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker Cor

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

Page 1 of 3

wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker Cor

Posted: Thu Feb 06, 2020 9:16 am
by ITOMB_IMT
Hi,

I am currently on Nagios XI 5.6.10, Yesterday i received a lot of recovery alerts from NagiosXI, for which i didn't receive any critical alerts.
when i run reports by host on Notifications i see both critical and recovery alerts alerts were sent.

FYI, I have database offloaded to a remote server.
When i check event log i see a lot of these errors,
wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker Core Worker 26873 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33711 from worker Core Worker 26873 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33715 from worker Core Worker 26873 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33713 from worker Core Worker 26880 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33712 from worker Core Worker 26880 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33710 from worker Core Worker 26880 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33694 from worker Core Worker 26878 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL HOST EVENTHANDLER job 33709 from worker Core Worker 26878 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33694 from worker Core Worker 26877 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33715 from worker Core Worker 26875 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33712 from worker Core Worker 26876 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker Core Worker 26881 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33711 from worker Core Worker 26875 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33713 from worker Core Worker 26882 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33711 from worker Core Worker 26882 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33701 from worker Core Worker 26882 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33711 from worker Core Worker 26883 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33715 from worker Core Worker 26883 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker Core Worker 26883 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33713 from worker Core Worker 26876 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33702 from worker Core Worker 26876 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33711 from worker Core Worker 26876 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33710 from worker Core Worker 26876 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33710 from worker Core Worker 26881 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33694 from worker Core Worker 26881 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: host=ssc-prd-mail-auth-046.ssa.gov; service=(none); contact=432530
Runtime Error 2020-02-05 20:52:07 wproc: NOTIFY job 33709 from worker Core Worker 26881 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33712 from worker Core Worker 26874 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33710 from worker Core Worker 26874 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33712 from worker Core Worker 26879 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker Core Worker 26884 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: host=ssc-prd-mail-auth-046.ssa.gov; service=(none); contact=emsb_dl
Runtime Error 2020-02-05 20:52:07 wproc: NOTIFY job 33709 from worker Core Worker 26884 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
Runtime Error 2020-02-05 20:52:07 wproc: GLOBAL SERVICE EVENTHANDLER job 33715 from worker Core Worker 26877 is a non-check helper but exited with return code 1
Runtime Error 2020-02-05 20:52:07 wproc: stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
Runtime Error 2020-02-05 20:52:07 wproc: early_timeout=0; exited_ok=1; wait_status=256; error_code=0;

Any idea on what these errors are, wproc: GLOBAL SERVICE EVENTHANDLER job * from worker Core Worker 26877 is a non-check helper but exited with return code 1

Thanks,

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Thu Feb 06, 2020 3:48 pm
by benjaminsmith
Hello,

Thanks for posting the event log. Can you fetch the database log from the offloaded server and post it to the thread ( /var/log/mariadb/mariadb.log or /var/log/mysqld.log )?

Also, run the following command from the shell and post the output. Thanks.

Code: Select all

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 -uroot -pnagiosxi --table

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Thu Feb 06, 2020 4:19 pm
by ITOMB_IMT
# 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 -uroot -proot --table
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.20 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 232.05 |
| nagios_comments | 0.09 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.19 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.02 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 1.59 |
| nagios_contactnotifications | 1.68 |
| nagios_contacts | 0.01 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.24 |
| nagios_customvariablestatus | 0.24 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 2.00 |
| nagios_eventhandlers | 0.02 |
| nagios_externalcommands | 0.06 |
| nagios_flappinghistory | 0.21 |
| nagios_host_contactgroups | 0.01 |
| nagios_host_contacts | 0.01 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.04 |
| nagios_hostescalations | 0.02 |
| nagios_hostgroup_members | 0.02 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.07 |
| nagios_hoststatus | 0.15 |
| nagios_instances | 0.00 |
| nagios_logentries | 120.32 |
| nagios_notifications | 1.56 |
| nagios_objects | 0.69 |
| nagios_processevents | 0.42 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.00 |
| nagios_service_contacts | 0.40 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.09 |
| nagios_serviceescalation_contacts | 0.42 |
| nagios_serviceescalations | 0.22 |
| nagios_servicegroup_members | 0.01 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.86 |
| nagios_servicestatus | 2.18 |
| nagios_statehistory | 7.12 |
| nagios_systemcommands | 0.04 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.02 |
| nagios_timeperiods | 0.01 |
| tbl_command | 0.06 |
| tbl_contact | 0.03 |
| tbl_contactgroup | 0.03 |
| tbl_contacttemplate | 0.03 |
| tbl_domain | 0.03 |
| tbl_host | 0.09 |
| tbl_hostdependency | 0.03 |
| tbl_hostescalation | 0.03 |
| tbl_hostextinfo | 0.03 |
| tbl_hostgroup | 0.03 |
| tbl_hosttemplate | 0.03 |
| tbl_info | 0.17 |
| tbl_lnkContactToCommandHost | 0.02 |
| tbl_lnkContactToCommandService | 0.02 |
| tbl_lnkContactToContactgroup | 0.02 |
| tbl_lnkContactToContacttemplate | 0.02 |
| tbl_lnkContactToVariabledefinition | 0.02 |
| tbl_lnkContactgroupToContact | 0.02 |
| tbl_lnkContactgroupToContactgroup | 0.02 |
| tbl_lnkContacttemplateToCommandHost | 0.02 |
| tbl_lnkContacttemplateToCommandService | 0.02 |
| tbl_lnkContacttemplateToContactgroup | 0.02 |
| tbl_lnkContacttemplateToContacttemplate | 0.02 |
| tbl_lnkContacttemplateToVariabledefinition | 0.02 |
| tbl_lnkHostToContact | 0.02 |
| tbl_lnkHostToContactgroup | 0.02 |
| tbl_lnkHostToHost | 0.02 |
| tbl_lnkHostToHostgroup | 0.02 |
| tbl_lnkHostToHosttemplate | 0.02 |
| tbl_lnkHostToVariabledefinition | 0.02 |
| tbl_lnkHostdependencyToHost_DH | 0.02 |
| tbl_lnkHostdependencyToHost_H | 0.02 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.02 |
| tbl_lnkHostdependencyToHostgroup_H | 0.02 |
| tbl_lnkHostescalationToContact | 0.02 |
| tbl_lnkHostescalationToContactgroup | 0.02 |
| tbl_lnkHostescalationToHost | 0.02 |
| tbl_lnkHostescalationToHostgroup | 0.02 |
| tbl_lnkHostgroupToHost | 0.02 |
| tbl_lnkHostgroupToHostgroup | 0.02 |
| tbl_lnkHosttemplateToContact | 0.02 |
| tbl_lnkHosttemplateToContactgroup | 0.02 |
| tbl_lnkHosttemplateToHost | 0.02 |
| tbl_lnkHosttemplateToHostgroup | 0.02 |
| tbl_lnkHosttemplateToHosttemplate | 0.02 |
| tbl_lnkHosttemplateToVariabledefinition | 0.02 |
| tbl_lnkServiceToContact | 0.09 |
| tbl_lnkServiceToContactgroup | 0.02 |
| tbl_lnkServiceToHost | 0.16 |
| tbl_lnkServiceToHostgroup | 0.02 |
| tbl_lnkServiceToServicegroup | 0.02 |
| tbl_lnkServiceToServicetemplate | 0.06 |
| tbl_lnkServiceToVariabledefinition | 0.06 |
| tbl_lnkServicedependencyToHost_DH | 0.02 |
| tbl_lnkServicedependencyToHost_H | 0.02 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.02 |
| tbl_lnkServicedependencyToHostgroup_H | 0.02 |
| tbl_lnkServicedependencyToService_DS | 0.02 |
| tbl_lnkServicedependencyToService_S | 0.02 |
| tbl_lnkServicedependencyToServicegroup_DS | 0.02 |
| tbl_lnkServicedependencyToServicegroup_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.02 |
| tbl_lnkServiceescalationToContactgroup | 0.02 |
| tbl_lnkServiceescalationToHost | 0.11 |
| tbl_lnkServiceescalationToHostgroup | 0.02 |
| tbl_lnkServiceescalationToService | 0.02 |
| tbl_lnkServiceescalationToServicegroup | 0.02 |
| tbl_lnkServicegroupToService | 0.02 |
| tbl_lnkServicegroupToServicegroup | 0.02 |
| tbl_lnkServicetemplateToContact | 0.02 |
| tbl_lnkServicetemplateToContactgroup | 0.02 |
| tbl_lnkServicetemplateToHost | 0.02 |
| tbl_lnkServicetemplateToHostgroup | 0.02 |
| tbl_lnkServicetemplateToServicegroup | 0.02 |
| tbl_lnkServicetemplateToServicetemplate | 0.02 |
| tbl_lnkServicetemplateToVariabledefinition | 0.02 |
| tbl_lnkTimeperiodToTimeperiod | 0.02 |
| tbl_logbook | 0.02 |
| tbl_mainmenu | 0.02 |
| tbl_permission | 0.28 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 0.27 |
| tbl_servicedependency | 0.03 |
| tbl_serviceescalation | 0.03 |
| tbl_serviceextinfo | 0.03 |
| tbl_servicegroup | 0.03 |
| tbl_servicetemplate | 0.03 |
| tbl_session | 0.02 |
| tbl_session_locks | 0.02 |
| tbl_settings | 0.03 |
| tbl_submenu | 0.02 |
| tbl_timedefinition | 0.05 |
| tbl_timeperiod | 0.03 |
| tbl_user | 0.03 |
| tbl_variabledefinition | 0.09 |
| xi_auditlog | 3.81 |
| xi_auth_tokens | 1.61 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.02 |
| xi_eventqueue | 0.03 |
| xi_events | 0.05 |
| xi_incidents | 0.02 |
| xi_meta | 0.47 |
| xi_mibs | 0.05 |
| xi_options | 0.03 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.03 |
| xi_usermeta | 1.55 |
| xi_users | 0.03 |
+--------------------------------------------+------------+

Also i sent mariadb.log in PM, please see PM. Please let me know if you need more information

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Thu Feb 06, 2020 5:16 pm
by benjaminsmith
Hi,

Thanks for sending over the log. There some InnoDB issues with several tables. Log into the shell on the XI server as root and run the following command and let us know if the issue is resolved.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Thu Feb 06, 2020 5:45 pm
by ITOMB_IMT
please see attachment with results of repair_databases.sh

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Fri Feb 07, 2020 12:10 pm
by benjaminsmith
Hello @ISSB_MAOST,

The database tables look good. We'll have to review the nagios configs and logs to further troubleshoot. What is the exact name of the host or service sending out the recovery alerts?

Please send over the system profile and the notification report for the host. Thanks.

To send us your system profile.
Login to the Nagios XI GUI using a web browser
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share this in a private message and then reply to this post to bring it up in the queue.

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Fri Feb 07, 2020 12:33 pm
by ITOMB_IMT
There are multiple hosts, which user didn't receive critical alerts but only recovery alerts. i have sent you PM with the profile and notifications report

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Fri Feb 07, 2020 3:46 pm
by benjaminsmith
Hello,

Thanks for sending the files over.There numerous services to getting check results with the following error.
NRPE: Command 'check_disk' not defined
The check commands are not defined in the nrpe.cfg configuration file on the remote host or the nrpe service was not restarted after making changes.

Can you upload the nrpe.cfg on these systems? If they are using the same commands, the one configuration file will work. Here's a guide that explains the check commands in NRPE and how to pass arguments in the check commands in Nagios XI.

NRPE - Configuring NRPE Commands To Accept Arguments

Also, once making any corrections, test the check command from the command-line in Nagios XI to make sure it is working as expected.

Nagios XI - How To Test Check Commands From The Command-line

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Mon Feb 10, 2020 12:01 pm
by ITOMB_IMT
Please see PM.

Re: wproc: GLOBAL SERVICE EVENTHANDLER job 33714 from worker

Posted: Mon Feb 10, 2020 5:33 pm
by benjaminsmith
Hello,

I just replied to your PM.
All times are UTC-05:00
Page 1 of 3

Powered by phpBB® Forum Software © phpBB Limited