SQL Crash,

[ivp2015]

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

[dwhitfield]

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.

[ivp2015]

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

[dwhitfield]

now its looks good,

Are we ready to lock it up? Thanks!