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
