On 07/06/2012 11:01 AM, Martin Simmons wrote:
>>>>>> On Thu, 05 Jul 2012 11:35:15 -0700, Stephen Thompson said:
>>
>> Hello again,
>>
>> Here's something even stranger... Another Full job logs that it's
>> written to a volume in the Full pool (FB0956), but then the status
>> output of the job lists a volume in the Incremental pool (IM0093). This
>> Incremental volume was never even mentioned in the log as a volume to
>> which the job despooled.
>
> It could be a database problem (the volumes listed in the status output come
> from a query). What is the output of the sql commands below?
>
> SELECT VolumeName,JobMedia.* FROM JobMedia,Media WHERE JobMedia.JobId=242323
> AND JobMedia.MediaId=Media.MediaId;
>
> SELECT MediaId,VolumeName FROM Media WHERE Media.VolumeName in
> ('IM0093','FB0956');
>
Looks like it did in fact write to the Incremental tape IM0093 instead
of the requested Full tape BUT logged that it wrote to a Full tape
FB0956. This begs the questions 1) Why is it writing to a tape in
another pool? and 2) Why is logging that it wrote to a different tape
than it did?
mysql> SELECT VolumeName,JobMedia.* FROM JobMedia,Media WHERE
JobMedia.JobId=242323 AND JobMedia.MediaId=Media.MediaId;
+------------+------------+--------+---------+------------+-----------+-----------+---------+------------+----------+----------+
| VolumeName | JobMediaId | JobId | MediaId | FirstIndex | LastIndex |
StartFile | EndFile | StartBlock | EndBlock | VolIndex |
+------------+------------+--------+---------+------------+-----------+-----------+---------+------------+----------+----------+
| IM0093 | 1946327 | 242323 | 1072 | 1 | 429 |
285 | 285 | 4851 | 7628 | 1 |
| IM0093 | 1946330 | 242323 | 1072 | 429 | 435 |
286 | 286 | 0 | 7628 | 2 |
| IM0093 | 1946332 | 242323 | 1072 | 435 | 438 |
287 | 287 | 0 | 7628 | 3 |
| IM0093 | 1946334 | 242323 | 1072 | 438 | 446 |
288 | 288 | 0 | 7628 | 4 |
| IM0093 | 1946338 | 242323 | 1072 | 446 | 446 |
289 | 289 | 0 | 7628 | 5 |
| IM0093 | 1946344 | 242323 | 1072 | 446 | 484 |
290 | 290 | 0 | 7628 | 6 |
| IM0093 | 1946347 | 242323 | 1072 | 484 | 727 |
291 | 291 | 0 | 7628 | 7 |
| IM0093 | 1946351 | 242323 | 1072 | 727 | 727 |
292 | 292 | 0 | 7628 | 8 |
| IM0093 | 1946357 | 242323 | 1072 | 727 | 6237 |
293 | 293 | 0 | 7628 | 9 |
| IM0093 | 1946360 | 242323 | 1072 | 6237 | 9134 |
294 | 294 | 0 | 7628 | 10 |
| IM0093 | 1946363 | 242323 | 1072 | 9134 | 12816 |
295 | 295 | 0 | 7628 | 11 |
| IM0093 | 1946368 | 242323 | 1072 | 12816 | 12950 |
296 | 296 | 0 | 7628 | 12 |
| IM0093 | 1946371 | 242323 | 1072 | 12950 | 12985 |
297 | 297 | 0 | 7628 | 13 |
| IM0093 | 1946374 | 242323 | 1072 | 12985 | 13140 |
298 | 298 | 0 | 7628 | 14 |
| IM0093 | 1946378 | 242323 | 1072 | 13140 | 13181 |
299 | 299 | 0 | 7628 | 15 |
| IM0093 | 1946383 | 242323 | 1072 | 13181 | 13283 |
300 | 300 | 0 | 7628 | 16 |
| IM0093 | 1946386 | 242323 | 1072 | 13283 | 19855 |
301 | 301 | 0 | 7628 | 17 |
| IM0093 | 1946390 | 242323 | 1072 | 19855 | 26710 |
302 | 302 | 0 | 7628 | 18 |
| IM0093 | 1946391 | 242323 | 1072 | 26710 | 33532 |
303 | 303 | 0 | 7628 | 19 |
| IM0093 | 1946394 | 242323 | 1072 | 33532 | 40378 |
304 | 304 | 0 | 7628 | 20 |
| IM0093 | 1946397 | 242323 | 1072 | 40378 | 47275 |
305 | 305 | 0 | 7628 | 21 |
| IM0093 | 1946400 | 242323 | 1072 | 47275 | 54271 |
306 | 306 | 0 | 7628 | 22 |
| IM0093 | 1946403 | 242323 | 1072 | 54271 | 58872 |
307 | 307 | 0 | 7628 | 23 |
| IM0093 | 1946406 | 242323 | 1072 | 58872 | 58872 |
308 | 308 | 0 | 7628 | 24 |
| IM0093 | 1946409 | 242323 | 1072 | 58872 | 58873 |
309 | 309 | 0 | 7628 | 25 |
| IM0093 | 1946412 | 242323 | 1072 | 58873 | 58873 |
310 | 310 | 0 | 7628 | 26 |
| IM0093 | 1946416 | 242323 | 1072 | 58873 | 58873 |
311 | 311 | 0 | 7628 | 27 |
| IM0093 | 1946420 | 242323 | 1072 | 58873 | 58928 |
312 | 312 | 0 | 7628 | 28 |
| IM0093 | 1946423 | 242323 | 1072 | 58928 | 58928 |
313 | 313 | 0 | 7628 | 29 |
| IM0093 | 1946426 | 242323 | 1072 | 58928 | 58931 |
314 | 314 | 0 | 7628 | 30 |
| IM0093 | 1946429 | 242323 | 1072 | 58931 | 58931 |
315 | 315 | 0 | 7628 | 31 |
| IM0093 | 1946432 | 242323 | 1072 | 58931 | 58935 |
316 | 316 | 0 | 7628 | 32 |
| IM0093 | 1946434 | 242323 | 1072 | 58935 | 58935 |
317 | 317 | 0 | 7628 | 33 |
| IM0093 | 1946438 | 242323 | 1072 | 58935 | 58935 |
318 | 318 | 0 | 7628 | 34 |
| IM0093 | 1946443 | 242323 | 1072 | 58935 | 59038 |
319 | 319 | 0 | 7628 | 35 |
| IM0093 | 1946445 | 242323 | 1072 | 59038 | 59038 |
320 | 320 | 0 | 7628 | 36 |
| IM0093 | 1946452 | 242323 | 1072 | 59038 | 59074 |
321 | 321 | 0 | 7628 | 37 |
| IM0093 | 1946453 | 242323 | 1072 | 59074 | 59074 |
322 | 322 | 0 | 7628 | 38 |
| IM0093 | 1946457 | 242323 | 1072 | 59074 | 59127 |
323 | 323 | 0 | 7628 | 39 |
| IM0093 | 1946460 | 242323 | 1072 | 59127 | 59127 |
324 | 324 | 0 | 7628 | 40 |
| IM0093 | 1946464 | 242323 | 1072 | 59127 | 59127 |
325 | 325 | 0 | 7628 | 41 |
| IM0093 | 1946466 | 242323 | 1072 | 59127 | 59163 |
326 | 326 | 0 | 7628 | 42 |
| IM0093 | 1946469 | 242323 | 1072 | 59163 | 59163 |
327 | 327 | 0 | 7628 | 43 |
| IM0093 | 1946473 | 242323 | 1072 | 59163 | 59199 |
328 | 328 | 0 | 7628 | 44 |
| IM0093 | 1946476 | 242323 | 1072 | 59199 | 59199 |
329 | 329 | 0 | 7628 | 45 |
| IM0093 | 1946480 | 242323 | 1072 | 59199 | 59390 |
330 | 330 | 0 | 7628 | 46 |
| IM0093 | 1946486 | 242323 | 1072 | 59390 | 59390 |
331 | 331 | 0 | 7628 | 47 |
| IM0093 | 1946488 | 242323 | 1072 | 59390 | 59390 |
332 | 332 | 0 | 7628 | 48 |
| IM0093 | 1946492 | 242323 | 1072 | 59390 | 59490 |
333 | 333 | 0 | 7628 | 49 |
| IM0093 | 1946497 | 242323 | 1072 | 59490 | 59490 |
334 | 334 | 0 | 7628 | 50 |
| IM0093 | 1946502 | 242323 | 1072 | 59490 | 59671 |
335 | 335 | 0 | 7628 | 51 |
| IM0093 | 1946506 | 242323 | 1072 | 59671 | 59671 |
336 | 336 | 0 | 7628 | 52 |
| IM0093 | 1946510 | 242323 | 1072 | 59671 | 59884 |
337 | 337 | 0 | 7628 | 53 |
| IM0093 | 1946514 | 242323 | 1072 | 59884 | 59897 |
338 | 338 | 0 | 7628 | 54 |
| IM0093 | 1946518 | 242323 | 1072 | 59897 | 59914 |
339 | 339 | 0 | 7628 | 55 |
| IM0093 | 1946524 | 242323 | 1072 | 59914 | 59922 |
340 | 340 | 0 | 7628 | 56 |
| IM0093 | 1946527 | 242323 | 1072 | 59922 | 60133 |
341 | 341 | 0 | 7628 | 57 |
| IM0093 | 1946535 | 242323 | 1072 | 60133 | 60383 |
342 | 342 | 0 | 7628 | 58 |
| IM0093 | 1946538 | 242323 | 1072 | 60383 | 60383 |
343 | 343 | 0 | 7628 | 59 |
| IM0093 | 1946543 | 242323 | 1072 | 60383 | 60383 |
344 | 344 | 0 | 7628 | 60 |
| IM0093 | 1946548 | 242323 | 1072 | 60383 | 60387 |
345 | 345 | 0 | 7628 | 61 |
| IM0093 | 1946551 | 242323 | 1072 | 60387 | 60387 |
346 | 346 | 0 | 7628 | 62 |
| IM0093 | 1946555 | 242323 | 1072 | 60387 | 60387 |
347 | 347 | 0 | 7628 | 63 |
| IM0093 | 1946558 | 242323 | 1072 | 60387 | 60389 |
348 | 348 | 0 | 7628 | 64 |
| IM0093 | 1946564 | 242323 | 1072 | 60389 | 60391 |
349 | 349 | 0 | 7628 | 65 |
| IM0093 | 1946569 | 242323 | 1072 | 60391 | 60986 |
350 | 350 | 0 | 7628 | 66 |
| IM0093 | 1946574 | 242323 | 1072 | 60986 | 60994 |
351 | 351 | 0 | 7628 | 67 |
| IM0093 | 1946583 | 242323 | 1072 | 60994 | 61010 |
352 | 352 | 0 | 7628 | 68 |
| IM0093 | 1946587 | 242323 | 1072 | 61010 | 61012 |
353 | 353 | 0 | 7628 | 69 |
| IM0093 | 1946589 | 242323 | 1072 | 61012 | 61031 |
354 | 354 | 0 | 7628 | 70 |
| IM0093 | 1946592 | 242323 | 1072 | 61031 | 66905 |
355 | 355 | 0 | 7628 | 71 |
| IM0093 | 1946596 | 242323 | 1072 | 66905 | 68262 |
356 | 356 | 0 | 7628 | 72 |
| IM0093 | 1946599 | 242323 | 1072 | 68262 | 74785 |
357 | 357 | 0 | 7628 | 73 |
| IM0093 | 1946608 | 242323 | 1072 | 74785 | 119845 |
358 | 358 | 0 | 7628 | 74 |
| IM0093 | 1946613 | 242323 | 1072 | 119845 | 210881 |
359 | 359 | 0 | 7628 | 75 |
| IM0093 | 1946617 | 242323 | 1072 | 210881 | 320601 |
360 | 360 | 0 | 7628 | 76 |
| IM0093 | 1946619 | 242323 | 1072 | 320601 | 337622 |
361 | 361 | 0 | 1381 | 77 |
+------------+------------+--------+---------+------------+-----------+-----------+---------+------------+----------+----------+
77 rows in set (0.01 sec)
mysql> SELECT MediaId,VolumeName FROM Media WHERE Media.VolumeName in
('IM0093','FB0956');
+---------+------------+
| MediaId | VolumeName |
+---------+------------+
| 1162 | FB0956 |
| 1072 | IM0093 |
+---------+------------+
2 rows in set (0.00 sec)
> __Martin
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
Stephen Thompson Berkeley Seismological Laboratory
step...@seismo.berkeley.edu 215 McCone Hall # 4760
404.538.7077 (phone) University of California, Berkeley
510.643.5811 (fax) Berkeley, CA 94720-4760
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
