>>>>> On Sat, 31 Jul 2010 12:01:40 +0200, news only said:
> 
> Martin Simmons schrieb:
> 
> > Michael schrieb:
> > > So, what might be the cause for the creation of the erroneous
> > > bootstrap entry (VolAddr=0-1078036843257)?
> > 
> > It could be catalog corruption.
> > 
> > What does the following SQL query return (where NNN is the jobid
> > containing that file)?
> > 
> > SELECT  VolumeName, MediaType, FirstIndex, LastIndex, StartFile,
> >         JobMedia.EndFile, StartBlock, JobMedia.EndBlock,
> >         Slot, StorageId, InChanger
> > FROM    JobMedia, Media
> > WHERE   JobMedia.JobId=NNN
> >         AND JobMedia.MediaId=Media.MediaId
> > ORDER BY VolIndex,JobMediaId;
> > 
> 
> Thanks for the reply. This is the outout from the query:
> 
> +------------+-----------+------------+-----------+-----------+---------+------------+----------+------+-----------+-----------+
> | VolumeName | MediaType | FirstIndex | LastIndex | StartFile | EndFile | 
> StartBlock | EndBlock | Slot | StorageId | InChanger |
> +------------+-----------+------------+-----------+-----------+---------+------------+----------+------+-----------+-----------+
> | KYE713L4   | LTO-4     |          1 |    101610 |       246 |     246 |     
>      0 |    77503 |    1 |         3 |         1 |
> | KYE713L4   | LTO-4     |     101610 |    116651 |       247 |     247 |     
>      0 |    77503 |    1 |         3 |         1 |
> | KYE713L4   | LTO-4     |     116651 |    126690 |       248 |     248 |     
>      0 |    77503 |    1 |         3 |         1 |
> | KYE713L4   | LTO-4     |     126690 |    151467 |       249 |     249 |     
>      0 |    77503 |    1 |         3 |         1 |
> | KYE713L4   | LTO-4     |     151467 |    169844 |       250 |     250 |     
>      0 |    77503 |    1 |         3 |         1 |
> | KYE713L4   | LTO-4     |     169844 |    292514 |       251 |     251 |     
>      0 |    51961 |    1 |         3 |         1 |
> | KYE713L4   | LTO-4     |          1 |    292514 |         0 |     251 |     
>      0 |    51961 |    1 |         3 |         1 |
> +------------+-----------+------------+-----------+-----------+---------+------------+----------+------+-----------+-----------+

Ok, that explains the duplicate bootstrap rows.


> I do not understand the reason of the last line. Shouldn't it be
> StartFile 246? But I get similar results for at least another full
> backup (didn't query all of them).

No, I don't think StartFile 246 would be any better.  The last row looks
completely bogus to me -- either it is not needed or it is badly corrupted.

What is the size of the job in bytes?

Did it complete without errors?

Have you run any tools like bscan with this volume to update the catalog?

What does the following slightly modified query print for that jobid?

SELECT  VolumeName, MediaType, VolIndex, JobMediaId,
        FirstIndex, LastIndex, StartFile,
        JobMedia.EndFile, StartBlock, JobMedia.EndBlock
FROM    JobMedia, Media
WHERE   JobMedia.JobId=NNN
        AND JobMedia.MediaId=Media.MediaId
ORDER BY VolIndex,JobMediaId;

__Martin

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users