Scheduled SSH and Local Back Ups Failing
Posted: Fri Jul 19, 2024 5:06 pm
We have a high availability set up for XI with a prod, backup, and test instance. I can verify that on all three instances, there is enough free disk space.
We seem to be getting crashed database notifications randomly on all three and then scheduled local backups failing because of crashed database tables per /usr/local/nagiosxi/var/components/scheduledbackups.log with various errors such as:
Info:Database nagios = {Table nagios_contactnotifications has a problem: Table ./nagios/nagios_contactnotifications is marked as crashed and last (automatic?) repair failed}
Info:Database nagios = {Table nagios_commenthistory has a problem: Table ./nagios/nagios_commenthistory is marked as crashed and last (automatic?) repair failed}
A couple days this week we have received various XI alerts (for check MySQL Table Status - nagios DB service checks we have set up) on all three instances. I have run a repair and force repair as listed here (https://answerhub.nagios.com/support/s/ ... s-8f5b7a37), and it will be fine for a couple of days but then we start to see backup failures again.
Since we seemingly are getting errors so often, do you have any suggestions?
We seem to be getting crashed database notifications randomly on all three and then scheduled local backups failing because of crashed database tables per /usr/local/nagiosxi/var/components/scheduledbackups.log with various errors such as:
Info:Database nagios = {Table nagios_contactnotifications has a problem: Table ./nagios/nagios_contactnotifications is marked as crashed and last (automatic?) repair failed}
Info:Database nagios = {Table nagios_commenthistory has a problem: Table ./nagios/nagios_commenthistory is marked as crashed and last (automatic?) repair failed}
A couple days this week we have received various XI alerts (for check MySQL Table Status - nagios DB service checks we have set up) on all three instances. I have run a repair and force repair as listed here (https://answerhub.nagios.com/support/s/ ... s-8f5b7a37), and it will be fine for a couple of days but then we start to see backup failures again.
Since we seemingly are getting errors so often, do you have any suggestions?