Nagios Support Forum

Posted: **Wed Aug 06, 2014 10:17 am**

Hi,

I came into work this morning to find this error message:

SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed SQL: SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed

Any idea how to recover from this?

Posted: **Wed Aug 06, 2014 10:20 am**

Run the following:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

Posted: **Wed Aug 06, 2014 10:26 am**

Thank you! It's working now, but I actually had to run ./repairmysql.sh nagios.

Posted: **Wed Aug 06, 2014 10:29 am**

The command I posted runs that as part of the script:

Code: Select all

#!/bin/sh
PATH=$PATH:/sbin:/usr/sbin

BASEDIR=$(dirname $0)
if [ ! -f "$BASEDIR/repair_databases.lock" ];then
    touch "$BASEDIR/repair_databases.lock"
    /sbin/service mysqld status
    mysqlstatus=$?
    if [ ! $mysqlstatus -eq 0 ];then
            rm -f /var/lib/mysql/mysql.sock
            /sbin/service mysqld start
    fi
    $BASEDIR/repairmysql.sh nagios
    $BASEDIR/repairmysql.sh nagiosql
    /sbin/service ndo2db restart
    /sbin/service nagios restart
    rm -f "$BASEDIR/repair_databases.lock"
fi

Nagios Support Forum

Broken database

Broken database

Re: Broken database

Re: Broken database

Re: Broken database