Your retention times are set inappropriately causing the job record to be pruned while the job was running causing the job to fail.
On Monday 13 November 2006 13:00, Pignedoli Luca wrote: > Hi all, > > I installed Bacula 1.38.11 on SLES 9. > > In the last one backup I have found the following errors: > > 11-Nov 03:53 domaingtie-dir: Backup_DomainGTIE.2006-11-10_21.00.00 > Warning: Error updating job record. sql_update.c:169 Update problem: > affected_rows=0 > 11-Nov 03:53 domaingtie-dir: Backup_DomainGTIE.2006-11-10_21.00.00 > Warning: Error getting job record for stats: sql_get.c:287 No Job found > for JobId 190 > > I have checked if in the Database, table Job, Job with ID 190 exist and > in effects it does not exist, but in the tables JobMedia and File I have > a recodrd with jobID = 190. > > This is a Full Log Job: > > 10-Nov 21:00 domaingtie-dir: Start Backup JobId 190, > Job=Backup_DomainGTIE.2006-11-10_21.00.00 > 10-Nov 21:00 domaingtie-dir: Recycled volume "Week_2_c4" > 10-Nov 21:00 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 10-Nov 21:00 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 1. > 10-Nov 21:00 domaingtie-sd: 3307 Issuing autochanger "unload slot 1, > drive 0" command. > 10-Nov 21:00 domaingtie-sd: 3304 Issuing autochanger "load slot 4, drive > 0" command. > 10-Nov 21:01 domaingtie-sd: 3305 Autochanger "load slot 4, drive 0", > status is OK. > 10-Nov 21:01 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 10-Nov 21:01 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 4. > 10-Nov 21:01 domaingtie-sd: Recycled volume "Week_2_c4" on device > "Drive-0" (/dev/nst0), all previous data lost. > 10-Nov 22:52 domaingtie-sd: End of Volume "Week_2_c4" at 28:12224 on > device "Drive-0" (/dev/nst0). Write of 64512 bytes got -1. > 10-Nov 22:52 domaingtie-sd: Re-read of last block succeeded. > 10-Nov 22:52 domaingtie-sd: End of medium on Volume "Week_2_c4" > Bytes=28,786,801,378 Blocks=446,224 at 10-Nov-2006 22:52. > 10-Nov 22:54 domaingtie-dir: Pruned 1 Job on Volume "Week_2_c4" from > catalog. > 10-Nov 22:54 domaingtie-dir: Pruned 1 Job on Volume "Week_2_c5" from > catalog. > 10-Nov 22:54 domaingtie-dir: Pruned 1 Job on Volume "Week_2_c3" from > catalog. > 10-Nov 22:54 domaingtie-dir: Recycled volume "Week_2_c1" > 10-Nov 22:54 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 10-Nov 22:54 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 4. > 10-Nov 22:54 domaingtie-sd: 3307 Issuing autochanger "unload slot 4, > drive 0" command. > 10-Nov 22:55 domaingtie-sd: 3304 Issuing autochanger "load slot 1, drive > 0" command. > 10-Nov 22:56 domaingtie-sd: 3305 Autochanger "load slot 1, drive 0", > status is OK. > 10-Nov 22:56 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 10-Nov 22:56 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 1. > 10-Nov 22:56 domaingtie-sd: Recycled volume "Week_2_c1" on device > "Drive-0" (/dev/nst0), all previous data lost. > 10-Nov 22:56 domaingtie-sd: New volume "Week_2_c1" mounted on device > "Drive-0" (/dev/nst0) at 10-Nov-2006 22:56. > 11-Nov 00:45 domaingtie-sd: End of Volume "Week_2_c1" at 26:13970 on > device "Drive-0" (/dev/nst0). Write of 64512 bytes got -1. > 11-Nov 00:45 domaingtie-sd: Re-read of last block succeeded. > 11-Nov 00:45 domaingtie-sd: End of medium on Volume "Week_2_c1" > Bytes=26,899,568,216 Blocks=416,970 at 11-Nov-2006 00:45. > 11-Nov 00:47 domaingtie-dir: Recycled volume "Week_2_c2" > 11-Nov 00:47 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 11-Nov 00:47 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 1. > 11-Nov 00:47 domaingtie-sd: 3307 Issuing autochanger "unload slot 1, > drive 0" command. > 11-Nov 00:48 domaingtie-sd: 3304 Issuing autochanger "load slot 2, drive > 0" command. > 11-Nov 00:48 domaingtie-sd: 3305 Autochanger "load slot 2, drive 0", > status is OK. > 11-Nov 00:48 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 11-Nov 00:48 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 2. > 11-Nov 00:49 domaingtie-sd: Recycled volume "Week_2_c2" on device > "Drive-0" (/dev/nst0), all previous data lost. > 11-Nov 00:49 domaingtie-sd: New volume "Week_2_c2" mounted on device > "Drive-0" (/dev/nst0) at 11-Nov-2006 00:49. > 11-Nov 02:38 domaingtie-sd: End of Volume "Week_2_c2" at 29:1630 on > device "Drive-0" (/dev/nst0). Write of 64512 bytes got -1. > 11-Nov 02:38 domaingtie-sd: Re-read of last block succeeded. > 11-Nov 02:38 domaingtie-sd: End of medium on Volume "Week_2_c2" > Bytes=29,103,298,053 Blocks=451,130 at 11-Nov-2006 02:38. > 11-Nov 02:40 domaingtie-dir: Recycled volume "Week_2_c3" > 11-Nov 02:40 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 11-Nov 02:40 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 2. > 11-Nov 02:40 domaingtie-sd: 3307 Issuing autochanger "unload slot 2, > drive 0" command. > 11-Nov 02:40 domaingtie-sd: 3304 Issuing autochanger "load slot 3, drive > 0" command. > 11-Nov 02:41 domaingtie-sd: 3305 Autochanger "load slot 3, drive 0", > status is OK. > 11-Nov 02:41 domaingtie-sd: 3301 Issuing autochanger "loaded drive 0" > command. > 11-Nov 02:41 domaingtie-sd: 3302 Autochanger "loaded drive 0", result is > Slot 3. > 11-Nov 02:42 domaingtie-sd: Recycled volume "Week_2_c3" on device > "Drive-0" (/dev/nst0), all previous data lost. > 11-Nov 02:42 domaingtie-sd: New volume "Week_2_c3" mounted on device > "Drive-0" (/dev/nst0) at 11-Nov-2006 02:42. > 11-Nov 03:53 domaingtie-dir: Backup_DomainGTIE.2006-11-10_21.00.00 > Warning: Error updating job record. sql_update.c:169 Update problem: > affected_rows=0 > 11-Nov 03:53 domaingtie-dir: Backup_DomainGTIE.2006-11-10_21.00.00 > Warning: Error getting job record for stats: sql_get.c:287 No Job found > for JobId 190 > 11-Nov 03:53 domaingtie-dir: Backup_DomainGTIE.2006-11-10_21.00.00 > Error: Bacula 1.38.11 (28Jun06): 11-Nov-2006 03:53:23 > JobId: 190 > Job: Backup_DomainGTIE.2006-11-10_21.00.00 > Backup Level: Full > Client: "domaingtie-fd" x86_64-suse-linux-gnu,suse,9 > FileSet: "Full Set" 2006-08-30 21:00:02 > Pool: "Week2" > Storage: "DAT40x6" > Scheduled time: 10-Nov-2006 21:00:00 > Start time: 10-Nov-2006 21:00:03 > End time: 11-Nov-2006 03:53:23 > Elapsed time: 6 hours 53 mins 20 secs > Priority: 2 > FD Files Written: 313,953 > SD Files Written: 313,953 > FD Bytes Written: 105,350,298,497 (105.3 GB) > SD Bytes Written: 105,395,463,262 (105.3 GB) > Rate: 4248.0 KB/s > Software Compression: None > Volume name(s): Week_2_c1|Week_2_c2|Week_2_c3 > Volume Session Id: 8 > Volume Session Time: 1162907679 > Last Volume Bytes: 20,697,381,671 (20.69 GB) > Non-fatal FD errors: 0 > SD Errors: 0 > FD termination status: OK > SD termination status: OK > Termination: *** Backup Error *** > > 11-Nov 03:53 domaingtie-dir: Begin pruning Jobs. > 11-Nov 03:53 domaingtie-dir: No Jobs found to prune. > 11-Nov 03:53 domaingtie-dir: Begin pruning Files. > 11-Nov 03:53 domaingtie-dir: No Files found to prune. > 11-Nov 03:53 domaingtie-dir: End auto prune. > > How I can resolve? > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
