Page 1 of 1
Servicestatus table crashed
Posted: Mon Apr 10, 2017 8:28 am
by Cabal
Hello,
I have problem with one user on Nagios XI 5.4.3.
We use AD Authentication and currently we have 73 users in system. One user with Admin role see this error "SQL Error [ndoutils] : Table './nagios/nagios_servicestatus' is marked as crashed and last (automatic?) repair failed".
We tried to remove this user and add it again, but problem was the same. Then I tried to run SQL repair scrip, but problem still persist. Rest of users are fine.
Could you please help me with this issue?
Thank you
Jiri
Re: Servicestatus table crashed
Posted: Mon Apr 10, 2017 11:45 am
by dwhitfield
Please run the following in order:
Code: Select all
service mysqld stop
cd /var/lib/mysql/nagios
myisamchk -r -f nagios_servicestatus
service mysqld start
rm -f /usr/local/nagiosxi/var/dbmaint.lock
/usr/local/nagiosxi/cron/dbmaint.php
If you receive any errors in the above commands, please see if the resolution exists in
https://assets.nagios.com/downloads/nag ... tabase.pdf (you already ran the script so you can skip that)
Also, please post the output of the error here.
Re: Servicestatus table crashed
Posted: Tue Apr 11, 2017 6:36 am
by Cabal
I tried it, but no error, nothing in the log. I have problem only with one account. Rest of account's are ok.
Jirka
Re: Servicestatus table crashed
Posted: Tue Apr 11, 2017 10:38 am
by ssax
Please PM one of us a copy of your profile, you can download it by going to Admin > System Config > System Profile and click the Download Profile button in the top right corner.
Re: Servicestatus table crashed
Posted: Thu Apr 13, 2017 9:20 am
by Cabal
System profile has been send to you.
Thank you
Jiri
Re: Servicestatus table crashed
Posted: Thu Apr 13, 2017 1:17 pm
by avandemore
Can you send it to me as well?
Re: Servicestatus table crashed
Posted: Tue Apr 18, 2017 10:24 am
by avandemore
Profile received and shared. I do not see any issues in it.
Are you sure this user is logged into the same XI system? What browser and version are they using? Can you try a different browser with that user? If another user navigates to that same page does it work? Can you send a screenshot of the issue?
Re: Servicestatus table crashed
Posted: Tue Apr 18, 2017 3:33 pm
by Cabal
It looks like the issue has been fixed by automatical cron scripts over weekend.
We will check it again tomorrow and I'll let you know.
Thank you
Jiri
Re: Servicestatus table crashed
Posted: Tue Apr 18, 2017 3:39 pm
by cdienger
We look forward to the update. Thanks!
Re: Servicestatus table crashed
Posted: Wed Apr 26, 2017 2:32 am
by Cabal
I can confirm, that the issue has been fixed by automatical script.
You can close this topic.
Thank you
Jiri