[Bacula-users] BAT job reporting discrepancy?

I have observed a reporting discrepancy in BAT.

I have four Pools:  Full-Disk, Full-Tape, Diff-Disk, Incr-Disk.  Volume
retention is set to 1 month for Incr-Disk, 2 months for Diff-Disk, and
365d for both Full pools.  File Retention is set throughout, everywhere,
to 12 months.  If I manually look at the Media table, the jobs are there:

mysql> select VolumeName, VolStatus, VolRetention, LastWritten, VolJobs
from Media;
+---------------------+-----------+--------------+---------------------+---------+
| VolumeName          | VolStatus | VolRetention | LastWritten         |
VolJobs |
+---------------------+-----------+--------------+---------------------+---------+
| LTO4-FULL-0001      | Full      |     31536000 | 2012-12-03 05:59:13 |
      5 |
| LTO4-FULL-0002      | Used      |     31536000 | 2012-12-03 09:15:35 |
      2 |
| LTO4-FULL-0003      | Full      |     31536000 | 2013-01-07 08:58:33 |
      5 |
| LTO4-FULL-0004      | Append    |     31536000 | 2013-01-07 13:06:50 |
      2 |
| LTO4-FULL-0005      | Full      |     31536000 | 2012-02-06 23:05:18 |
      3 |
| LTO4-FULL-0006      | Used      |     31536000 | 2012-02-07 01:50:51 |
      1 |
| LTO4-FULL-0007      | Full      |     31536000 | 2012-03-07 19:08:21 |
      5 |
| LTO4-FULL-0008      | Used      |     31536000 | 2012-03-07 20:02:56 |
      2 |
...
...


And the Pools tab in BAT correctly reflects the job counts per volume as
they should be.  If I manually query the Jobs on any particular Volume,
I see what I expect:

mysql> select distinct Job.JobId, Job.Name, Media.VolumeName,
Media.LastWritten from Job join JobMedia on Job.JobId = JobMedia.JobId
join Media on JobMedia.MediaId = Media.MediaId join Pool on Media.PoolId
= Pool.PoolId where Pool.Name = 'Full-Tape' and Media.VolumeName =
'LTO4-FULL-0001';
+-------+-----------------------+----------------+---------------------+
| JobId | Name                  | VolumeName     | LastWritten         |
+-------+-----------------------+----------------+---------------------+
|  2086 | Babylon4 Backup       | LTO4-FULL-0001 | 2012-12-03 05:59:13 |
|  2087 | Netstore Backup       | LTO4-FULL-0001 | 2012-12-03 05:59:13 |
|  2088 | Babylon5 Backup       | LTO4-FULL-0001 | 2012-12-03 05:59:13 |
|  2089 | Epsilon3 Backup       | LTO4-FULL-0001 | 2012-12-03 05:59:13 |
|  2090 | Spikyfishthing Backup | LTO4-FULL-0001 | 2012-12-03 05:59:13 |
+-------+-----------------------+----------------+---------------------+
5 rows in set (0.01 sec)

If I go to Jobs Run and select one of those Jobs - 2088, for example -
and seleft List Files from Job, I see all the expected files present
from the job.


However, if I select the same volume in BAT and select List Jobs From
Volume, no records are returned.

Has anyone else observed this behavior?


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users