Page 1 of 1
Error on database
Posted: Tue Mar 31, 2020 8:30 am
by steph007
Hi,
Running a mysqlcheck against my Nagios XI found me that problem:
nagios.nagios_commenthistory
warning : Table is marked as crashed and last repair failed
warning : Size of datafile is: 88938432 Should be: 88937864
error : Found 347909 keys of 292316
error : Corrupt
What would be the option to fix this?
Re: Error on database
Posted: Tue Mar 31, 2020 9:57 am
by jbrunkow
It may help to run a database repair. The script is located at
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
on your XI server. Please be sure to run as
root or
sudo.
Refer to the following linked document for detailed instructions on how to do so.
https://assets.nagios.com/downloads/nag ... tabase.pdf
If that doesn't work, please send us your profile so that we can look in that for any errors. You can do so by logging in to the Nagios XI interface on a web browser ( [SERVER_ADDRESS]/nagiosxi/ ) > clicking on the
Admin section on top > click
System Profile on the left pane under
System Config > and click
Download Profile on that page. After you've downloaded the compressed file, send it to us in a private message and reply to this post to bring it up in our queue.
Re: Error on database
Posted: Wed Apr 01, 2020 9:19 am
by steph007
Thanks, look good now.
Re: Error on database
Posted: Wed Apr 01, 2020 9:23 am
by scottwilkerson
steph007 wrote:Thanks, look good now.
Great!
Locking thread