>>>>> 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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
