As far as I understand dbcheck is to be run regularly (I run it during the day, when bacula is idle), not mailly for File table, but for Filename and Path tables. If the systems that are backuped have a lot of auto generated filenames that are lately deleted. Table and Path tables do not have a use count (at least in 1.36.3 that I am still using), so they cannot be removed during pruning or purging of jobs (unless you scan tables like dbcheck, but it would be very unefficient).
-------------------------------------------------------------------------- Ferdinando Pasqualetti G.T.Dati srl Tel. 0557310862 - 3356172731 - Fax 055720143 Christoph Haas <[EMAIL PROTECTED]> Inviato da: [EMAIL PROTECTED] 25/10/2006 23.39 Per bacula-users@lists.sourceforge.net CC Oggetto Re: [Bacula-users] File Table entries not pruned On Wednesday 25 October 2006 23:18, Martin Simmons wrote: > > On Wed, 25 Oct 2006 23:00:09 +0200, Christoph Haas said: > > Actually I haven't changed my config in months. And after each full > > backup I can run dbcheck and it will remove a few ten thousand File > > entries. So I suspected that some part of Bacula misses to remove old > > database rows. And it didn't crash either. The storage daemon dies > > from time to time though. But that should keep altering the database > > directly anyway. > > Yes, it sounds like a bug to me. Which database is that? Did Bacula do > any pruning during the night? MySQL 4.1.11a on Debian Sarge. I intend to switch to PostgreSQL 8.1 anyway when I upgrade that machine to Debian Etch. I'm not entirely happy with MySQL. Yes, I found these pruning entries in the logs: 25-Oct 05:02 torf-dir: Begin pruning Jobs. 25-Oct 05:02 torf-dir: Pruned 2 Jobs for client lonestar-fd from catalog. 25-Oct 05:02 torf-dir: Begin pruning Files. 25-Oct 05:02 torf-dir: No Files found to prune. 25-Oct 05:02 torf-dir: End auto prune. 25-Oct 05:01 torf-dir: Begin pruning Jobs. 25-Oct 05:01 torf-dir: Pruned 2 Jobs for client mentors-fd from catalog. 25-Oct 05:01 torf-dir: Begin pruning Files. 25-Oct 05:01 torf-dir: No Files found to prune. 25-Oct 05:01 torf-dir: End auto prune. 25-Oct 03:06 torf-dir: Begin pruning Jobs. 25-Oct 03:06 torf-dir: Pruned 2 Jobs for client torf-fd from catalog. 25-Oct 03:06 torf-dir: Begin pruning Files. 25-Oct 03:06 torf-dir: No Files found to prune. 25-Oct 03:06 torf-dir: End auto prune. 24-Oct 21:29 torf-dir: Begin pruning Jobs. 24-Oct 21:29 torf-dir: No Jobs found to prune. 24-Oct 21:29 torf-dir: Begin pruning Files. 24-Oct 21:32 torf-dir: Pruned Files from 2 Jobs for client torf-fd from catalog. 24-Oct 21:32 torf-dir: End auto prune. 24-Oct 05:00 torf-dir: Begin pruning Jobs. 24-Oct 05:00 torf-dir: No Jobs found to prune. 24-Oct 05:00 torf-dir: Begin pruning Files. 24-Oct 05:00 torf-dir: No Files found to prune. 24-Oct 05:00 torf-dir: End auto prune. 24-Oct 05:00 torf-dir: Begin pruning Jobs. 24-Oct 05:00 torf-dir: No Jobs found to prune. 24-Oct 05:00 torf-dir: Begin pruning Files. 24-Oct 05:00 torf-dir: No Files found to prune. 24-Oct 05:00 torf-dir: End auto prune. 24-Oct 03:05 torf-dir: Begin pruning Jobs. 24-Oct 03:05 torf-dir: Pruned 0 Jobs for client torf-fd from catalog. 24-Oct 03:05 torf-dir: Begin pruning Files. 24-Oct 03:05 torf-dir: No Files found to prune. 24-Oct 03:05 torf-dir: End auto prune. 23-Oct 05:32 torf-dir: Begin pruning Jobs. 23-Oct 05:32 torf-dir: No Jobs found to prune. 23-Oct 05:32 torf-dir: Begin pruning Files. 23-Oct 05:32 torf-dir: No Files found to prune. 23-Oct 05:32 torf-dir: End auto prune. Most of the days there are neither jobs nor files pruned. > It would be useful to remove the cron job one night and run dbcheck > manually to list the orphaned File records and find the JobIds. Okay. How would I do that? Doesn't dbcheck just tell me the quantity of orphaned records? I just tried it: Select function number: 8 Checking for orphaned File entries. This may take some time! Found 176 orphaned File records. That's from last night where I incrementally backed up three hosts. 6 jobs were pruned according to the logs but no files were found to prune. > Then > try to find out when the corresponding records with the same JobId were > removed from the Job table (since that's what orphaned means for a File > record). Uhm. Any hint on what to look for? Thanks, Christoph ------------------------------------------------------------------------- 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=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------- 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=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
