On 4/18/2012 10:18 PM, Jerome Alet wrote:
> Hi,
>
> We've got a Bacula 5.0.2 setup here under Debian (standard packages).
>
> We only use hard disk storage pools, and have created 3 of them on a
> single partition : FileFull, FileDifferential, and FileIncremental.
>
> The problem is, after adding more and more servers to our backup
> strategy over the years, we went out of free hard disk space, so I've
> updated the configuration and database to expire jobs, files and volumes
> after 45 days instead of 70 before.
>
> I've also changed the configuration of the catalog backup job to be
> something like this :
>
> RunBeforeJob = "/etc/bacula/scripts/make_catalog_backup bacula bacula xxx
> localhost"
> RunAfterJob = "/etc/bacula/scripts/delete_catalog_backup"
> Write Bootstrap = "/backups/bootstraps/BackupCatalog-%n.bsr"
> Priority = 11 # run after main backup
> RunScript {
> RunsWhen=After
> RunsOnClient=No
> Console = "purge volume action=all allpools storage=FileFull"
> Console = "purge volume action=all allpools storage=FileDifferential"
> Console = "purge volume action=all allpools storage=FileIncremental"
> }
>
> And all storage pools are defined with "Action On Purge = Truncate"
>
> But of course the volume that are purged remain on disk, and so our hard
> disk is still full.
Changing the "action on purge" for the pool does not change it for the
old volumes that were created before the change was made. You have to
individually update the action on purge for each of those old volumes.
>
> The problem is that the three storage pools reside on the same
> partition, so for example you do an incremental backup, it will
> correctly truncate one of the "dead" volumes and so on until the
> incremental backup is done. At that time, our hard disk is still full.
> But now a full backup takes place, and unfortunately there's no more any
> volume from the Full storage pool to expire.
>
> Of course Bacula won't reuse a "dead" volume from a different storage
> pool, of which there are plenty, so now I can successfully do
> incremental backups, since dead volumes are truncated when needed in
> this pool, but my full backups don't work because there's no more volume
> to recycle in the Full pool.
>
> So I'd like to know the way to physically delete all dead volumes from
> the disk with rm, regaining almost 50% of our total hard disk space
> which is occuped by volumes containing expired datas.
>
> I suppose there's some SQL query to launch to retrieve the list of them
> all, and then another query to delete all matching records from the
> database, but there are several tables involved and I don't want to make
> an error.
>
> So please could you tell me how to proceed now to :
>
>
> 1 - Extract all the names of the "expired" volumes.
>
> 2 - Clean my database from any and all "expired" volumes from all pools.
>
> 3 - With the list obtained in 1 I think I'll be able to rm them ;-)
>
> Thanks so much in advance.
>
> --
> 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
------------------------------------------------------------------------------
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
