>>>>> On Fri, 16 May 2008 21:23:32 +0200, Arno Lehmann said:
> 
> Hi,
> 
> 16.05.2008 17:26, Doug Breshears wrote:
> > Martin Simmons wrote:
> >>>>>>> On Wed, 07 May 2008 16:43:43 -0700, Doug Breshears said:
> >>>>>>>             
> >>> Martin Simmons wrote:
> >>>     
> >>>>>>>>> On Wed, 07 May 2008 09:25:10 -0700, Doug Breshears said:
> >>>>>>>>>             
> >>>>>>>>>                 
>>>>> Hi all,
> >>>>>
>>>>> I have a Monthly Full backup that backs up to a DISK FILE, Then Migrate 
>>>>> to Tape. I then do a daily backup which should look at the last Full 
>>>>> backup. However the daily process is saying it cannot find a valid FULL 
>>>>> backup to compare to.
> ...
> >> The output of
> >>
> >> select jobid, ClientId, FileSetId, StartTime from job where jobid in 
> >> (4301, 4292);
> >>
> >> would be useful to check that the other important fields are correct.
> >>
> >> The actual query used by Bacula will be
> >>
> >> SELECT StartTime FROM Job WHERE JobStatus='T' AND Type='B'
> >>        AND Level='F' AND Name='Ex1'
> >>        AND ClientId=$TheClientId
> >>        AND FileSetId=$TheFileSetId
> >>        ORDER BY StartTime DESC LIMIT 1;
> >>
> >> with $TheClientId and $TheFileSetId replaced by the appropriate numbers.  
> >> It
> >> should find jobid 4301 after the migration.  Prior to the migration, it 
> >> should
> >> find jobid 4292.
> >>
> >> __Martin
> ...
> > Well I am not sure what the *correct* items for these fields would be 
> > but I ran the query.
> > It seems like the file sets should be the same but there are two 
> > FileSetID's.
> > 
> > I ran the *Bacula Query as typed and came up with the following results. 
> > It looks like it is finding everything.
> > Does anything here show up as wrong?
> > 
> > *sql
> > Automatically selected Catalog: MyCatalog
> > Using Catalog "MyCatalog"
> > Entering SQL query mode.
> > Terminate each query with a semicolon.
> > Terminate query mode with a blank line.
> > Enter SQL query: select jobid, ClientId, FileSetId, StartTime from job 
> > where jobid in (4301, 4292);
> > +-------+----------+-----------+---------------------+
> > | jobid | ClientId | FileSetId | StartTime           |
> > +-------+----------+-----------+---------------------+
> > | 4292  | 2        | 8         | 2008-05-02 17:36:40 |
> > | 4301  | 2        | 11        | 2008-05-02 17:36:40 |
> > +-------+----------+-----------+---------------------+
> 
> The FileSetId definitely has to be the same... this is not mentioned 
> in the manual as far as I can see, though.
> 
> I recommend to set the file set of the migration job to the file set 
> of the original job first, and manually change the fileset id of the 
> already migrated jobs.
> 
> Also, this makes it impossible to use one migration job for original 
> jobs with different filesets... I wonder if a migration job should set 
> the fileset id itself to the original one.

It isn't clear how Bacula gets this wrong though, because the details of the
new backup job (4301) should be a copy of the old one (4292).  The fileset in
the migration job probably is recorded for that job record (4300), but I can't
see where in the code it would pollute the record for the new job.

Can you confirm that it does go wrong if the migration job has a different
fileset?  (I don't have a setup that can work for migration at the moment.)


> 
> 
> > Enter SQL query: select StartTime FROM Job WHERE JobStatus='T' AND 
> > Type='B' AND
> > +---------------------+' AND ClientId=2 AND FileSetId=8 ORDER BY 
> > StartTime DESC
> > | StartTime           |
> > +---------------------+
> > | 2008-05-07 01:05:05 |
> > +---------------------+
> > 
> > Enter SQL query: select StartTime FROM Job WHERE JobStatus='T' AND 
> > Type='B' AND
> > Level='F' and Name='Ex1' AND ClientId=2 AND FileSetId=11 ORDER BY 
> > StartTime DESC
> > +---------------------+
> > | StartTime           |
> > +---------------------+
> > | 2008-05-02 17:36:40 |
> > +---------------------+
> > Enter SQL query:
> > 
> > 
> > 
> > Thanks for your help.
> > Doug
> > 
> 
> Arno

__Martin

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2008. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users