On Friday 27 July 2007 Ryan Novosielski's cat, walking on the keyboard, wrote:
> Just to let you know, the "Terminated Jobs" listing is in NO way proof
> that the job exists in the database. You need to do list jobs, at a
> minimum. As for why a full backup is being done, I could not say. One
> gentleman here recommended I turn on query logging in my database and
> look for the query that was attempting to find a previous full backup.
> In my case, I made a change to the fileset, meaning a new full would be
> required. It might be interesting to see, in your case, what this select
> is turning up.
I found that the following query does not return any result:
SELECT StartTime FROM Job WHERE JobStatus='T' AND Type='B' AND Level='F' AND
Name='sede_Vol2Samba_job' AND ClientId=2 AND FileSetId=14 ORDER BY StartTime
DESC LIMIT 1
and in fact:
SELECT StartTime,jobstatus,level FROM Job WHERE Type='B' AND Level='F' and
name='sede_Vol2Samba_job';
starttime | jobstatus | level
---------------------+-----------+-------
2007-07-25 08:58:38 | A | F
2007-07-25 11:09:32 | f | F
2007-07-25 17:01:21 | f | F
2007-07-26 09:09:06 | A | F
2007-07-26 09:12:38 | A | F
2007-07-26 14:14:57 | f | F
2007-07-27 02:00:04 | f | F
2007-07-27 10:15:47 | A | F
2007-07-27 10:18:58 | f | F
2007-07-27 11:59:35 | A | F
2007-07-27 12:04:15 | A | F
but I don't know what exactly it means....maybe the job, once has finished
does not mark itself as terminated?
>
> Also, Enabled=no? I can't understand what the purpose to that could be,
> if you are indeed using this backup.
I'm testing the job without making bacula scheduling it until I'm sure it will
work as I'm expected to be.
Luca
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
