Home » Categories » Multiple Categories

Nagios XI - Schedulded Backups No Longer Working

Problem Description

When looking at the location that the scheduled backups are stored in, there are no new xxxxxxx.tar.gz files being created in this location.

Additionally,  in the /store/backups/nagiosxi/ location there are lots of folders that are not being removed as per the Backup Limit setting.

 

Explanation

The root cause of the issue is that the backups are failing. When this happens the following occurs:

  • The backup does not complete, hence a xxxxxxx.tar.gz file is not created

  • The temporary /store/backups/nagiosxi/xxxxxxx folder is not deleted

    • These folders will not be cleaned up as part of the backup limit setting, they will need to be manually deleted

 

The most common cause of the backup failing is due to a database corruption.

 

Resolving The Problem

To identify why the backups are failing, you will need to execute a manual backup in an SSH session on your Nagios XI server. This will generate verbose output that will help determine why the backup is failing.

The procedure for performing a manual backup is explained in this document:

Documentation - Backing Up And Restoring Your Nagios XI System

As mentioned before, the most common cause of failing backups is a corrupt database. Here is an example of a failed backup due to a corrupt database:

Running configuration check...
Stopping nagios: done.
Starting nagios: done.
Backing up Core Config Manager (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/ndo.sock: socket ignored
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 130: Incorrect file format 'nagios_flappinghistory' when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

 

The error "check the password in this script" is a generic message and is not the cause, the line before it explains the issue in this example.

Please follow this article to repair the database:

Documentation - Crashed Database Tables

 

Once the database has been repaired, run a manual backup to confirm that the issue has been resolved.

 

To remove the directories of failed backup files, execute the following command (this will not touch any .tar.gz files):

find /store/backups/nagiosxi/ -mindepth 1 -maxdepth 1 -type d -exec rm -rf '{}' \;

 

Watching Scheduled Backups

If you need to see what is actually occurring when the scheduled backup is run, you can watch the output live by executing the following command:

tail /usr/local/nagiosxi/var/cmdsubsys.log -f

Press CTRL + C when you have finished.

 

Final Thoughts

For any support related questions please visit the Nagios Support Forums at:

http://support.nagios.com/forum/

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Enabling Oracle Linux Optional Repository
Viewed 5298 times since Mon, May 14, 2018
Nagios XI - MSSQL Query Wizard - Invalid characters in the username
Viewed 1859 times since Thu, Aug 3, 2017
Nagios XI - Optimizing The PHP Settings File
Viewed 5342 times since Thu, Jul 13, 2017
Nagios XI - Problems With Scheduled Backups At Midnight
Viewed 1304 times since Mon, Oct 10, 2016
Nagios XI - mysql_error out of range value for column
Viewed 2020 times since Tue, Aug 14, 2018
Nagios XI - CentOS 6 Installation Problems XI 2011R1.7 2011R1.8
Viewed 1576 times since Tue, Feb 2, 2016
Nagios XI - Performance Graph Problems
Viewed 11502 times since Fri, Dec 19, 2014
Nagios XI - Running Out Of Disk Space On The Nagios XI VM
Viewed 6293 times since Tue, Jan 27, 2015
Nagios XI - ERROR: unable to open include file: conf.d/*.cfg
Viewed 2074 times since Sun, May 29, 2016
Nagios XI - Disabling Database UTF8 Connectivity
Viewed 1596 times since Thu, Mar 8, 2018