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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
