First of all, compiling Bacula 64-bit appears to dramatically improve performance of bscan. I was able to get some further gains with some judicious targeted tuning of MySQL, but since my MySQL was already fairly well optimized, the major win was the 64-bit build.
That said: On 10/31/11 11:05, Phil Stracchino wrote: > For those interested: > > bscan: bscan.c:1191 Could not update JobId=5660 record. > ERR=sql_update.c:196 Update failed: affected_rows=0 for UPDATE Job SET > JobStatus='T',EndTime='2011-09-05 > 06:45:24',ClientId=2,JobBytes=1320961776,ReadBytes=0,JobFiles=160611,JobErrors=0,VolSessionId=141,VolSessionTime=1312550682,PoolId=1,FileSetId=1,JobTDate=1315219524,RealEndTime='2011-09-05 > 06:45:24',PriorJobId=0,HasBase=0,PurgedFiles=0 WHERE JobId=5660 I have experimented further and found that this is a consistent failure mode. If bscan is allowed to start a volume and run to completion uninterrupted, it is fine. However, if bscan is interrupted for any reason and you have to restart scanning an already partially-scanned volume, it will produce errors like this one. I'm guessing this is probably not unique to 5.2.1. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. ------------------------------------------------------------------------------ Get your Android app more play: Bring it to the BlackBerry PlayBook in minutes. BlackBerry App World™ now supports Android™ Apps for the BlackBerry® PlayBook™. Discover just how easy and simple it is! http://p.sf.net/sfu/android-dev2dev _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel