Servicestatus table crashed

[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

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

[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

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

[Cabal]

System profile has been send to you.
Thank you
Jiri

[avandemore]

Can you send it to me as well?

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

[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

[cdienger]

We look forward to the update. Thanks!

[Cabal]

I can confirm, that the issue has been fixed by automatical script.
You can close this topic.
Thank you
Jiri