2012R1 error ndo2db

[jrmartin]

HEllo,
I am getting the following error but have not the slightest idea on what to do. I upgraded to 2012R1 just a week or two ago.
Any ideas? Thanks,
Jeff


Oct 24 07:46:14 nadc-nag-p01 ndo2db: Error: mysql_query() failed for 'INSERT INTO nagios_systemcommands SET instance_id='1', start_time=FROM_UNIXTIME(1351089974), start_time_usec='96389', end_time=FROM_UNIXTIME(1351089974), end_time_usec='101184', command_line='/bin/mv /usr/local/nagios/var/service-perfdata /usr/local/nagios/var/spool/xidpe/1351089974\.perfdata\.service', timeout='5', early_timeout='0', execution_time='0.004000', return_code='0', output='', long_output='' ON DUPLICATE KEY UPDATE instance_id='1', start_time=FROM_UNIXTIME(1351089974), start_time_usec='96389', end_time=FROM_UNIXTIME(1351089974), end_time_usec='101184', command_line='/bin/mv /usr/local/nagios/var/service-perfdata /usr/local/nagios/var/spool/xidpe/1351089974\.perfdata\.service', timeout='5', early_timeout='0', execution_time='0.004000', return_code='0', output='', long_output='''
Oct 24 07:46:14 nadc-nag-p01 ndo2db: mysql_error: 'Table './nagios/nagios_systemcommands' is marked as crashed and should be repaired'

[lmiltchev]

Try running the repair on the database:

Code: Select all

/usr/local/nagiosxi/scripts/repairmysql.sh nagios

Hope this helps.

[jrmartin]

that worked, thank you.

[lmiltchev]

Great!