I have tried several things now to correct this error without success. - Checked and repaired MySQL db with MySQL tools (mysqlcheck).
- Cleaned MySQL db with bacula tools (dbcheck). - The offending pool has been removed and a new pool created and volumes added. The backup ran without error over two weeks and then the error returned. - The temp directory has been changed to a directory with more than enough space to contain the entire backup set. - The backup job has been moved in the schedule to a period that was not concurrent with any other job. Still, the one job that has 200GB+ of files succeeds, and the job with only 60GB fails, same error. 16-Nov 08:25 director-dir: Allied-ex3.2009-11-16_01.00.02 Warning: Error updating job record. sql_update.c:194 Update problem: affected_rows=0 16-Nov 08:25 director-dir: Allied-ex3.2009-11-16_01.00.02 Warning: Error getting job record for stats: sql_get.c:293 No Job found for JobId 20947 I am at a loss to understand why. The volumes can be pruned almost immediately as the backup is only for DR purposes and each volume will be recycled each night. The only problem I see is that the client is paying for 60GB and the backups have begun using more than that amount, so volumes are being reused within the current backup. I will next try increasing the number of volumes to see if that helps. Still open to suggestions, more than happy to repost all files. DAve -- "Posterity, you will know how much it cost the present generation to preserve your freedom. I hope you will make good use of it. If you do not, I shall repent in heaven that ever I took half the pains to preserve it." John Quincy Adams http://appleseedinfo.org ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users