Bacula-users

Re: [Bacula-users] Accurate Job - Cannot find previous jobids

2011-05-18 07:11:37
Subject: Re: [Bacula-users] Accurate Job - Cannot find previous jobids
From: Graham Keeling <graham AT equiinet DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 18 May 2011 12:08:45 +0100
On Wed, May 18, 2011 at 01:02:08PM +0200, Christian Manal wrote:
> Am 18.05.2011 12:26, schrieb Graham Keeling:
> > On Wed, May 18, 2011 at 11:54:18AM +0200, Christian Manal wrote:
> >> Am 18.05.2011 11:13, schrieb Graham Keeling:
> >>> If times don't explain it, take a look at this bacula code from
> >>> src/cats/sql_get.c (function db_accurate_get_jobids()), which is getting
> >>> the jobids from the database. You should be able to construct very similar
> >>> queries and run them by hand to see what the database says.
> >>> Or add some debug to get the exact sql queries being used.
> >>>
> >>>    /* First, find the last good Full backup for this job/client/fileset */
> >>>    <snip>
> >>
> >> Thank you. The problem seems to be that the query doesn't account for
> >> the job name it is supposed to do, just the client and fileset. I have
> >> two jobs with the same fileset for each client. One backs up to local
> >> storage with a full/diff/incr cycle and a rather long retention period,
> >> the other does monthly full backups to another building for DR and gets
> >> immediately purged.
> >>
> >> I enabled accurate for the onsite job but the query returns the last
> >> full run of the offsite job. When I add "AND Name = '<JobName>'" to the
> >> query it gets the right jobid.
> >>
> >> I think this qualifies for a bug, doesn't it?
> > 
> > I agree with you, but...
> > I have just remembered coming across this before. The thread starts here:
> > http://www.mail-archive.com/bacula-devel AT lists.sourceforge DOT 
> > net/msg04050.html
> > 
> > Kern:
> > "Bacula does not support this option."
> > 
> > Me:
> > "It does appear to be *trying* to support it, as some parts of the code that
> > figure out dependent jobs take note of the job name, though others do not."
> > 
> > Kern:
> > "I wouldn't exactly say that it is trying to support it, but rather that 
> > since 
> > the program is so complicated, and I try not to restrict it too much, there 
> > are places where it can seem to work, but it is just not designed to do so 
> > (at least at the moment), and thus it will not work.  It isn't that I don't 
> > want it to work, but there is only so much that the developers can do in 
> > the 
> > time we have.
> > 
> > Unfortunate what you are trying to do is simply not possible in the way you 
> > are trying to do it with the current code."
> 
> Great... so I have to create two identical filesets to get this to work?

Or add "AND Name = '<JobName>'", as was your idea. Maybe it works fine.

> If this kind of setup is not supported, it would be nice if I'd get at
> least a warning by './bacula-dir -t' or something.
> 
> Thanks for the help, though, I'll fix my config.
> 
> 
> Regards,
> Christian Manal
> 
> 
> > 
> > 
> > 
> >> Regards,
> >> Christian Manal
> >>
> >> ------------------------------------------------------------------------------
> >> What Every C/C++ and Fortran developer Should Know!
> >> Read this article and learn how Intel has extended the reach of its 
> >> next-generation tools to help Windows* and Linux* C/C++ and Fortran 
> >> developers boost performance applications - including clusters. 
> >> http://p.sf.net/sfu/intel-dev2devmay
> >> _______________________________________________
> >> Bacula-users mailing list
> >> Bacula-users AT lists.sourceforge DOT net
> >> https://lists.sourceforge.net/lists/listinfo/bacula-users
> > 
> > 
> > ------------------------------------------------------------------------------
> > What Every C/C++ and Fortran developer Should Know!
> > Read this article and learn how Intel has extended the reach of its 
> > next-generation tools to help Windows* and Linux* C/C++ and Fortran 
> > developers boost performance applications - including clusters. 
> > http://p.sf.net/sfu/intel-dev2devmay
> > _______________________________________________
> > Bacula-users mailing list
> > Bacula-users AT lists.sourceforge DOT net
> > https://lists.sourceforge.net/lists/listinfo/bacula-users
> > 
> 
> 
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its 
> next-generation tools to help Windows* and Linux* C/C++ and Fortran 
> developers boost performance applications - including clusters. 
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its 
next-generation tools to help Windows* and Linux* C/C++ and Fortran 
developers boost performance applications - including clusters. 
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users