Nagios Support Forum

Posted: **Thu Dec 08, 2016 10:30 am**

Hi Team,

We are migrate nagios server to our other host and after migration we are getting error please find bellow the picture

Please revert as soon as possible you can

Thanks

ERROR :- SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired

Posted: **Thu Dec 08, 2016 11:45 am**

Please run the following commands

Code: Select all

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

*If* that does not fix the issue, please run through the following:

Code: Select all

service mysqld stop
cd /var/lib/mysql/nagios
myisamchk -r -f nagios_<corrupted_table>
service mysqld start
rm -f /usr/local/nagiosxi/var/dbmaint.lock
php /usr/local/nagiosxi/cron/dbmaint.ph

There are additional steps you can take at https://support.nagios.com/kb/article.php?id=24.

If you run through that document and are still having issues can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the Download Profile (not Show Profile) button in the top right corner. If for whatever reason you cannot download the profile, please put the output of Show Profile in the thread (that will at least get us some info).

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

Posted: **Thu Dec 08, 2016 3:31 pm**

its working but its showing wrong time in server and also send alert with back time and we have change the time of nagios server and restart the sql service now its looks good,

Thakns

Posted: **Thu Dec 08, 2016 3:53 pm**

ivp2015 wrote: now its looks good,

Are we ready to lock it up? Thanks!

Nagios Support Forum

SQL Crash,

SQL Crash,

Re: SQL Crash,

Re: SQL Crash,

Re: SQL Crash,