I just ran the repair_databases.sh and it completed with out error..
...
This time the backup_xi.sh completed without error..
Compressing backup...
===============
BACKUP COMPLETE
===============
Search found 36 matches
- Fri Sep 23, 2016 12:08 pm
- Forum: Nagios XI
- Topic: 'xi_events' is marked as crashed and should be repaired
- Replies: 5
- Views: 214
- Fri Sep 23, 2016 10:07 am
- Forum: Nagios XI
- Topic: 'xi_events' is marked as crashed and should be repaired
- Replies: 5
- Views: 214
'xi_events' is marked as crashed and should be repaired
I have been trying to do a backup of nagiosxi using /usr/local/nagiosxi/scripts/backup_xi.sh It ends with this error Backing up MySQL databases... mysqldump: Got error: 145: Table './nagiosxi/xi_events' is marked as crashed and should be repaired when using LOCK TABLES Error backing up MySQL databas...
- Fri Sep 23, 2016 10:03 am
- Forum: Nagios XI
- Topic: Segmentation Fault from running repairmysql.sh
- Replies: 7
- Views: 271
Re: Segmentation Fault from running repairmysql.sh
This is what I have for the version.
# myisamchk --version
myisamchk Ver 2.7 for redhat-linux-gnu at x86_64
# myisamchk --version
myisamchk Ver 2.7 for redhat-linux-gnu at x86_64
- Fri Sep 23, 2016 7:36 am
- Forum: Nagios XI
- Topic: Segmentation Fault from running repairmysql.sh
- Replies: 7
- Views: 271
Re: Segmentation Fault from running repairmysql.sh
Update : What was happening is that the /var/log/messages file was filling up the disk were the MySQL is on. So when I tried to run repairmysql.sh Nagios it crashed with the Segmentation Fault. So I brought everthing down. Moved the /var/lib/mysql to another disk/directory and linked it back to the ...
- Mon Sep 19, 2016 12:38 pm
- Forum: Nagios XI
- Topic: Segmentation Fault from running repairmysql.sh
- Replies: 7
- Views: 271
Re: Segmentation Fault from running repairmysql.sh
Unfortunately I cannot as a NagiosXI newbie I guess...
G.We are sorry, but you are not authorised to use this feature. You may have just registered here and may need to participate more to be able to use this feature.
- Mon Sep 19, 2016 10:47 am
- Forum: Nagios XI
- Topic: Segmentation Fault from running repairmysql.sh
- Replies: 7
- Views: 271
Segmentation Fault from running repairmysql.sh
Hello, I have been getting a lot of messages in the /var/log/messages file... Sep 19 08:23:03 phslxnagios1 ndo2db: mysql_error: 'Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed' 1. Linux Distribution and version? Red Hat Enterprise Linux Server release 6.7...