Bacula-users

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

2011-05-18 06:29:31
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 11:26:31 +0100
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."



> 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