Hi, 19.07.2007 23:55,, Gustavo Gibson da Silva wrote:: > Hi there, > > I've noticed that full backup jobs that are migrated are not considered > as a Backup job. So I get the following message:
Uh oh... if that's true then you found a major problem, I think... I'm forwarding this to the -devel list, too, as they surely want to know about something like this shortly before releasing the next version... > 13-Jul 02:00 srv-backup03-dir: sql_find.c:134 No Job record found: ERR= > CMD=SELECT StartTime FROM Job WHERE JobStatus='T' AND Type='B' AND > Level='F' AND Name='srv-erh01' AND ClientId=15 AND FileSetId=27 ORDER BY > StartTime DESC LIMIT 1 > > However I've noticed that it works if I change the select statement to > insert ( Type='B' or Type='M') so the statement above becomes: > > SELECT StartTime FROM Job WHERE JobStatus='T' AND ( Type='B' OR > Type='M') AND Level='F' AND Name='srv-erh01' AND ClientId=15 AND > FileSetId=27 ORDER BYStartTime DESC LIMIT 1; > > +---------------------+ > | StartTime | > +---------------------+ > | 2007-07-19 02:29:33 | > +---------------------+ > > As I am no bacula or SQL expert, have I understood the statement > correctly? I think so, but I'm not a migration expert :-) > If so how does it get fixed on bacula? Should be a rather simple change somewhere in cats/sql_find.c and / or the files where the function db_find_job_start_time() is used. Perhaps. Arno > Thank you. > > Gustavo. > > -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
