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
[email protected] [email protected] [email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
