Page 2 of 2

Re: Nagios XI System Backup

Posted: Mon Feb 18, 2019 4:54 am
by scharft
the nagios xi function "Scheduled Backups" didn't work as expected, starting it manullay is not the solution we are looking for.
So what are the next steps to fix that issue?

Re: Nagios XI System Backup

Posted: Mon Feb 18, 2019 9:28 am
by scottwilkerson
But does it run correctly after you repaired the database?

Re: Nagios XI System Backup

Posted: Tue Feb 26, 2019 3:32 am
by scharft
Hi,

not since yesterday.
The database repair script completes successful but every backup fail. :

Stopping nagios: .done.
Starting nagios: done.
Backing up NagiosQL...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/var/nagios.tmpQZOnf1: File removed before we read it
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
tar: /usr/local/nagios/share/perfdata/itrirds001.eumfgri: file changed as we read it
tar: /usr/local/nagios/share/perfdata/ateula-pdua-3-06: file changed as we read it
tar: /usr/local/nagios/share/perfdata/chnedbske001: file changed as we read it
tar: /usr/local/nagios/share/perfdata/itriapp004.eumfgri/MEMORY.rrd: file changed as we read it
tar: /usr/local/nagios/share/perfdata/itriapp004.eumfgri: file changed as we read it
Copying ramdisk configuration...
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up the SNMP trap interface configuration files...
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Error: 'Got error 28 from storage engine' when trying to dump tablespaces
mysqldump: Got error: 144: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this scrip

I used the repair script 2 times but every time the same

What do you think?

Re: Nagios XI System Backup

Posted: Tue Feb 26, 2019 11:38 am
by scottwilkerson
This

Code: Select all

Got error 28 from storage engine
Means you are out of disk space.

you will need to free up some disk space

Re: Nagios XI System Backup

Posted: Thu Mar 14, 2019 2:17 am
by scharft
after the 3rd database repair "action" the backup is now working but the old backups (keep max. 7) are not deleted.
I have changed the backup limits and deleted old ones, but it doensn't work

Re: Nagios XI System Backup

Posted: Thu Mar 14, 2019 6:57 am
by scottwilkerson
Can you show the output of this

Code: Select all

ls -al /store/backups/nagiosxi/