>>>>> On Wed, 18 Aug 2010 23:15:59 +0100, Rory Campbell-Lange said:
>
> > > Can someone point me to the relationship between Media and File?
> >
> > Compare File.FileIndex to JobMedia.FirstIndex and JobMedia.LastIndex.
> >
> > The JobMedia.StartFile and JobMedia.EndFile columns record the "tape file",
> > i.e. EOF marks on the tape that are used for fast seeking.
>
> bacula=# select distinct(jobid), min(fileid), max(fileid) from file group
> by jobid;
> jobid | min | max
> -------+----------+----------
> 1 | 1 | 7706717
> 2 | 7706718 | 7706718
> 3 | 7706719 | 7706719
> 4 | 7706720 | 7706720
> 8 | 11669603 | 15635109
> 9 | 15635110 | 16908568
> 10 | 16908569 | 16908569
> 11 | 16908570 | 16908570
> 13 | 16908571 | 16908571
> 17 | 16908572 | 16908572
> 19 | 16908573 | 16908573
>
> bacula=# select distinct(jobid), min(firstindex), max(lastindex) from
> jobmedia group by jobid;
> jobid | min | max
> -------+-----+---------
> 1 | 1 | 7706717
> 2 | 1 | 1
> 3 | 1 | 1
> 4 | 1 | 1
> 8 | 0 | 3965507
> 9 | 1 | 1273459
> 10 | 1 | 1
> 11 | 1 | 1
> 13 | 1 | 1
> 17 | 1 | 1
> 19 | 1 | 1
>
> This shows that each backup starts from 1 (0 for one of them?!), so there is
> no
> direct relationship between the jobmedia and file tables. Correct?
No, you are still using the wrong columns. It should be min(fileindex),
max(fileindex) in the first query.
__Martin
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|