ndo2db: Error: mysql_query() failed

[Pselvin]

Hi Team,

We are getting MYSQL error on each event which is being generated by Nagios. Alerts are gettings triggered but, it is not being processed by DB. Please check the below message and advise.

NagiosXI Version - Installed Version: 5.6.9

Code: Select all

Mar 18 03:34:43 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase Service Check;CRITICAL;SOFT;1;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:34:43 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584516882), entry_time=FROM_UNIXTIME(1584516882), entry_time_usec='910481', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;SOFT;1;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:34:43 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584516883), entry_time=FROM_UNIXTIME(1584516883), entry_time_usec='18089', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase Service Check;CRITICAL;SOFT;1;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:35:40 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;CRITICAL;SOFT;2;Alert : CRITICAL  paste -s /tmp/critcal_output.out
Mar 18 03:35:40 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584516940), entry_time=FROM_UNIXTIME(1584516940), entry_time_usec='479413', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;SOFT;2;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:35:40 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase Service Check;OK;SOFT;2;couchbase-server: 2
Mar 18 03:35:40 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584516940), entry_time=FROM_UNIXTIME(1584516940), entry_time_usec='592383', logentry_type='8192', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase Service Check;OK;SOFT;2;couchbase-server: 2', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:36:33 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;SOFT;1;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:36:33 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584516993), entry_time=FROM_UNIXTIME(1584516993), entry_time_usec='2560', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;SOFT;1;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:36:38 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;CRITICAL;SOFT;3;Alert : CRITICAL  paste -s /tmp/critcal_output.out
Mar 18 03:36:38 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584516998), entry_time=FROM_UNIXTIME(1584516998), entry_time_usec='995238', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;SOFT;3;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:37:31 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;SOFT;2;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:37:31 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517051), entry_time=FROM_UNIXTIME(1584517051), entry_time_usec='904298', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;SOFT;2;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:37:37 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;CRITICAL;SOFT;4;Alert : CRITICAL  paste -s /tmp/critcal_output.out
Mar 18 03:37:37 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517057), entry_time=FROM_UNIXTIME(1584517057), entry_time_usec='912336', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;SOFT;4;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:38:30 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;SOFT;3;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:38:30 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517110), entry_time=FROM_UNIXTIME(1584517110), entry_time_usec='623000', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;SOFT;3;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:38:36 wsvmlnngp01 nagios: SERVICE NOTIFICATION: DB Team;wsvmlncbp07.ec.lowes.com;CouchBase File System Check;CRITICAL;xi_service_notification_handler;Alert : CRITICAL  paste -s /tmp/critcal_output.out
Mar 18 03:38:36 wsvmlnngp01 nagios: SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07.ec.lowes.com;CouchBase File System Check;CRITICAL;notify-service-by-email;Alert : CRITICAL  paste -s /tmp/critcal_output.out
Mar 18 03:38:36 wsvmlnngp01 nagios: SERVICE NOTIFICATION: rdevegow;wsvmlncbp07.ec.lowes.com;CouchBase File System Check;CRITICAL;xi_service_notification_handler;Alert : CRITICAL  paste -s /tmp/critcal_output.out
Mar 18 03:38:36 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;CRITICAL;HARD;5;Alert : CRITICAL  paste -s /tmp/critcal_output.out
Mar 18 03:38:36 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517116), entry_time=FROM_UNIXTIME(1584517116), entry_time_usec='716355', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: DB Team;wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;xi_service_notification_handler;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:38:36 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517116), entry_time=FROM_UNIXTIME(1584517116), entry_time_usec='716446', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;notify-service-by-email;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:38:36 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517116), entry_time=FROM_UNIXTIME(1584517116), entry_time_usec='716544', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: rdevegow;wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;xi_service_notification_handler;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:38:36 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517116), entry_time=FROM_UNIXTIME(1584517116), entry_time_usec='716621', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;CRITICAL;HARD;5;Alert : CRITICAL  paste -s /tmp/critcal_output\.out', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:39:15 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;SOFT;1;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:39:15 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517155), entry_time=FROM_UNIXTIME(1584517155), entry_time_usec='507232', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;SOFT;1;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:39:29 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;SOFT;4;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:39:29 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517169), entry_time=FROM_UNIXTIME(1584517169), entry_time_usec='233475', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;SOFT;4;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:40:27 wsvmlnngp01 nagios: SERVICE NOTIFICATION: DB Team;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:40:27 wsvmlnngp01 nagios: SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;notify-service-by-email;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:40:27 wsvmlnngp01 nagios: SERVICE NOTIFICATION: rdevegow;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:40:27 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;HARD;5;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 03:40:27 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517227), entry_time=FROM_UNIXTIME(1584517227), entry_time_usec='952863', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: DB Team;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:40:27 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517227), entry_time=FROM_UNIXTIME(1584517227), entry_time_usec='952947', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;notify-service-by-email;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:40:27 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517227), entry_time=FROM_UNIXTIME(1584517227), entry_time_usec='953049', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: rdevegow;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:40:27 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517227), entry_time=FROM_UNIXTIME(1584517227), entry_time_usec='953128', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;HARD;5;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:40:44 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;SOFT;2;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:40:44 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517244), entry_time=FROM_UNIXTIME(1584517244), entry_time_usec='25074', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;SOFT;2;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:42:12 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;SOFT;3;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:42:13 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517332), entry_time=FROM_UNIXTIME(1584517332), entry_time_usec='119734', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;SOFT;3;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:43:40 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;SOFT;4;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:43:40 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517420), entry_time=FROM_UNIXTIME(1584517420), entry_time_usec='998054', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;SOFT;4;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:45:09 wsvmlnngp01 nagios: SERVICE NOTIFICATION: DB Team;wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;xi_service_notification_handler;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:45:09 wsvmlnngp01 nagios: SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;notify-service-by-email;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:45:09 wsvmlnngp01 nagios: SERVICE NOTIFICATION: rdevegow;wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;xi_service_notification_handler;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:45:09 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;CRITICAL;HARD;5;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds.
Mar 18 03:45:09 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517509), entry_time=FROM_UNIXTIME(1584517509), entry_time_usec='445028', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: DB Team;wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;xi_service_notification_handler;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:45:09 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517509), entry_time=FROM_UNIXTIME(1584517509), entry_time_usec='445111', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;notify-service-by-email;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:45:09 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517509), entry_time=FROM_UNIXTIME(1584517509), entry_time_usec='445202', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: rdevegow;wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;xi_service_notification_handler;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 03:45:09 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584517509), entry_time=FROM_UNIXTIME(1584517509), entry_time_usec='445281', logentry_type='65536', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;CRITICAL;HARD;5;CHECK_NRPE STATE CRITICAL: Socket timeout after 30 seconds\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:03:30 wsvmlnngp01 nagios: SERVICE NOTIFICATION: DB Team;wsvmlncbp07.ec.lowes.com;CouchBase File System Check;OK;xi_service_notification_handler;ALL DISK OK
Mar 18 04:03:30 wsvmlnngp01 nagios: SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07.ec.lowes.com;CouchBase File System Check;OK;notify-service-by-email;ALL DISK OK
Mar 18 04:03:30 wsvmlnngp01 nagios: SERVICE NOTIFICATION: rdevegow;wsvmlncbp07.ec.lowes.com;CouchBase File System Check;OK;xi_service_notification_handler;ALL DISK OK
Mar 18 04:03:30 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;OK;HARD;5;ALL DISK OK
Mar 18 04:03:30 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584518610), entry_time=FROM_UNIXTIME(1584518610), entry_time_usec='916486', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: DB Team;wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;OK;xi_service_notification_handler;ALL DISK OK', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:03:30 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584518610), entry_time=FROM_UNIXTIME(1584518610), entry_time_usec='916577', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;OK;notify-service-by-email;ALL DISK OK', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:03:30 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584518610), entry_time=FROM_UNIXTIME(1584518610), entry_time_usec='916665', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: rdevegow;wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;OK;xi_service_notification_handler;ALL DISK OK', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:03:30 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584518610), entry_time=FROM_UNIXTIME(1584518610), entry_time_usec='916738', logentry_type='8192', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;OK;HARD;5;ALL DISK OK', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:15:17 wsvmlnngp01 nagios: SERVICE NOTIFICATION: DB Team;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 04:15:17 wsvmlnngp01 nagios: SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;notify-service-by-email;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 04:15:17 wsvmlnngp01 nagios: SERVICE NOTIFICATION: rdevegow;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07.ec.lowes.com and port 8089: Connection refused
Mar 18 04:15:17 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584519317), entry_time=FROM_UNIXTIME(1584519317), entry_time_usec='973701', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: DB Team;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:15:17 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584519317), entry_time=FROM_UNIXTIME(1584519317), entry_time_usec='973823', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;notify-service-by-email;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:15:17 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584519317), entry_time=FROM_UNIXTIME(1584519317), entry_time_usec='973916', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: rdevegow;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address wsvmlncbp07\.ec\.lowes\.com and port 8089: Connection refused', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:19:59 wsvmlnngp01 nagios: SERVICE NOTIFICATION: DB Team;wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;OK;xi_service_notification_handler;OK: CPU Idle = 76.28%
Mar 18 04:19:59 wsvmlnngp01 nagios: SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;OK;notify-service-by-email;OK: CPU Idle = 76.28%
Mar 18 04:19:59 wsvmlnngp01 nagios: SERVICE NOTIFICATION: rdevegow;wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;OK;xi_service_notification_handler;OK: CPU Idle = 76.28%
Mar 18 04:19:59 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;Check Server CPU Status - Linux;OK;HARD;5;OK: CPU Idle = 76.28%
Mar 18 04:19:59 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584519599), entry_time=FROM_UNIXTIME(1584519599), entry_time_usec='807501', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: DB Team;wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;OK;xi_service_notification_handler;OK: CPU Idle = 76\.28%', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:19:59 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584519599), entry_time=FROM_UNIXTIME(1584519599), entry_time_usec='807583', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;OK;notify-service-by-email;OK: CPU Idle = 76\.28%', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:19:59 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584519599), entry_time=FROM_UNIXTIME(1584519599), entry_time_usec='807682', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: rdevegow;wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;OK;xi_service_notification_handler;OK: CPU Idle = 76\.28%', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:19:59 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584519599), entry_time=FROM_UNIXTIME(1584519599), entry_time_usec='807761', logentry_type='8192', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;Check Server CPU Status - Linux;OK;HARD;5;OK: CPU Idle = 76\.28%', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:28:23 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;WARNING;SOFT;1;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem.
Mar 18 04:28:23 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520103), entry_time=FROM_UNIXTIME(1584520103), entry_time_usec='715509', logentry_type='32768', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;WARNING;SOFT;1;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:29:21 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;WARNING;SOFT;2;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem.
Mar 18 04:29:21 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520161), entry_time=FROM_UNIXTIME(1584520161), entry_time_usec='695227', logentry_type='32768', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;WARNING;SOFT;2;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:30:13 wsvmlnngp01 nagios: SERVICE NOTIFICATION: DB Team;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;OK;xi_service_notification_handler;TCP OK - 0.005 second response time on wsvmlncbp07.ec.lowes.com port 8089
Mar 18 04:30:13 wsvmlnngp01 nagios: SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;OK;notify-service-by-email;TCP OK - 0.005 second response time on wsvmlncbp07.ec.lowes.com port 8089
Mar 18 04:30:13 wsvmlnngp01 nagios: SERVICE NOTIFICATION: rdevegow;wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;OK;xi_service_notification_handler;TCP OK - 0.005 second response time on wsvmlncbp07.ec.lowes.com port 8089
Mar 18 04:30:13 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;SPLUNK Port 8089;OK;HARD;5;TCP OK - 0.005 second response time on wsvmlncbp07.ec.lowes.com port 8089
Mar 18 04:30:13 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520213), entry_time=FROM_UNIXTIME(1584520213), entry_time_usec='369950', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: DB Team;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;OK;xi_service_notification_handler;TCP OK - 0\.005 second response time on wsvmlncbp07\.ec\.lowes\.com port 8089', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:30:13 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520213), entry_time=FROM_UNIXTIME(1584520213), entry_time_usec='370050', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: Pricing Team;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;OK;notify-service-by-email;TCP OK - 0\.005 second response time on wsvmlncbp07\.ec\.lowes\.com port 8089', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:30:13 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520213), entry_time=FROM_UNIXTIME(1584520213), entry_time_usec='370152', logentry_type='1048576', logentry_data='SERVICE NOTIFICATION: rdevegow;wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;OK;xi_service_notification_handler;TCP OK - 0\.005 second response time on wsvmlncbp07\.ec\.lowes\.com port 8089', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:30:13 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520213), entry_time=FROM_UNIXTIME(1584520213), entry_time_usec='370231', logentry_type='8192', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;SPLUNK Port 8089;OK;HARD;5;TCP OK - 0\.005 second response time on wsvmlncbp07\.ec\.lowes\.com port 8089', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:30:20 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;WARNING;SOFT;3;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem.
Mar 18 04:30:20 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520220), entry_time=FROM_UNIXTIME(1584520220), entry_time_usec='346666', logentry_type='32768', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;WARNING;SOFT;3;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:31:19 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;WARNING;SOFT;4;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem.
Mar 18 04:31:19 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520279), entry_time=FROM_UNIXTIME(1584520279), entry_time_usec='211', logentry_type='32768', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;WARNING;SOFT;4;Alert : WARNING Filesystem : /var is 75%#0112741 MB left in /var filesystem\.', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:32:18 wsvmlnngp01 nagios: SERVICE ALERT: wsvmlncbp07.ec.lowes.com;CouchBase File System Check;OK;HARD;5;ALL DISK OK
Mar 18 04:32:18 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584520338), entry_time=FROM_UNIXTIME(1584520338), entry_time_usec='140314', logentry_type='8192', logentry_data='SERVICE ALERT: wsvmlncbp07\.ec\.lowes\.com;CouchBase File System Check;OK;HARD;5;ALL DISK OK', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:53:26 wsvmlnngp01 nagios: HOST ALERT: wsvmlncbp07.ec.lowes.com;DOWN;SOFT;1;CRITICAL - wsvmlncbp07.ec.lowes.com: rta nan, lost 100%
Mar 18 04:53:26 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584521606), entry_time=FROM_UNIXTIME(1584521606), entry_time_usec='749445', logentry_type='2048', logentry_data='HOST ALERT: wsvmlncbp07\.ec\.lowes\.com;DOWN;SOFT;1;CRITICAL - wsvmlncbp07\.ec\.lowes\.com: rta nan, lost 100%', realtime_data='1', inferred_data_extracted='1''
Mar 18 04:54:25 wsvmlnngp01 nagios: HOST ALERT: wsvmlncbp07.ec.lowes.com;UP;SOFT;1;OK - wsvmlncbp07.ec.lowes.com: rta 0.435ms, lost 0%
Mar 18 04:54:25 wsvmlnngp01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1584521665), entry_time=FROM_UNIXTIME(1584521665), entry_time_usec='799836', logentry_type='1024', logentry_data='HOST ALERT: wsvmlncbp07\.ec\.lowes\.com;UP;SOFT;1;OK - wsvmlncbp07\.ec\.lowes\.com: rta 0\.435ms, lost 0%', realtime_data='1', inferred_data_extracted='1''

[Pselvin]

Hi Team,

We are getting Database error while trying to login to NagiosXI. We ran the repair script but, it didn't fix the issue yet. Kindly help.

[root@losatlngp01 ~]# /usr/local/nagiosxi/scripts/repair_databases.sh
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios ~
Stopping mysqld: [ OK ]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements'
Data records: 7
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commands'
Data records: 209
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commenthistory'
Data records: 11930
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_comments'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfiles'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfilevariables'
Data records: 131
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_conninfo'
Data records: 2062
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_contact_addresses'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroup_members'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroups'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands'
Data records: 1716
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods'
Data records: 246800
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotifications'
Data records: 245879
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_contacts'
Data records: 143
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactstatus'
Data records: 143
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_customvariables'
Data records: 6276
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_customvariablestatus'
Data records: 6276
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with keycache) MyISAM-table 'nagios_dbversion'
Data records: 1

---------

- recovering (with sort) MyISAM-table 'nagios_downtimehistory'
Data records: 14388
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_eventhandlers'
Data records: 1090
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_externalcommands'
Data records: 3
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_flappinghistory'
Data records: 11699
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_hostchecks'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contactgroups'
Data records: 224
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contacts'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostdependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroup_members'
Data records: 884
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroups'
Data records: 47
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_parenthosts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hosts'
Data records: 496
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_hoststatus'
Data records: 496
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_instances'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_logentries'
Data records: 2131763
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_notifications'
Data records: 10036551
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_objects'
Data records: 15475
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_processevents'
Data records: 1356
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_programstatus'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_runtimevariables'
Data records: 18
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicechecks'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_service_contactgroups'
Data records: 4385
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_contacts'
Data records: 146
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicedependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroup_members'
Data records: 9317
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroups'
Data records: 126
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_parentservices'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_services'
Data records: 8360
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_servicestatus'
Data records: 8360
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_statehistory'
Data records: 842248
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_systemcommands'
Data records: 63704
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_timedeventqueue'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timedevents'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiods'
Data records: 114
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges'
Data records: 775
- Fixing index 1
- Fixing index 2
Starting mysqld: [ OK ]
~

===============
REPAIR COMPLETE
===============
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql ~
Stopping mysqld: [ OK ]
- recovering (with sort) MyISAM-table 'tbl_command'
Data records: 217
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contactgroup'
Data records: 9
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contact'
Data records: 143
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contacttemplate'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_domain'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostdependency'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostescalation'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostextinfo'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostgroup'
Data records: 47
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_host'
Data records: 529
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hosttemplate'
Data records: 55
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_info'
Data records: 218
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContactgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContact'
Data records: 4
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandHost'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandService'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContactgroup'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContacttemplate'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandHost'
Data records: 41
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandService'
Data records: 41
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContactgroup'
Data records: 46
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContacttemplate'
Data records: 109
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContactgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHostgroup'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHost'
Data records: 718
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContactgroup'
Data records: 7
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHosttemplate'
Data records: 53
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContactgroup'
Data records: 164
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContact'
Data records: 4
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHostgroup'
Data records: 227
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHost'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHosttemplate'
Data records: 1019
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToVariabledefinition'
Data records: 173
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_DS'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_S'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContactgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToService'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToServicegroup'
Data records: 81
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToService'
Data records: 662
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContactgroup'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicegroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicetemplate'
Data records: 102
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContactgroup'
Data records: 23
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContact'
Data records: 78
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHostgroup'
Data records: 279
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHost'
Data records: 507
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicegroup'
Data records: 141
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicetemplate'
Data records: 528
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToVariabledefinition'
Data records: 485
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkTimeperiodToTimeperiod'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_logbook'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_mainmenu'
Data records: 7
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_servicedependency'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_serviceescalation'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_serviceextinfo'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_servicegroup'
Data records: 142
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_service'
Data records: 533
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_servicetemplate'
Data records: 104
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_session_locks'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_session'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_settings'
Data records: 13
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_submenu'
Data records: 29
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_timedefinition'
Data records: 782
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_timeperiod'
Data records: 117
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_user'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_variabledefinition'
Data records: 658
- Fixing index 1
Starting mysqld: [ OK ]
~

===============
REPAIR COMPLETE
===============
Stopping ndo2db: done.
Starting ndo2db: done.
Stopping nagios: .done.
Starting nagios: done.

=======================
nagios database repair succeeded
nagiosql database repair succeeded

[root@losatlngp01 ~]#

[Pselvin]

Please see attached.

[jdunitz]

Let's begin with a restart and running the DB repair script.

Code: Select all

# For Centos7
systemctl stop crond
systemctl stop npcd
systemctl stop nagios
systemctl stop ndo2db
 
systemctl restart mariadb
systemctl start ndo2db
systemctl start nagios
systemctl start npcd
systemctl start crond


## CENT OS 6
service crond stop
service npcd stop
service nagios stop
service ndo2db stop
 
service mysqld restart
service ndo2db start
service nagios start
service npcd start
service crond start

Then, have a look at the database repair document, and follow the instructions there:
https://assets.nagios.com/downloads/nag ... tabase.pdf

After all that, let's look at your logs and see if everything looks OK:

Code: Select all

tail -50 /usr/local/nagios/var/nagios.log

tail -50 /var/log/mysql.log

Let me know how that goes--hopefully that fixes it. If not, we can help more.

Thanks!

--Jeffrey

[Pselvin]

Hi Jeff,

I ran the commands but, still the same issue exist. I am getting this screen when i login to NagiosXI GUI. Please advise.
------------------------------------------------------------------------------
Database Error
A database connection error has been detected, please follow the repair prompt below. If the issue persists, please contact Nagios support.
Run the following from the CLI as root to attempt to repair the DB:

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

Code: Select all

[root@losatlngp01 ~]# service crond stop
Stopping crond:                                            [  OK  ]
[root@losatlngp01 ~]# service npcd stop
NPCD Stopped.
[root@losatlngp01 ~]# service nagios stop
Stopping nagios: .done.
[root@losatlngp01 ~]# service ndo2db stop
Stopping ndo2db: done.
[root@losatlngp01 ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@losatlngp01 ~]# service ndo2db start
Starting ndo2db: done.
[root@losatlngp01 ~]# service nagios start
Starting nagios: done.
[root@losatlngp01 ~]# service npcd start
NPCD started.
[root@losatlngp01 ~]# service crond start
Starting crond:                                            [  OK  ]
[root@losatlngp01 ~]# /usr/local/nagiosxi/scripts/repair_databases.sh
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios ~
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements'
Data records: 7
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commands'
Data records: 209
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commenthistory'
Data records: 11930
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_comments'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfiles'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfilevariables'
Data records: 131
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_conninfo'
Data records: 2066
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_contact_addresses'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroup_members'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroups'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands'
Data records: 1716
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods'
Data records: 248711
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotifications'
Data records: 247790
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_contacts'
Data records: 143
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactstatus'
Data records: 143
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_customvariables'
Data records: 6276
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_customvariablestatus'
Data records: 6276
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with keycache) MyISAM-table 'nagios_dbversion'
Data records: 1

---------

- recovering (with sort) MyISAM-table 'nagios_downtimehistory'
Data records: 14388
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_eventhandlers'
Data records: 1427
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_externalcommands'
Data records: 3
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_flappinghistory'
Data records: 11699
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_hostchecks'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contactgroups'
Data records: 224
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contacts'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostdependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroup_members'
Data records: 884
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroups'
Data records: 47
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_parenthosts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hosts'
Data records: 496
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_hoststatus'
Data records: 496
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_instances'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_logentries'
Data records: 2159999
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_notifications'
Data records: 10119589
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_objects'
Data records: 15475
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_processevents'
Data records: 1365
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_programstatus'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_runtimevariables'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicechecks'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_service_contactgroups'
Data records: 4385
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_contacts'
Data records: 146
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicedependencies'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalations'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroup_members'
Data records: 9317
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroups'
Data records: 126
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_parentservices'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_services'
Data records: 8360
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_servicestatus'
Data records: 8360
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_statehistory'
Data records: 842585
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_systemcommands'
Data records: 81404
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_timedeventqueue'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timedevents'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiods'
Data records: 114
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges'
Data records: 775
- Fixing index 1
- Fixing index 2
Starting mysqld:                                           [  OK  ]
~

===============
REPAIR COMPLETE
===============
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql ~
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'tbl_command'
Data records: 217
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contactgroup'
Data records: 9
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contact'
Data records: 143
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contacttemplate'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_domain'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostdependency'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostescalation'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostextinfo'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hostgroup'
Data records: 47
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_host'
Data records: 529
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hosttemplate'
Data records: 55
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_info'
Data records: 218
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContactgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContact'
Data records: 4
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandHost'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandService'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContactgroup'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContacttemplate'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandHost'
Data records: 41
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandService'
Data records: 41
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContactgroup'
Data records: 46
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContacttemplate'
Data records: 109
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContactgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHostgroup'
Data records: 2
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHost'
Data records: 718
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContactgroup'
Data records: 7
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHosttemplate'
Data records: 53
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContactgroup'
Data records: 164
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContact'
Data records: 4
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHostgroup'
Data records: 227
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHost'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHosttemplate'
Data records: 1019
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToVariabledefinition'
Data records: 173
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_DH'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_H'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_DS'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_S'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContactgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToService'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToServicegroup'
Data records: 81
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToService'
Data records: 662
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContactgroup'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContact'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHostgroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHost'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicegroup'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicetemplate'
Data records: 102
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToVariabledefinition'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContactgroup'
Data records: 23
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContact'
Data records: 78
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHostgroup'
Data records: 279
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHost'
Data records: 507
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicegroup'
Data records: 141
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicetemplate'
Data records: 528
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToVariabledefinition'
Data records: 485
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkTimeperiodToTimeperiod'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_logbook'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_mainmenu'
Data records: 7
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_servicedependency'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_serviceescalation'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_serviceextinfo'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_servicegroup'
Data records: 142
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_service'
Data records: 533
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_servicetemplate'
Data records: 104
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_session_locks'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_session'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_settings'
Data records: 13
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_submenu'
Data records: 29
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_timedefinition'
Data records: 782
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_timeperiod'
Data records: 117
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_user'
Data records: 2
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_variabledefinition'
Data records: 658
- Fixing index 1
Starting mysqld:                                           [  OK  ]
~

===============
REPAIR COMPLETE
===============
Stopping ndo2db: done.
Starting ndo2db: done.
Stopping nagios: .done.
Starting nagios: done.

=======================
nagios database repair succeeded
nagiosql database repair succeeded

[Pselvin]

Code: Select all

[root@losatlngp01 scripts]# tail -50 /usr/local/nagios/var/nagios.log
[1584604611] Warning: Host 'losatxvmp607' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'losatxvmp608' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'losatxvmp609' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'losatxvmp610' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'losatxvmp611' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp701.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp702.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp703.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp704.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp705.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp706.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp707.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] Warning: Host 'saphexvmp708.ec.lowes.com' has no default contacts or contactgroups defined!
[1584604611] WARNING: RLIMIT_NPROC is 79875, total max estimated processes is 88872! You should increase your limits (ulimit -u, or limits.conf)
[1584604613] Successfully launched command file worker with pid 38976
[1584604623] SERVICE NOTIFICATION: sumit hore;losatllhp01;Puppet_service_check;CRITICAL;xi_service_notification_handler;NRPE: Unable to read output
[1584604623] wproc: NOTIFY job 24 from worker Core Worker 38969 is a non-check helper but exited with return code 1
[1584604623] wproc:   host=losatllhp01; service=Puppet_service_check; contact=sumit hore
[1584604623] wproc:   early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
[1584604623] wproc:   stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
[1584604700] SERVICE NOTIFICATION: sumit hore;losatlecp101;Linux Filesystem Check;WARNING;xi_service_notification_handler;Alert : WARNING Filesystem : /opt is 87% 642 MB left in /opt filesystem.
[1584604700] wproc: NOTIFY job 347 from worker Core Worker 38971 is a non-check helper but exited with return code 1
[1584604700] wproc:   host=losatlecp101; service=Linux Filesystem Check; contact=sumit hore
[1584604700] wproc:   early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
[1584604700] wproc:   stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
[1584604712] SERVICE NOTIFICATION: sumit hore;losatlapp46;Lowes7OnlineA AS02 Service_App46;CRITICAL;xi_service_notification_handler;*** Lowes7OnlineA46AS02: Nok ***
[1584604712] wproc: NOTIFY job 394 from worker Core Worker 38959 is a non-check helper but exited with return code 1
[1584604712] wproc:   host=losatlapp46; service=Lowes7OnlineA AS02 Service_App46; contact=sumit hore
[1584604712] wproc:   early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
[1584604712] wproc:   stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
[1584604758] SERVICE NOTIFICATION: sumit hore;losatlcdp01;Linux Filesystem Check;CRITICAL;xi_service_notification_handler;Alert : CRITICAL Filesystem : /var/log is 100% 0 MB left in /var/log filesystem.
[1584604758] wproc: NOTIFY job 528 from worker Core Worker 38965 is a non-check helper but exited with return code 1
[1584604758] wproc:   host=losatlcdp01; service=Linux Filesystem Check; contact=sumit hore
[1584604758] wproc:   early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
[1584604758] wproc:   stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
[1584604786] SERVICE NOTIFICATION: sumit hore;losatlnup03.ec.lowes.com;SPLUNK Port 8089;CRITICAL;xi_service_notification_handler;connect to address losatlnup03.ec.lowes.com and port 8089: Connection refused
[1584604786] wproc: NOTIFY job 594 from worker Core Worker 38966 is a non-check helper but exited with return code 1
[1584604786] wproc:   host=losatlnup03.ec.lowes.com; service=SPLUNK Port 8089; contact=sumit hore
[1584604786] wproc:   early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
[1584604786] wproc:   stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
[1584604891] SERVICE NOTIFICATION: sumit hore;losatlsrp21.ec.lowes.com;File System:Permission Status:Read-Only Filesystems;CRITICAL;xi_service_notification_handler;RO_MOUNTS CRITICAL: Found ro mounts: /sys/fs/cgroup
[1584604891] wproc: NOTIFY job 787 from worker Core Worker 38969 is a non-check helper but exited with return code 1
[1584604891] wproc:   host=losatlsrp21.ec.lowes.com; service=File System:Permission Status:Read-Only Filesystems; contact=sumit hore
[1584604891] wproc:   early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
[1584604891] wproc:   stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
[1584604969] SERVICE NOTIFICATION: sumit hore;losatlapp728.ec.lowes.com;crond process/cpu utilization;CRITICAL;xi_service_notification_handler;NRPE: Command 'check_cpu_proc2.sh' not defined
[1584604969] wproc: NOTIFY job 1063 from worker Core Worker 38959 is a non-check helper but exited with return code 1
[1584604969] wproc:   host=losatlapp728.ec.lowes.com; service=crond process/cpu utilization; contact=sumit hore
[1584604969] wproc:   early_timeout=0; exited_ok=1; wait_status=256; error_code=0;
[1584604969] wproc:   stdout line 01: UNABLE TO CONNECT TO DB - EXITING!
[root@losatlngp01 scripts]#

---------------------------------------------------------------------

Code: Select all

[root@losatlngp01 scripts]# tail -50 /var/log/mysqld.log
200319  3:34:29  InnoDB: Completed initialization of buffer pool
200319  3:34:29  InnoDB: Started; log sequence number 0 60880
200319  3:34:29 [Note] Event Scheduler: Loaded 0 events
200319  3:34:29 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
200319  3:54:39 [Note] /usr/libexec/mysqld: Normal shutdown

200319  3:54:39 [Note] Event Scheduler: Purging the queue. 0 events
200319  3:54:39  InnoDB: Starting shutdown...
200319  3:54:41  InnoDB: Shutdown completed; log sequence number 0 60880
200319  3:54:41 [Note] /usr/libexec/mysqld: Shutdown complete

200319 03:54:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
200319 03:54:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200319  3:54:41  InnoDB: Initializing buffer pool, size = 8.0M
200319  3:54:41  InnoDB: Completed initialization of buffer pool
200319  3:54:41  InnoDB: Started; log sequence number 0 60880
200319  3:54:41 [Note] Event Scheduler: Loaded 0 events
200319  3:54:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
200319  3:54:54 [Note] /usr/libexec/mysqld: Normal shutdown

200319  3:54:54 [Note] Event Scheduler: Purging the queue. 0 events
200319  3:54:54  InnoDB: Starting shutdown...
200319  3:54:57  InnoDB: Shutdown completed; log sequence number 0 60880
200319  3:54:57 [Note] /usr/libexec/mysqld: Shutdown complete

200319 03:54:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
200319 03:56:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200319  3:56:43  InnoDB: Initializing buffer pool, size = 8.0M
200319  3:56:43  InnoDB: Completed initialization of buffer pool
200319  3:56:43  InnoDB: Started; log sequence number 0 60880
200319  3:56:43 [Note] Event Scheduler: Loaded 0 events
200319  3:56:43 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
200319  3:56:44 [Note] /usr/libexec/mysqld: Normal shutdown

200319  3:56:44 [Note] Event Scheduler: Purging the queue. 0 events
200319  3:56:44  InnoDB: Starting shutdown...
200319  3:56:48  InnoDB: Shutdown completed; log sequence number 0 60880
200319  3:56:48 [Note] /usr/libexec/mysqld: Shutdown complete

200319 03:56:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
200319 03:56:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200319  3:56:49  InnoDB: Initializing buffer pool, size = 8.0M
200319  3:56:49  InnoDB: Completed initialization of buffer pool
200319  3:56:49  InnoDB: Started; log sequence number 0 60880
200319  3:56:49 [Note] Event Scheduler: Loaded 0 events
200319  3:56:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
[root@losatlngp01 scripts]#

[Pselvin]

Hi Jeff,

Found out that this is because of file system space issue,increased the space which fixed this issue.

Thanks for your help. Kindly close this case.

[scottwilkerson]

Hi Jeff,

Found out that this is because of file system space issue,increased the space which fixed this issue.

Thanks for your help. Kindly close this case.

Great!

Locking thread