Page 3 of 3

Re: Problems with scheduled backups

Posted: Mon Jun 11, 2018 1:39 pm
by 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?

Re: Problems with scheduled backups

Posted: Mon Jun 11, 2018 1:41 pm
by smersh
Scheduled backups are still missing, unfortunately.

Re: Problems with scheduled backups

Posted: Mon Jun 11, 2018 6:19 pm
by smersh
Do you think it makes sense to open a ticket?

Regards
NJ

Re: Problems with scheduled backups

Posted: Tue Jun 12, 2018 11:21 am
by 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.

Re: Problems with scheduled backups

Posted: Mon Jun 18, 2018 10:33 am
by 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).

Re: Problems with scheduled backups

Posted: Sun Jul 22, 2018 4:23 pm
by smersh
I can confirm the issue is fixed in 5.5.
Thank you.
NJ

Re: Problems with scheduled backups

Posted: Mon Jul 23, 2018 9:25 am
by tmcdonald
Did you have further (related) questions or are we good to lock this up?

Re: Problems with scheduled backups

Posted: Mon Jul 23, 2018 9:50 am
by smersh
Yes, please.
The problem is fixed.

NJ