Data Base Error

[Mani.Murugesan]

Hello Team,

Recently I have faced date base error i.e. "/usr/local/nagiosxi/scripts/repair_databases.sh"
suddenly it's started showing if I try to open my nagios URL I got this error "/usr/local/nagiosxi/scripts/repair_databases.sh"
if i give more than 10 time apply config within a day this error will come or what
because i gave more than 10times applyconfig that day
so that's why i am asking and i need to truncate anything from my sql table

Please let me know what will be the issue?

[syang]

Hello Mani,

Before attempting to repair the database, please ensure that you have recent backups of the database. You can use this documentation to backup and restore XI:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

For the repair, see this documentation:

https://assets.nagios.com/downloads/nag ... tabase.pdf

If you are still having problems after following the documentation, please let us know.
Thank you,

See

[scottwilkerson]

Do as @syang suggested.

If you continue to see the error, please send the database log either

Code: Select all

tail -50 /var/log/mysqld.log

or

Code: Select all

tail -50 /var/log/mariadb/mariadb.log

[Mani.Murugesan]

Right now the issue is resolved but that day suddenly happened . if I give many times apply config that will create any problem ?

[scottwilkerson]

Right now the issue is resolved but that day suddenly happened . if I give many times apply config that will create any problem ?

Running many Apply configurations should never be a problem, however if you have any database corruption the apply configurations could fail and compound the problem.

this should be a rare case seen most often after the Nagios server has seen a power failure or disk writing error.