Hi,

On Thu, Apr 19, 2012 at 05:30:41PM -0400, Phil Stracchino wrote:
>
> I gather you are creating a new volume for every job, and never reusing
> the old ones.  So write a simple shell script that will connect to the
> bacula DB, select VolumeName from Media where VolStatus = 'Purged', save
> the list of volume names, and delete them from the disk.

No, old volumes get recycled correctly.

But what I've got is this :

bacula=# select distinct volstatus from media;
 volstatus
-----------
 Error
 Full
 Append
(3 lignes)

So there's no volume marked as purged, but old volumes are recylcled
correctly anyway as can be seen below :

20-avril 02:11 sauvageon-sd JobId 47093: Recycled volume "incremental-0671" on 
device "FileStorageIncremental" (/backups/incremental/), all previous data lost.
20-avril 02:11 sauvageon-sd JobId 47093: New volume "incremental-0671" mounted 
on device "FileStorageIncremental" (/backups/incremental/) at 20-avril-2012 
02:11.
20-avril 02:33 sauvageon-sd JobId 47093: User defined maximum volume capacity 
2,000,000,000 exceeded on device "FileStorageIncremental" 
(/backups/incremental/).
20-avril 02:33 sauvageon-sd JobId 47093: End of medium on Volume 
"incremental-0671" Bytes=1,999,936,621 Blocks=31,001 at 20-avril-2012 02:33.
20-avril 02:33 sauvageon-dir JobId 47093: There are no more Jobs associated 
with Volume "incremental-6625". Marking it purged.
20-avril 02:33 sauvageon-dir JobId 47093: All records pruned from Volume 
"incremental-6625"; marking it "Purged"
20-avril 02:33 sauvageon-dir JobId 47093: Recycled volume "incremental-6625"
20-avril 02:33 sauvageon-sd JobId 47093: Recycled volume "incremental-6625" on 
device "FileStorageIncremental" (/backups/incremental/), all previous data lost.
20-avril 02:33 sauvageon-sd JobId 47093: New volume "incremental-6625" mounted 
on device "FileStorageIncremental" (/backups/incremental/) at 20-avril-2012 
02:33.
20-avril 02:37 sauvageon-sd JobId 47093: Job write elapsed time = 02:07:04, 
Transfer rate = 1.483 M Bytes/second
20-avril 02:38 sauvageon-dir JobId 47093: Bacula sauvageon-dir 5.0.2 (28Apr10): 
20-avril-2012 02:38:57
  Build OS:               x86_64-pc-linux-gnu debian squeeze/sid
  JobId:                  47093
  Job:                    neo.univ-nc.nc.2012-04-20_00.30.00_27
  Backup Level:           Incremental, since=2012-04-19 00:30:05
  Client:                 "neo.univ-nc.nc" i386-pc-linux-gnu,debian,3.1
  FileSet:                "neo.univ-nc.nc" 2011-06-23 00:30:00
  Pool:                   "IncrementalPool" (From Job IncPool override)
  Catalog:                "UNCCatalog" (From Client resource)
  Storage:                "FileIncremental" (From Pool resource)
  Scheduled time:         20-avril-2012 00:30:00
  Start time:             20-avril-2012 00:30:07
  End time:               20-avril-2012 02:38:57
  Elapsed time:           2 hours 8 mins 50 secs
  Priority:               10
  FD Files Written:       42,320
  SD Files Written:       42,320
  FD Bytes Written:       11,301,484,945 (11.30 GB)
  SD Bytes Written:       11,307,093,934 (11.30 GB)
  Rate:                   1462.0 KB/s
  Software Compression:   29.3 %
  VSS:                    no
  Encryption:             no
  Accurate:               no
  Volume name(s):         
incremental-0652|incremental-0653|incremental-0654|incremental-0281|incremental-0655|incremental-0656|incremental-0657|incremental-0658|incremental-0659|incremental-0660|incremental-0661|incremental-0662|incremental-0663|incremental-0664|incremental-0666|incremental-0667|incremental-0668|incremental-0669|incremental-0670|incremental-0671|incremental-6625
  Volume Session Id:      2607
  Volume Session Time:    1330974874
  Last Volume Bytes:      1,376,792,193 (1.376 GB)
  Non-fatal FD errors:    0
  SD Errors:              0
  FD termination status:  OK
  SD termination status:  OK
  Termination:            Backup OK

20-avril 02:38 sauvageon-dir JobId 47093: Begin pruning Jobs older than 1 month 
15 days .
20-avril 02:39 sauvageon-dir JobId 47093: Pruned 1 Job for client 
neo.univ-nc.nc from catalog.
20-avril 02:39 sauvageon-dir JobId 47093: Begin pruning Jobs.
20-avril 02:39 sauvageon-dir JobId 47093: No Files found to prune.
20-avril 02:39 sauvageon-dir JobId 47093: End auto prune.

The problem is only a single volume is marked as purged at a time, then
it is immediately recycled.

So from what I'm reading from your answers I think all my "old" volumes
should have been marked as "Purged" already, but this is not the case,
and I don't know why.

Of course when Bacula will set their status as "Purged" in the DB, I'll
know how to clean them all :-)

So what's wrong with my setup ? (BTW my database backend is PostgreSQL,
could this be the problem ?)

bye

--
Jérôme Alet - <jerome.a...@univ-nc.nc> - Direction du Système d'Information
      Université de la Nouvelle-Calédonie - BPR4 - 98851 NOUMEA CEDEX
   Tél : +687 290081                                  Fax : +687 254829

------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to