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?


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