Re: [Bacula-users] Removing failed jobs from media/database?

On Tue, Jun 07, 2011 at 12:40:18PM +0200, Roy Sigurd Karlsbakk wrote:
> As far as I can understand, if a job is interrupted or failed, the data 
> stored on tape/disk won't be freed until the normal retention is over. Would 
> it be possible to add a flag for 'failed' data for quicker (or immediate) 
> retention?

I have a patch that might help you.

Index: src/cats/sql_cmds.c
===================================================================
RCS file: /home/graham/bacula-5.0.3/src/cats/sql_cmds.c,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- src/cats/sql_cmds.c
+++ src/cats/sql_cmds.c
@@ -95,10 +95,13 @@
 const char *del_JobMedia = "DELETE FROM JobMedia WHERE JobId=%s";
 const char *cnt_JobMedia = "SELECT count(*) FROM JobMedia WHERE MediaId=%s";

+/* Graham says: This was hacked so that it also selects jobs
+   in error, as well as those past the retention time. As of 2009-08-25, it
+   is only used in one place - ua_prune.c */
 const char *sel_JobMedia =
    "SELECT DISTINCT JobMedia.JobId FROM JobMedia,Job "
    "WHERE MediaId=%s AND Job.JobId=JobMedia.JobId "
-   "AND Job.JobTDate<%s";
+   "AND (Job.JobTDate<%s OR Job.JobStatus IN ('A','E','f'))";

 /* Count Select JobIds for File deletion */
 const char *count_select_job =


------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users