[Bacula-users] Problems using bscan to put Files back in catalog ?

Hi, I had a long retention on jobs (3 years) and a short on files 
(1 month). I usually run full backups monthly, but few of those failed
(due to time restrictions and other issues). I also run Differential
backups weekly, so all data seems to be on tapes - it just that the
File records expired.

So when I tried to restore files using option 
"6: Select backup for a client before a specified time"
bacula greeted me with:

+--------+-------+-----------+-----------------+---------------------+------------+
| JobId  | Level | JobFiles  | JobBytes        | StartTime           | 
VolumeName |
+--------+-------+-----------+-----------------+---------------------+------------+
| 10,553 | F     | 4,652,454 | 116,177,817,964 | 2009-11-14 11:36:46 | 783AHNL2 
  |
| 31,236 | D     | 1,680,724 |  32,677,953,918 | 2010-04-10 17:15:01 | 661AHNL2 
  |
| 31,387 | I     |    37,038 |   7,804,308,239 | 2010-04-11 17:15:01 | 661AHNL2 
  |
| 31,543 | I     |    71,957 |  10,034,754,063 | 2010-04-12 17:15:00 | 674AHNL2 
  |
| 31,838 | I     |   125,463 |  12,832,108,210 | 2010-04-14 17:15:00 | 674AHNL2 
  |
| 31,992 | I     |   110,707 |  11,871,570,048 | 2010-04-15 17:15:01 | 674AHNL2 
  |
+--------+-------+-----------+-----------------+---------------------+------------+
You have selected the following JobIds: 10553,31236,31387,31543,31838,31992

Building directory tree for JobId(s) 10553,31236,31387,31543,31838,31992 ...  
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

For one or more of the JobIds selected, no files were found,
so file selection is not possible.
Most likely your retention policy pruned the files.

Do you want to restore all the files? (yes|no): no


OK, everything is understandable so far. So, I recon I'd restore File
entries by bscaning tapes (which I never used before).

So I've executed (with right tapes loaded in right drives according
to bscan outputs) the following commands to fully rescan all tapes
involved back into catalog:

bscan -s -S -v -V 783AHNL2 drv2_lto2
bscan -s -S -v -V 661AHNL2 drv3_lto2
bscan -s -S -v -V 674AHNL2 drv4_lto2

Which all ended with info like (with different non-zero numbers of course) :

Records added or updated in the catalog:
      1 Media
      1 Pool
      2 Job
8992911 File

So I guessed it should be ready to go. I started bacula again, run
the restore -- but again I got dreaded "For one or more of the JobIds
selected, no files were found, so file selection is not possible"
error.

In mysql I executed a series of queries like (one for each job
listed):

select count(*) from File where JobId=10553;

And they all returned non-zero results (showing millions or hundreds
of files per job). So I would expect that the Files in catalog should
be available, but it seems bconsole disagrees with me.

Am I doing something wrong, or am I hitting a bug ?
Any hints ?

(I'd rescan all the volumes just to be sure that there is no catalog
info missing, but it would take way too long here - weeks at best)

Bacula is latest GIT Branch-5.0 (5.0.1 with some bugfixes)


P.S. I know bconsole will then ask me to "Regexp matching files to
restore?", but that is ALSO not working for me (it seems that bacula
tries to restore whole client and .bsr looks strange, but that looks
like another bug, which I'm filing in bugs.bacula.org after posting this)

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users