Page 1 of 1

SQL Errors

Posted: Thu Oct 06, 2011 11:17 am
by rseiwert
Curious about these messages. Should I be concerned? Not a mysql guru.

Oct 2 04:04:02 nagios ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed'
Oct 2 04:04:02 nagios ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_statehistory SET instance_id='1', state_time=FROM_UNIXTIME(1317542642), state_time_usec='161241', object_id='973', state_change='1', state='3', state_type='1', current_check_attempt='1', max_check_attempts='3', last_state='0', last_hard_state='0', output='UNKNOWN - Plugin Timed out \(15 sec\)', long_output='UNKNOWN - Plugin Timed out \(15 sec\)''
Oct 2 04:04:02 nagios ndo2db: mysql_error: 'Table './nagios/nagios_statehistory' is marked as crashed and last (automatic?) repair failed'

Re: SQL Errors

Posted: Thu Oct 06, 2011 11:29 am
by lmiltchev
In order to fix these errors, you can try repairing your database, following the steps outlined in this document:

http://assets.nagios.com/downloads/nagi ... tabase.pdf