Page 1 of 1
Nagios XI Database crashed
Posted: Tue Apr 14, 2020 4:55 pm
by 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
Re: Nagios XI Database crashed
Posted: Tue Apr 14, 2020 5:03 pm
by 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.
Re: Nagios XI Database crashed
Posted: Tue Apr 14, 2020 5:54 pm
by 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.
Re: Nagios XI Database crashed
Posted: Wed Apr 15, 2020 7:24 am
by scottwilkerson
rodrilea wrote: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