Re: [Bacula-users] Cannot find any appendable volumes ???
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
[Bacula-users] Cannot find any appendable volumes ???
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 ? thanks in advance for your help, -- wolfgang - 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
[Bacula-users] File Table entries not pruned
Hello, My Setup: bacula-1.38.8 Catalog on PostgreSQL 8.0 Server File Storage I'm seeing my Catalog Database getting larger and larger. the file table has 45 million records now and uses over 10GB on disk. Doing a list jobtotals shows only about 5 million files total. (this looks much more realistic than 45millions) It seems, that for some reason, file entries (and maybe others too) are not pruned from the catalog. Calling prune files client=xxx gives a No files to prune. As I've seen in the database, there are records for Clients, which are no more in the configuration of bacula-dir. Is it possible, either from bconsole or with some great SQL query, to make some sort of database cleanup and delete such unused entries from catalog ? You may imagine, that playing around with some SQL-Queries is a very time- and memory- consuming task on this (4500 row) table. I would appreciate any help, regards -- Ing. Wolfgang Powisch System Engineer next layer Telekommunikationsdienstleistungs- und Beratungs GmbH tel: +43 664 3176411 | fax: +43 59966 366 1329 | web: www.nextlayer.at my layers: Unix | Linux | HA | Mail | Web | SOAP | XML | Softwaredesign - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users