>>>>> On Fri, 27 Jul 2007 12:14:55 +0200, Luca Ferrari said: > > 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?
'A' means canceled by user. 'f' means fatal error. Maybe the successful ones have been pruned? I suggest you add jobid to the SELECT statement and then compare each line with the job output (or log file). __Martin ------------------------------------------------------------------------- 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
