[Bacula-users] Bacula-dir - a couple of jobs consistenly failing

A couple of months ago, one job started consistently failing with this
error:

09-May 22:30 msslay-dir JobId 56964: No prior Full backup Job record found.
09-May 22:30 msslay-dir JobId 56964: No prior or suitable Full backup found in 
catalog. Doing FULL backup.
09-May 22:37 msslay-dir JobId 56964: Fatal error: sql_update.c:122 Update 
failed: affected_rows=0 for UPDATE Job SET 
JobStatus='R',Level='F',StartTime='2008-05-09 
22:37:18',ClientId=3,JobTDate=1210369038,PoolId=12 WHERE JobId=56964
09-May 22:37 msslay-dir JobId 56964: Warning: Error updating job record. 
sql_update.c:194 Update failed: affected_rows=0 for UPDATE Job SET 
JobStatus='f',EndTime='2008-05-09 
22:37:18',ClientId=3,JobBytes=0,JobFiles=0,JobErrors=0,VolSessionId=0,VolSessionTime=0,PoolId=12,FileSetId=173,JobTDate=1210369038,RealEndTime='2008-05-09
 22:37:18',PriorJobId=0 WHERE JobId=56964

I've been trying to make sense of it for a while.

Recently I added a new machine and 2 new backup jobs.

Again, one of them is consistently failing with similar database errors.


Mysqlcheck -A and dbcheck both say the database is fine.


There's plenty of space on the databases disks (including tmp space) and
~85 other backups (which are all a LOT larger in terms of file numbers and
file volumes) are suceeding happily.

Does anyone have any ideas?

AB

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users