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) > > 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. 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) > > __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
