Nagios Support Forum

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?

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

Do as @syang suggested.

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

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

Mani.Murugesan wrote: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.