Hello Peter, On 12/25/2015 09:18 PM, Peter Keller wrote: > Hello, > > On 12/25/2015 02:01 AM, Kern Sibbald wrote: >> On 12/25/2015 08:11 AM, Kern Sibbald wrote: >>> On 12/25/2015 01:33 AM, Peter Keller wrote: >>>>> 23-Dec 18:47 DIR:xxx.yyy.zzz JobId 4: Error: Catalog error updating file >>>>> digest. bdb.h:101 Update failed: affected_rows=0 for UPDATE File SET >>>>> MD5='oGhRwHZ+y+mWb+fv9ppFrA' WHERE FileId=6148914691236517205 >> If you do not have Spool Attributes turned on, I recommend that you do >> so to see if it fixes the problem. > I turned it on and it indeed ceased emitting the error! Thank you very much!
Thanks for the feedback. I now know more precisely where to look for the bug, and I may even be able to reproduce it. There seems to be a real bug here, but very few people run with Attribute Spooling turned off, and at least I now know the workaround. > > Although the underlying bug is not fixed, this just prevented the situation > where it arose. Good enough for my needs though, I appreciate it a lot! Using Attribute Spooling will significantlyimprove your database insertion performance, and it will guarantee that the problem will not come back so you do not need to worry about it any more. > > Concerning your recommendations for Volume size, I'll probably use ~50GB since > I'm interested in auto recycling and don't want to maximize the number of > volumes that are holding unexpired jobs by using very large volumes like > 500GB. > I admit I could be wrong about my reasoning. :) 50GB sounds perfectly fine to me. > > I'm also implementing offsite backups via copy jobs (but haven't started on > this task yet). I don't have a good handle on how Volume sizes relate > to or modulate how copy jobs work. Would you be so kind as to comment on > this topic? I implemented Copy jobs, but I don't use them (other than for testing), so there are certainly more experienced people on this list that can tell you how they do it -- hopefully successfully. Best regards, Kern > > Thank you! > > -pete > ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
