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:

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? If so how does it get fixed on bacula?

Thank you.

        Gustavo.


-- 
"Nam et ipsa scientia potestas est"

        -- Sir Francis Bacon, 1597

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

Reply via email to