Sigh. mtnbkr on IRC helped me out..
Basically, jobs were being canceled for being duplicates, while at the same
time incremental/differential backups were being escalated to fulls because the
prior job failed. It was a loop of thrashy goodness.
I now have this in my config, should fix it.
Rerun Failed Levels = no and Allow Duplicate Jobs = no
Jeff.
> On Nov 12, 2014, at 9:29 PM, Jeff MacDonald <[email protected]> wrote:
>
> Hi,
>
> For some unknown reason… I have a lot of jobs executing FULLS every 2 days. I
> can’t figure out why.
>
> I crafted up this SQL, that hopefully is going to show me all jobs that
> completed successfully:
>
>
> select jobid,level,name,starttime,endtime-starttime from job where jobstatus
> = 'T'
> and name not in ('RestoreFiles','BackupCatalog') order by job,starttime,level;
>
> Check out the output.. Notice the frequency that full jobs start with each
> other.. can someone help me understand why it might be doing that?
>
> office.westhants.ca <http://office.westhants.ca/> is by far the strangest.
>
> jobid | level | name | starttime |
> ?column?
> -------+-------+-------------------------------+---------------------+-----------------
> 8637 | D | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-09-29 00:04:44 | 00:07:30
> 8669 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-04 02:00:40 | 00:03:38
> 8685 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-05 04:05:41 | 00:03:13
> 8709 | F | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-08 04:05:50 | 00:21:28
> 8718 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-09 09:58:15 | 00:03:55
> 8726 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-10 03:30:25 | 00:03:59
> 8734 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-11 10:14:45 | 00:02:48
> 8742 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-12 02:21:50 | 00:02:52
> 8750 | D | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-13 08:55:18 | 00:03:53
> 8758 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-14 02:38:42 | 00:03:07
> 8766 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-15 11:00:16 | 00:02:53
> 8774 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-16 03:05:24 | 00:02:46
> 8782 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-17 10:06:37 | 00:03:01
> 8794 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-18 02:17:28 | 00:05:10
> 8802 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-19 09:13:03 | 00:02:48
> 8850 | D | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-25 03:43:54 | 00:05:34
> 8858 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-26 12:04:16 | 00:03:44
> 8866 | D | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-27 06:46:05 | 00:05:17
> 8900 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-31 11:27:49 | 00:04:20
> 8909 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-10-31 23:59:02 | 00:04:42
> 8917 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-01 23:59:02 | 00:04:45
> 8925 | F | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-02 23:59:03 | 00:12:12
> 8933 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-04 09:20:34 | 00:04:11
> 8941 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-04 23:59:02 | 00:04:25
> 8949 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-06 08:26:39 | 00:04:30
> 8957 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-06 23:59:02 | 00:05:20
> 8965 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-08 08:56:50 | 00:04:07
> 8973 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-08 23:59:03 | 00:05:38
> 8981 | D | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-10 09:39:01 | 00:05:46
> 8989 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-11 05:59:41 | 00:03:53
> 8997 | I | bacula.westhants.ca <http://bacula.westhants.ca/>
> | 2014-11-12 14:46:42 | 00:03:50
> 8638 | D | council2013 | 2014-09-29 00:12:17 |
> 00:00:30
> 8670 | I | council2013 | 2014-10-04 02:04:20 |
> 00:00:28
> 8686 | I | council2013 | 2014-10-05 04:08:57 |
> 00:00:29
> 8710 | F | council2013 | 2014-10-08 04:27:20 |
> 00:00:59
> 8719 | I | council2013 | 2014-10-09 10:02:13 |
> 00:00:28
> 8727 | I | council2013 | 2014-10-10 03:34:27 |
> 00:00:28
> 8735 | I | council2013 | 2014-10-11 10:17:36 |
> 00:00:27
> 8743 | I | council2013 | 2014-10-12 02:24:45 |
> 00:00:28
> 8751 | D | council2013 | 2014-10-13 08:59:13 |
> 00:00:27
> 8759 | I | council2013 | 2014-10-14 02:41:51 |
> 00:00:27
> 8767 | I | council2013 | 2014-10-15 11:03:12 |
> 00:00:31
> 8775 | I | council2013 | 2014-10-16 03:08:12 |
> 00:00:45
> 8783 | I | council2013 | 2014-10-17 10:09:40 |
> 00:00:41
> 8795 | I | council2013 | 2014-10-18 02:22:41 |
> 00:00:40
> 8803 | I | council2013 | 2014-10-19 09:15:54 |
> 00:00:40
> 8851 | D | council2013 | 2014-10-25 03:49:30 |
> 00:00:40
> 8859 | I | council2013 | 2014-10-26 12:08:03 |
> 00:00:29
> 8867 | D | council2013 | 2014-10-27 06:51:25 |
> 00:00:30
> 8877 | I | council2013 | 2014-10-28 15:50:31 |
> 00:00:33
> 8885 | I | council2013 | 2014-10-29 10:21:47 |
> 00:00:28
> 8893 | I | council2013 | 2014-10-30 19:04:48 |
> 00:00:29
> 8901 | I | council2013 | 2014-10-31 11:32:12 |
> 00:00:29
> 8910 | I | council2013 | 2014-11-01 00:03:47 |
> 00:00:29
> 8918 | I | council2013 | 2014-11-02 00:03:49 |
> 00:00:29
> 8926 | F | council2013 | 2014-11-03 00:11:17 |
> 00:01:05
> 8934 | I | council2013 | 2014-11-04 09:24:48 |
> 00:00:29
> 8942 | I | council2013 | 2014-11-05 00:03:30 |
> 00:00:28
> 8950 | I | council2013 | 2014-11-06 08:31:16 |
> 00:00:28
> 8958 | I | council2013 | 2014-11-07 00:04:25 |
> 00:00:28
> 8966 | I | council2013 | 2014-11-08 09:01:00 |
> 00:00:29
> 8974 | I | council2013 | 2014-11-09 00:04:43 |
> 00:00:29
> 8982 | D | council2013 | 2014-11-10 09:44:49 |
> 00:00:30
> 8990 | I | council2013 | 2014-11-11 06:03:37 |
> 00:00:34
> 8998 | I | council2013 | 2014-11-12 14:50:35 |
> 00:00:28
> 8627 | F | finance.munofwesthants.local | 2014-09-28 04:47:54 |
> 19:16:47
> 8675 | F | finance.munofwesthants.local | 2014-10-04 02:21:20 | 1 day
> 01:44:18
> 8816 | F | finance.munofwesthants.local | 2014-10-24 19:00:24 |
> 08:43:26
> 8915 | I | finance.munofwesthants.local | 2014-11-01 02:05:04 |
> 07:09:04
> 8923 | I | finance.munofwesthants.local | 2014-11-02 01:45:38 |
> 05:48:40
> 8939 | I | finance.munofwesthants.local | 2014-11-04 09:50:45 |
> 06:49:03
> 8955 | I | finance.munofwesthants.local | 2014-11-06 09:04:19 |
> 06:52:15
> 8971 | I | finance.munofwesthants.local | 2014-11-08 09:38:45 |
> 06:50:41
> 8649 | I | flex2012 | 2014-10-02 06:51:13 |
> 00:04:43
> 8697 | F | flex2012 | 2014-10-07 09:09:36 |
> 18:56:11
> 8722 | F | flex2012 | 2014-10-09 10:08:51 |
> 02:19:27
> 8738 | I | flex2012 | 2014-10-11 10:28:08 |
> 00:04:16
> 8754 | D | flex2012 | 2014-10-13 09:20:46 |
> 00:04:07
> 8770 | I | flex2012 | 2014-10-15 11:06:05 |
> 00:04:54
> 8806 | I | flex2012 | 2014-10-19 09:29:12 |
> 00:05:08
> 8862 | D | flex2012 | 2014-10-26 12:24:37 |
> 00:06:23
> 8880 | I | flex2012 | 2014-10-28 16:05:13 |
> 00:04:03
> 8896 | I | flex2012 | 2014-10-30 19:24:30 |
> 00:04:17
> 8913 | I | flex2012 | 2014-11-01 01:35:05 |
> 00:04:01
> 8921 | I | flex2012 | 2014-11-02 01:25:57 |
> 00:03:56
> 8937 | I | flex2012 | 2014-11-04 09:41:37 |
> 00:03:56
> 8953 | I | flex2012 | 2014-11-06 08:43:03 |
> 00:04:17
> 8969 | I | flex2012 | 2014-11-08 09:07:59 |
> 00:04:23
> 8985 | F | flex2012 | 2014-11-10 10:04:33 |
> 02:20:05
> 9001 | I | flex2012 | 2014-11-12 15:07:21 |
> 00:04:07
> 8640 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-09-29 00:29:36 | 3 days 06:21:33
> 8688 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-05 04:17:06 | 2 days 04:52:27
> 8745 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-12 02:29:22 | 1 day 06:25:53
> 8761 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-14 02:59:08 | 1 day 08:01:05
> 8777 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-16 03:27:53 | 1 day 06:38:41
> 8797 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-18 02:30:22 | 1 day 06:42:38
> 8853 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-25 03:56:22 | 1 day 08:07:50
> 8869 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-27 07:06:49 | 1 day 08:35:33
> 8887 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-29 10:25:21 | 1 day 08:36:21
> 8907 | I | office.westhants.ca <http://office.westhants.ca/>
> | 2014-10-31 14:46:45 | 01:35:17
> 8912 | I | office.westhants.ca <http://office.westhants.ca/>
> | 2014-11-01 00:20:12 | 01:14:51
> 8920 | I | office.westhants.ca <http://office.westhants.ca/>
> | 2014-11-02 00:20:19 | 01:05:35
> 8928 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-11-03 01:20:35 | 1 day 07:59:55
> 8944 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-11-05 00:05:55 | 1 day 08:20:36
> 8960 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-11-07 00:06:37 | 1 day 08:50:10
> 8976 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-11-09 00:19:55 | 1 day 09:18:58
> 8992 | F | office.westhants.ca <http://office.westhants.ca/>
> | 2014-11-11 06:16:38 | 1 day 08:30:01
> 8650 | F | planning.munofwesthants.local | 2014-10-02 06:55:58 | 1 day
> 19:04:39
> 8723 | F | planning.munofwesthants.local | 2014-10-09 12:28:20 |
> 15:02:01
> 8739 | F | planning.munofwesthants.local | 2014-10-11 10:32:26 |
> 15:49:21
> 8755 | F | planning.munofwesthants.local | 2014-10-13 09:24:55 |
> 17:13:44
> 8771 | F | planning.munofwesthants.local | 2014-10-15 11:11:01 |
> 15:54:20
> 8863 | F | planning.munofwesthants.local | 2014-10-26 12:31:02 |
> 18:15:00
> 8881 | F | planning.munofwesthants.local | 2014-10-28 16:09:18 |
> 18:09:23
> 8914 | I | planning.munofwesthants.local | 2014-11-01 01:39:08 |
> 00:25:53
> 8922 | I | planning.munofwesthants.local | 2014-11-02 01:29:56 |
> 00:15:40
> 8938 | I | planning.munofwesthants.local | 2014-11-04 09:45:35 |
> 00:05:07
> 8954 | I | planning.munofwesthants.local | 2014-11-06 08:47:23 |
> 00:16:53
> 8970 | I | planning.munofwesthants.local | 2014-11-08 09:12:24 |
> 00:26:19
> 8986 | F | planning.munofwesthants.local | 2014-11-10 12:24:41 |
> 17:34:57
> 8639 | D | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-09-29 00:12:50 | 00:16:43
> 8671 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-04 02:04:51 | 00:16:27
> 8687 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-05 04:09:29 | 00:07:34
> 8711 | F | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-08 04:28:22 | 01:12:42
> 8720 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-09 10:02:43 | 00:06:05
> 8728 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-10 03:34:57 | 00:03:11
> 8736 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-11 10:18:06 | 00:09:59
> 8744 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-12 02:25:16 | 00:04:04
> 8752 | D | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-13 08:59:43 | 00:21:00
> 8760 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-14 02:42:21 | 00:16:44
> 8768 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-15 11:03:45 | 00:02:17
> 8776 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-16 03:08:59 | 00:18:51
> 8796 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-18 02:23:23 | 00:06:56
> 8804 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-19 09:16:37 | 00:12:33
> 8852 | D | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-25 03:50:12 | 00:06:07
> 8860 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-26 12:08:35 | 00:15:59
> 8868 | D | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-27 06:51:58 | 00:14:46
> 8878 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-28 15:51:07 | 00:14:03
> 8886 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-29 10:22:17 | 00:02:50
> 8894 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-30 19:05:20 | 00:19:07
> 8902 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-10-31 11:32:44 | 00:03:32
> 8911 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-01 00:04:19 | 00:15:51
> 8919 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-02 00:04:21 | 00:15:55
> 8927 | F | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-03 00:12:25 | 01:08:08
> 8935 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-04 09:25:20 | 00:16:14
> 8943 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-05 00:04:00 | 00:01:52
> 8951 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-06 08:31:47 | 00:11:14
> 8959 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-07 00:04:55 | 00:01:39
> 8967 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-08 09:01:32 | 00:06:25
> 8975 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-09 00:05:14 | 00:14:34
> 8983 | D | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-10 09:45:22 | 00:19:08
> 8991 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-11 06:04:14 | 00:12:15
> 8999 | I | proxy.westhants.ca <http://proxy.westhants.ca/> |
> 2014-11-12 14:51:07 | 00:16:12
> (153 rows)
>
>
>
> ------------------------------------------------------------------------------
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk_______________________________________________
> Bacula-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
