Local Backups are not getting archived

[blueagle]

Hi ssax. As advised I took another backup and here's what you've requested.

Code: Select all

[sar35@nagios nagiosxi.1435208103]$ cat /tmp/nagiosbackup.log 

.PROCESSING COMMAND ID 5296...
PROCESS COMMAND: CMD=1117, DATA=a:2:{i:0;s:19:"nagiosxi.1435208103";i:1;s:24:"/store/backups/nagiosxi/";}
CMDLINE=/usr/local/nagiosxi/scripts/backup_xi.sh -n nagiosxi.1435208103 -d /store/backups/nagiosxi
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

............................................................
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

...........................................................
PROCESSED 0 COMMANDS

...........................................................
PROCESSED 0 COMMANDS

............................................................
PROCESSED 0 COMMANDS

............................................................
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

..
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

...........................................................
PROCESSED 0 COMMANDS

...........................................................
..
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

............................................................
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

............................................................
.
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS
tar: /usr/local/nagios/var/spool/perfdata: file changed as we read it
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/nagios.log: file changed as we read it

.
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS
tar: /usr/local/nagios/var/service-perfdata: file changed as we read it
tar: /usr/local/nagios/var: file changed as we read it
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 MySQL databases...
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 script!
OUTPUT=Error backing up MySQL database 'nagios' - check the password in this script!
RETURNCODE=2

PROCESSED 1 COMMANDS

............................................................
.
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

..
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

............................................................
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

PROCESSED 0 COMMANDS

...........................................................
PROCESSED 0 COMMANDS

............................................................
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

............................................................
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

............................................................
.
PROCESSED 0 COMMANDS

.
PROCESSED 0 COMMANDS

I can see the log directory with subdirectories archived but the main log directory is still just a directory, it was archived.

[tgriep]

Try running the following in a shell to repair the mysql database. You may need to run it a few times.

Code: Select all

mysqlcheck -f -r -u root -pnagiosxi --databases nagios nagiosql

[blueagle]

Thank you so much. You've fixed my issue. I can see new logs are getting generated and they're all archived so they're also now showing up in Nagios XI web interface.

I'm not sure if its all somehow related but I'm also seeing a lot of these type of logs in /var/log/messages

Jul 1 06:12:31 nagios nagios: wproc: SERVICE PERFDATA job 678332 from worker Core Worker 28437 is a non-check helper but exited with return code 2
Jul 1 06:12:31 nagios nagios: wproc: early_timeout=0; exited_ok=1; wait_status=512; error_code=0;
Jul 1 06:12:31 nagios nagios: Worker 28437: Unknown jobtype: 10
Jul 1 06:12:31 nagios nagios: wproc: Unknown job type: 10

If its something quick then please suggest, otherwise I'll be happy to start a new thread.

Once again thanks for all your help in resolving my issue.

[tmcdonald]

Core worker issues should not have any impact on the backups, as those are done by XI. I would open a new thread if you want to pursue those errors.