Error on database

[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?

[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.

[steph007]

Thanks, look good now.

[scottwilkerson]

Thanks, look good now.

Great!

Locking thread