Nagios XI Database crashed

[rodrilea]

I have received the following message from our Nagios XI server:

Database "nagios" = {Table "nagios_statehistory" has a problem: "Table './nagios/nagios_statehistory' is marked as crashed and last (automatic?) repair failed"}

What do I need to do to fix this issue?

Rod Rilea

[benjaminsmith]

Rod,

Welcome to the Nagios Support Forum. Let's get this worked out for you. The first step is to log into the terminal as root and run the following command:

Code: Select all

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

That normally will take care of the issue. If not, then try the following command.

Code: Select all

mysqlcheck -r -f -uroot -pnagiosxi --all-databases --use_frm

If the issue persists, please PM your system profile (if you can access the interface). Thanks.

To send us your system profile.
Login to the Nagios XI GUI using a web browser
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share this in a private message and then reply to this post to bring it up in the queue.

[rodrilea]

I ran /usr/local/nagiosxi/scripts/repair_databases.sh nagios. This repaired the nagios database and resolved the problem.

Thank you for your help, you can close the ticket.

[scottwilkerson]

I ran /usr/local/nagiosxi/scripts/repair_databases.sh nagios. This repaired the nagios database and resolved the problem.

Thank you for your help, you can close the ticket.

Great!

Locking thread