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