Hi, I have a problem with a job that finished with an error message. Job 108 started yesterday morning and ended today at 3:55.
Bacula 1.38.5, debian stable, postgresql 7.4.7-6sarge Running Jobs: Console connected at 31-Jul-06 09:43 JobId Level Name Status ====================================================================== 108 Full Bang.2006-07-29_19.00.00 is running 109 Full BackupCatalog.2006-07-29_19.50.00 is waiting execution 110 Full SMTCZB0003.2006-07-30_08.00.00 is waiting execution 111 Full BackupCatalog.2006-07-30_08.20.00 is waiting execution [snip] 01-Aug 02:19 bacula-sd: Spooling data again ... 01-Aug 02:21 bacula-sd: Committing spooled data to Volume "Bang1". Despooling 908,909,975 bytes ... 01-Aug 02:23 bacula-dir: Max configured use duration exceeded. Marking Volume "Bang1" as Used. 01-Aug 02:23 bacula-sd: Sending spooled attrs to the Director. Despooling 241,550,790 bytes ... 01-Aug 03:55 bacula-dir: Bang.2006-07-29_19.00.00 Warning: Error updating job record. sql_update.c:169 Update problem: affected_rows=0 01-Aug 03:55 bacula-dir: Bang.2006-07-29_19.00.00 Warning: Error getting job record for stats: sql_get.c:287 No Job found for JobId 108 01-Aug 03:55 bacula-dir: Bang.2006-07-29_19.00.00 Error: Bacula 1.38.5 (18Jan06): 01-Aug-2006 03:55:29 * status dir [snip] Terminated Jobs: JobId Level Files Bytes Status Finished Name ======================================================================== [snip] 108 Full 755,497 226,024,976,679 Error 01-Aug-06 03:55 Bang 110 Full 350,469 62,591,189,371 OK 01-Aug-06 08:55 SMTCZB0003 109 Full 1 348,330,920 OK 01-Aug-06 09:03 BackupCatalog 111 Full 1 348,330,998 OK 01-Aug-06 09:12 BackupCatalog * list jobs [snip] +-----+----------+---------+------+------+----------+----------+----------+ |jobid| name |starttime| type | level| jobfiles | jobbytes |jobstatus | +-----+----------+---------+------+------+----------+----------+----------+ [snip] | 105 |SMTCZB0003|2006-07-24 14:51:55|B|F|349,640|62,232,279,458|T| | 110 |SMTCZB0003|2006-08-01 03:55:33|B|F|350,469|62,591,189,371|T| | 109 |BackupCatalog|2006-08-01 08:55:07|B|F|1|348,330,920|T| | 111 |BackupCatalog|2006-08-01 09:03:35|B|F|1|348,330,998|T| I have no idea what happend to job 108. It backed up all files, but failed to update the job record at the end. The next jobs ended without errors. Last week I had to recover the database from a crash (see my mails from last week with subject ERROR: duplicate key violates unique constraint). This problem seemed to have been solved, because job 106 finished successful. 106 Full 750,501 220,926,385,105 OK 26-Jul-06 03:38 Bang But if I check the jobs with 'list jobs' I can't find job 106 or 108. | 101 |BackupCatalog|2006-07-17 09:21:26| B | F | 0 | 0 | A | | 103 |BackupCatalog|2006-07-17 10:12:33| B | F | 0 | 0 | R | | 104 |SMTCZB0003 |2006-07-24 14:46:27| B | F | 0 | 0 | f | | 105 |SMTCZB0003 |2006-07-24 14:51:55| B | F |349,640|62,232,279,458|T| | 110 |SMTCZB0003 |2006-08-01 03:55:33| B | F |350,469|62,591,189,371|T| | 109 |BackupCatalog|2006-08-01 08:55:07| B | F | 1 | 348,330,920 |T| | 111 |BackupCatalog|2006-08-01 09:03:35| B | F | 1 | 348,330,998 |T| dbcheck also shows me errors regarding job 108. [snip] Found 22 orphaned JobMedia records. Print them? (yes/no): yes Orphaned JobMediaId=6714 JobId=108 Volume="Bang1" Orphaned JobMediaId=6715 JobId=108 Volume="Bang1" Orphaned JobMediaId=6716 JobId=108 Volume="Bang1" Orphaned JobMediaId=6717 JobId=108 Volume="Bang1" Orphaned JobMediaId=6718 JobId=108 Volume="Bang1" Orphaned JobMediaId=6719 JobId=108 Volume="Bang1" Orphaned JobMediaId=6720 JobId=108 Volume="Bang1" Orphaned JobMediaId=6721 JobId=108 Volume="Bang1" Orphaned JobMediaId=6722 JobId=108 Volume="Bang1" Orphaned JobMediaId=6723 JobId=108 Volume="Bang1" Orphaned JobMediaId=6724 JobId=108 Volume="Bang1" Orphaned JobMediaId=6725 JobId=108 Volume="Bang1" Orphaned JobMediaId=6726 JobId=108 Volume="Bang1" Orphaned JobMediaId=6727 JobId=108 Volume="Bang1" Orphaned JobMediaId=6728 JobId=108 Volume="Bang1" Orphaned JobMediaId=6729 JobId=108 Volume="Bang1" Orphaned JobMediaId=6730 JobId=108 Volume="Bang1" Orphaned JobMediaId=6731 JobId=108 Volume="Bang1" Orphaned JobMediaId=6732 JobId=108 Volume="Bang1" Orphaned JobMediaId=6733 JobId=108 Volume="Bang1" Orphaned JobMediaId=6734 JobId=108 Volume="Bang1" Orphaned JobMediaId=6735 JobId=108 Volume="Bang1" Checking for orphaned File entries. This may take some time! Found 1103096 orphaned File records. Checking for orphaned Path entries. This may take some time! Found 174 orphaned Path records Checking for orphaned Filename entries. This may take some time! Found 108 orphaned Filename records. [snip] It seems that I still have a db problem. What can I look for and how can I fix it? Any ideas? Ralf ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
