Bacula-users

Re: [Bacula-users] Bacula restore runs forever - bootstrap creation

2010-07-31 06:06:15
Subject: Re: [Bacula-users] Bacula restore runs forever - bootstrap creation
From: news.only AT hm-dat DOT de
To: bacula-users AT lists.sourceforge DOT net
Date: Sat, 31 Jul 2010 12:01:40 +0200
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 |
+------------+-----------+------------+-----------+-----------+---------+------------+----------+------+-----------+-----------+

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).
Greetings
Michael

------------------------------------------------------------------------------
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

<Prev in Thread] Current Thread [Next in Thread>