Martin Simmons schrieb:

> Ok, that explains the duplicate bootstrap rows.
> 
> What is the size of the job in bytes?

exactly 28321715406 B (approx 27 GB)

> Did it complete without errors?

Yes, it did.

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

I did! I still was in the phase of evaluating and I tried a lot of
things. Several older sessions where already purged.

But I can't say for sure WHEN I tried bscan.

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

+------------+-----------+----------+------------+------------+-----------+-----------+---------+------------+----------+
| VolumeName | MediaType | VolIndex | JobMediaId | FirstIndex | LastIndex | 
StartFile | EndFile | StartBlock | EndBlock |
+------------+-----------+----------+------------+------------+-----------+-----------+---------+------------+----------+
| KYE713L4   | LTO-4     |        1 |        356 |          1 |    101610 |     
  246 |     246 |          0 |    77503 |
| KYE713L4   | LTO-4     |        2 |        357 |     101610 |    116651 |     
  247 |     247 |          0 |    77503 |
| KYE713L4   | LTO-4     |        3 |        358 |     116651 |    126690 |     
  248 |     248 |          0 |    77503 |
| KYE713L4   | LTO-4     |        4 |        359 |     126690 |    151467 |     
  249 |     249 |          0 |    77503 |
| KYE713L4   | LTO-4     |        5 |        360 |     151467 |    169844 |     
  250 |     250 |          0 |    77503 |
| KYE713L4   | LTO-4     |        6 |        361 |     169844 |    292514 |     
  251 |     251 |          0 |    51961 |
| KYE713L4   | LTO-4     |        7 |        913 |          1 |    292514 |     
    0 |     251 |          0 |    51961 |
+------------+-----------+----------+------------+------------+-----------+-----------+---------+------------+----------+

Well! Does the big gap in JobMediaId indicate that in fact this session
was "bscanned" though it wasn't already purged?

I tried this one:

SELECT VolumeName, FirstIndex, JobId, count(*)
FROM  JobMedia, Media
WHERE JobMedia.MediaId=Media.MediaId
GROUP BY VolumeName, FirstIndex, JobId
HAVING count(*) > 1;

which gave the following result:
+------------+------------+-------+----------+
| VolumeName | FirstIndex | JobId | count(*) |
+------------+------------+-------+----------+
| KYE713L4   |          1 |    10 |        2 |
| KYE713L4   |          1 |    13 |        2 |
| KYE713L4   |          1 |    14 |        2 |
| KYE713L4   |          1 |    15 |        2 |
[...]
| KYE713L4   |          1 |   269 |        2 |
| KYE713L4   |          1 |   270 |        2 |
| KYE713L4   |          1 |   271 |        2 |
| KYE714L4   |          1 |   275 |        2 |
| KYE714L4   |          1 |   276 |        2 |
| KYE714L4   |          1 |   277 |        2 |
[...]
| KYE714L4   |          1 |   361 |        2 |
| KYE714L4   |          1 |   362 |        2 |
| KYE714L4   |          1 |   363 |        2 |
| KYE714L4   |          1 |   364 |        2 |
| KYE714L4   |          1 |   368 |        2 |
| KYE715L4   |       1357 |   346 |       12 |
| KYE715L4   |       1358 |   346 |        5 |
| KYE715L4   |       1767 |   353 |       17 |

When I try your query with one of the JobId between 10 and 368 I always
get something like this:
+------------+-----------+----------+------------+------------+-----------+-----------+---------+------------+----------+
| VolumeName | MediaType | VolIndex | JobMediaId | FirstIndex | LastIndex | 
StartFile | EndFile | StartBlock | EndBlock |
+------------+-----------+----------+------------+------------+-----------+-----------+---------+------------+----------+
| KYE714L4   | LTO-4     |        1 |        738 |          1 |         1 |     
   67 |      67 |          0 |     4982 |
| KYE714L4   | LTO-4     |        2 |       1007 |          1 |         1 |     
    0 |      67 |          0 |     4982 |
+------------+-----------+----------+------------+------------+-----------+-----------+---------+------------+----------+

Deleting the extra entries won't be a problem. Thanks a lot for putting
me in the right direction! My problem is solved, but there seems to be
an error somewhere in the bscan routines

IIRC I used
bscan -msS /dev/nst1 -V KYE713L4\|KYE714L4

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