>>>>> On Fri, 22 Jun 2007 08:58:43 +0200, Wolfgang Powisch (privat) said: > > Am 22.06.2007 00:05, Martin Simmons schrieb: > >>>>>> On Thu, 21 Jun 2007 09:33:27 +0200, Wolfgang Powisch (privat) said: > >> Hello, > >> > >> My setup is as follows: > >> > >> - Bacula 1.38.0 > >> - One large Pool with 1125 on-Disk Volumes (each 2GB) > >> - about 14 Clients > >> - Schedule: weekly full, daily incremental > >> - Job-Retention: between 1 and 8 weeks, depending on client > >> - Volume retention 2 month > >> > >> My Problem: > >> After some time all Volume get status "Full" and jobs stuck with > >> the message "Cannot find any appendable volumes". I don't understand > >> how this can happen, because: > >> > >> - "list jobtotals" shows a sum of 1494 GB > >> - available volumes: 1125*2GB = 2250 GB > >> > >> Where are 756 Gb lost ??? > >> why are no volumes recycled ? > > > > The "list jobtotals" command only counts what is in the catalog so maybe > > some > > job records have been pruned? > > Ok, but if there are many pruned jobs, why are no volumes recycled. > > Is there a command to recycle all volumes without any residing jobs ? > (IMHO bacula does this sometimes on deman, but is it possible to trigger)
Not all volumes, but you can use the purge command on a single volume. > > > > I think this query will list how much Bacula thinks is on each volume > > (tested > > on PostgreSQL): > > > > SELECT VolumeName, > > sum(JobFiles) as Files, > > sum(JobBytes) as Bytes > > FROM (SELECT DISTINCT Media.VolumeName, Job.JobId, > > Job.JobFiles, Job.JobBytes > > FROM Media,JobMedia,Job > > WHERE Media.MediaId=JobMedia.MediaId > > AND JobMedia.JobId=Job.JobId) as JobInfo > > GROUP BY VolumeName; > > hmmm ... the query results in fictious high values ... I think this is becaus > most > of my jobs span over many volumes. Ah, right. Originally I wondered if all the volumes had a few (unpruned) jobs left on them. > I thought, to solve my problem, I have to find out which Volumes have no jobs > on it: > > SELECT Media.VolumeName, JobMedia.JobId > FROM Media LEFT OUTER JOIN JobMedia > ON Media.MediaId=JobMedia.MediaId > WHERE JobMedia.MediaId IS NULL; > > ... this query found lots of volumes ... but the volumes have still status > "Full" and > bacula is complaining about no appendable volumes. > > What's the correct way to recycle such volumes ? (dbcheck didn't help) They should be recycled automatically if the parameters allow it. Check the recycle flag and the volretention -- they will not be recycled until lastwritten+volretention has past. __Martin ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
