Table nagios/logentries marked as crashed and last

[Gonela]

Hi Team,

We are not able to run the local backup. when we see the logs .Table nagios/logentries marked as crashed and last automatic repair is failed.
how can i resolve this.

I want to resolve this issue without disturbing the current monitoring.

[scottwilkerson]

This document outlines the repair procedure
https://assets.nagios.com/downloads/nag ... tabase.pdf

[Gonela]

HI Team,

We just gone through that document. Can we repair the single table why should we repair total database instead of doing single table. Can you tell me any another alternative way. how we can repair the single table without disturbing the existing environment.

[scottwilkerson]

you can do a singe table BUT you need to know all the affected tables, and either way your whole environment is already affected.

However to do a single table run the following

Code: Select all

service mysqld stop
/usr/local/nagiosxi/scripts/repairmysql.sh <database_name> <table_name>
service mysqld start

[Gonela]

Hi team,

Thanks for the reply. I should not disturb the existing mysql status. mysql should in running status. is there any command to repair the table without disturbing the environment.

[scottwilkerson]

Hi team,

Thanks for the reply. I should not disturb the existing mysql status. mysql should in running status. is there any command to repair the table without disturbing the environment.

No there is not, also, I need to strongly encourage you to fix the problem ASAP.

All of the data will not go in the database if you do not, by delaying you are actually prolonging the issue.