SQL Errors

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
User avatar
rseiwert
Posts: 196
Joined: Wed Jun 22, 2011 10:33 pm
Location: Somewhere between Here and Now

SQL Errors

Post 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'
Grumpy Olde IT Guy
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: SQL Errors

Post 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
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked