Problems with scheduled backups

[scottwilkerson]

the only thing I saw was the file permissions problem when seemed to happen right before you noted that the new backup should have run, but you mentioned that you fixed that.

Did new backups start getting created after making this change?

[smersh]

Scheduled backups are still missing, unfortunately.

[smersh]

Do you think it makes sense to open a ticket?

Regards
NJ

[cdienger]

For this I would say a ticket makes sense since it looks like we'll have to do some digging. Please provide a fresh profile on the ticket(ideally when the backup has failed) as well as a copy of /usr/local/nagiosxi/var/cleaner.log.

[cdienger]

For anyone that may come across similar problems, we discovered an issue scheduled backups being deleted before they could run. This was seen by enabling sql logging in my.cnf:

general_log_file = /var/log/mysql/mysql.log
general_log = 1

just long enough to capture when a scheduled backup would run. Looking at lines containing "xi_commands" we would see the an INSERT and then DELETE of everything in xi_commands:

Query INSERT INTO xi_commands (submitter_id,command,command_data,event_time,submission_time,status_code) VALUES ('0','1117','a:2:{i:0;s:19:"nagiosxi.1529007002";i:1;s:23:"/store/backups/nagiosxi";}',NOW(),NOW(),'0')
Query DELETE FROM xi_commands WHERE processing_time < FROM_UNIXTIME(1528978202)

The fix will be available in 5.5 and will only delete scheduled jobs if there status_code is '2'(meaning complete).

[smersh]

I can confirm the issue is fixed in 5.5.
Thank you.
NJ

[tmcdonald]

Did you have further (related) questions or are we good to lock this up?

[smersh]

Yes, please.
The problem is fixed.

NJ