-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Luca Ferrari wrote: > 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
Definitely on the right track, but as you can see, you have no successful jobs listed there. I don't remember the job status codes (Martin has listed them after me, I see). Can you look at your log file and find out what happened to the ends of those listed jobs? That would be useful information. Also, look for successful jobs or evidence of pruning. You might also try running one job and watching it the whole time and seeing if it completes toward the end. One guess I have is that you missed a unit on your time settings and have tapes with a retention time of 30 seconds rather than 30 days or something like that. Just a guess. As you can see though, upgrading to a full is definitely the right thing for Bacula to do. - -- ---- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGqf1Fmb+gadEcsb4RAndzAKCcPbJktqTQpOe/fhUGg8K/AynBqACfZoQm tpOL/jQKNfdVl7eAdaNXhyY= =aZ3s -----END PGP SIGNATURE----- ------------------------------------------------------------------------- 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
