<<3.0 UPDATE NOT SHOWING>>

[scottwilkerson]

Is your system under a very heavy load?

I noticed the checklatency was really high

Check Latency: 232.523 seconds

You might want to monitor the syslog to see if you are getting any database errors

Code: Select all

tail -f /var/log/messages

[uhiadmin]

this is what the report gave me

Last login: Thu Jun 14 15:33:10 2012 from 2ncssw212.uhi.amerco
[root@fldmon ~]# tail -f /var/log/messages
Jun 14 15:36:15 fldmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1339713375), entry_time=FROM_UNIXTIME(1339713375), entry_time_usec='43786', logentry_type='4096', logentry_data='HOST ALERT: 885005SW01_MCO778;UNREACHABLE;SOFT;3;CRITICAL - 172\.25\.5\.2: rta nan, lost 100%', realtime_data='1', inferred_data_extracted='1''
Jun 14 15:36:15 fldmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Jun 14 15:36:45 fldmon nagios: HOST ALERT: 746025SW01;DOWN;SOFT;1;CRITICAL - 10.46.25.2: rta nan, lost 100%
Jun 14 15:36:45 fldmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1339713405), entry_time=FROM_UNIXTIME(1339713405), entry_time_usec='91256', logentry_type='2048', logentry_data='HOST ALERT: 746025SW01;DOWN;SOFT;1;CRITICAL - 10\.46\.25\.2: rta nan, lost 100%', realtime_data='1', inferred_data_extracted='1''
Jun 14 15:36:45 fldmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Jun 14 15:37:05 fldmon nagios: HOST ALERT: 746025;DOWN;SOFT;1;CRITICAL - 10.46.25.1: rta nan, lost 100%
Jun 14 15:37:05 fldmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1339713425), entry_time=FROM_UNIXTIME(1339713425), entry_time_usec='135801', logentry_type='2048', logentry_data='HOST ALERT: 746025;DOWN;SOFT;1;CRITICAL - 10\.46\.25\.1: rta nan, lost 100%', realtime_data='1', inferred_data_extracted='1''
Jun 14 15:37:05 fldmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Jun 14 15:37:15 fldmon nagios: HOST ALERT: 746025SW01;UP;SOFT;2;OK - 10.46.25.2: rta 50.190ms, lost 0%
Jun 14 15:37:15 fldmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1339713435), entry_time=FROM_UNIXTIME(1339713435), entry_time_usec='44647', logentry_type='1024', logentry_data='HOST ALERT: 746025SW01;UP;SOFT;2;OK - 10\.46\.25\.2: rta 50\.190ms, lost 0%', realtime_data='1', inferred_data_extracted='1''
Jun 14 15:37:15 fldmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
^AJun 14 15:37:25 fldmon nagios: HOST ALERT: 885005_MCO778;DOWN;SOFT;4;CRITICAL - 172.25.5.1: rta nan, lost 100%
Jun 14 15:37:25 fldmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1339713445), entry_time=FROM_UNIXTIME(1339713445), entry_time_usec='44521', logentry_type='2048', logentry_data='HOST ALERT: 885005_MCO778;DOWN;SOFT;4;CRITICAL - 172\.25\.5\.1: rta nan, lost 100%', realtime_data='1', inferred_data_extracted='1''
Jun 14 15:37:25 fldmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Jun 14 15:37:25 fldmon nagios: HOST ALERT: 746025;UP;SOFT;2;OK - 10.46.25.1: rta 48.165ms, lost 0%
Jun 14 15:37:25 fldmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1339713445), entry_time=FROM_UNIXTIME(1339713445), entry_time_usec='349717', logentry_type='1024', logentry_data='HOST ALERT: 746025;UP;SOFT;2;OK - 10\.46\.25\.1: rta 48\.165ms, lost 0%', realtime_data='1', inferred_data_extracted='1''
Jun 14 15:37:25 fldmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
^A^H^HJun 14 15:37:35 fldmon nagios: HOST ALERT: 885005SW01_MCO778;UNREACHABLE;SOFT;4;CRITICAL - 172.25.5.2: rta nan, lost 100%
Jun 14 15:37:35 fldmon ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_logentries SET instance_id='1', logentry_time=FROM_UNIXTIME(1339713455), entry_time=FROM_UNIXTIME(1339713455), entry_time_usec='51732', logentry_type='4096', logentry_data='HOST ALERT: 885005SW01_MCO778;UNREACHABLE;SOFT;4;CRITICAL - 172\.25\.5\.2: rta nan, lost 100%', realtime_data='1', inferred_data_extracted='1''
Jun 14 15:37:35 fldmon ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'

[scottwilkerson]

Looks like we are going to need to repair the nagios database, the documentation for this procedure can be found here
http://library.nagios.com/library/produ ... i-database