Re: [Bacula-users] virtuafull and verify
On Fri, Nov 13, 2009 at 09:02:11AM +0100, Fahrer, Julian wrote: Hey guys, I am currently trying to implement verify jobs at a customer's site. At that site I am running fulls and incrementals to disk and virtual fulls to tape. I want to verify that the data on tape is ok. So tried a verify job after the virtual full has finished. But instead of using the virtual full (which is the last backup for that job) the last backup to disk is choosen. Here is an Example: 13-Nov 08:23 backup01_dir JobId 3039: Verifying against JobId=3017 Job=server2_KHK.2009-11-12_21.00.00_06 13-Nov 08:23 backup01_dir JobId 3039: Bootstrap records written to /var/bacula/working/backup01_dir.restore.1.bsr 13-Nov 08:23 backup01_dir JobId 3039: Start Verify JobId=3039 Level=VolumeToCatalog Job=server2_KHK_verify.2009-11-13_08.23.43_03 13-Nov 08:23 backup01_dir JobId 3039: Using Device LTO2 13-Nov 08:23 backup01_sd JobId 3039: acquire.c:116 Changing read device. Want Media Type=File have=LTO2 device=LTO2 (/dev/nst0) 13-Nov 08:23 backup01_sd JobId 3039: Media Type change. New read device FileStorage_data2 (/data2/b2d_2) chosen. 13-Nov 08:23 backup01_sd JobId 3039: Ready to read from volume KHK_0030 on device FileStorage_data2 (/data2/b2d_2). Also there is another Job: | 3,017 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,399,178,034 | T | | 3,033 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,402,307,154 | T | Jobid 3033 is the Virtual Full. Can the same value in the date column cause this problem? Let me know if you need any parts of the config. This looks to me like the same problem that I was complaining about in the thread starting here: http://www.mail-archive.com/bacula-de...@lists.sourceforge.net/msg05013.html Basically, bacula fuzzily selects things based on date, rather than specific JobIds. :( I've just sent a new message to the bacula-devel list, which includes your message above. -- 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
Re: [Bacula-users] virtuafull and verify
Hey, yes it seems tob e the same problem. The sql statement in the sub db_find_last_jobid is: SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND Name='%s' ORDER BY StartTime DESC LIMIT 1, Name); I think changing it to something like SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND Name='%s' ORDER BY StartTime DESC, JobId DESC LIMIT 1, Name); would fix the problem for me right now. But I am not sure what problems would occure then... Thanks for submitting my mail to the devil list Kind Regards Julian -Ursprüngliche Nachricht- Von: Graham Keeling [mailto:gra...@equiinet.com] Gesendet: Mittwoch, 18. November 2009 10:10 An: bacula-users@lists.sourceforge.net Betreff: Re: [Bacula-users] virtuafull and verify On Fri, Nov 13, 2009 at 09:02:11AM +0100, Fahrer, Julian wrote: Hey guys, I am currently trying to implement verify jobs at a customer's site. At that site I am running fulls and incrementals to disk and virtual fulls to tape. I want to verify that the data on tape is ok. So tried a verify job after the virtual full has finished. But instead of using the virtual full (which is the last backup for that job) the last backup to disk is choosen. Here is an Example: 13-Nov 08:23 backup01_dir JobId 3039: Verifying against JobId=3017 Job=server2_KHK.2009-11-12_21.00.00_06 13-Nov 08:23 backup01_dir JobId 3039: Bootstrap records written to /var/bacula/working/backup01_dir.restore.1.bsr 13-Nov 08:23 backup01_dir JobId 3039: Start Verify JobId=3039 Level=VolumeToCatalog Job=server2_KHK_verify.2009-11-13_08.23.43_03 13-Nov 08:23 backup01_dir JobId 3039: Using Device LTO2 13-Nov 08:23 backup01_sd JobId 3039: acquire.c:116 Changing read device. Want Media Type=File have=LTO2 device=LTO2 (/dev/nst0) 13-Nov 08:23 backup01_sd JobId 3039: Media Type change. New read device FileStorage_data2 (/data2/b2d_2) chosen. 13-Nov 08:23 backup01_sd JobId 3039: Ready to read from volume KHK_0030 on device FileStorage_data2 (/data2/b2d_2). Also there is another Job: | 3,017 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,399,178,034 | T | | 3,033 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,402,307,154 | T | Jobid 3033 is the Virtual Full. Can the same value in the date column cause this problem? Let me know if you need any parts of the config. This looks to me like the same problem that I was complaining about in the thread starting here: http://www.mail-archive.com/bacula-de...@lists.sourceforge.net/msg05013.html Basically, bacula fuzzily selects things based on date, rather than specific JobIds. :( I've just sent a new message to the bacula-devel list, which includes your message above. -- 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 -- 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
Re: [Bacula-users] virtuafull and verify
On Wed, Nov 18, 2009 at 11:29:38AM +0100, Fahrer, Julian wrote: Hey, yes it seems tob e the same problem. The sql statement in the sub db_find_last_jobid is: SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND Name='%s' ORDER BY StartTime DESC LIMIT 1, Name); I think changing it to something like SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND Name='%s' ORDER BY StartTime DESC, JobId DESC LIMIT 1, Name); would fix the problem for me right now. But I am not sure what problems would occure then... The obvious problem is that you wouldn't be able to verify the original job. :) Thanks for submitting my mail to the devil list -- 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
Re: [Bacula-users] virtuafull and verify
What would be ok, since the idea behind the verify job is to verify the last job... Running a verify before the virtualfull would check the original job. I just compiled it with the sql statement below. The verify just selected the right jobid... -Ursprüngliche Nachricht- Von: Graham Keeling [mailto:gra...@equiinet.com] Gesendet: Mittwoch, 18. November 2009 11:42 An: bacula-users@lists.sourceforge.net Betreff: Re: [Bacula-users] virtuafull and verify On Wed, Nov 18, 2009 at 11:29:38AM +0100, Fahrer, Julian wrote: Hey, yes it seems tob e the same problem. The sql statement in the sub db_find_last_jobid is: SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND Name='%s' ORDER BY StartTime DESC LIMIT 1, Name); I think changing it to something like SELECT JobId FROM Job WHERE Type='B' AND JobStatus IN ('T','W') AND Name='%s' ORDER BY StartTime DESC, JobId DESC LIMIT 1, Name); would fix the problem for me right now. But I am not sure what problems would occure then... The obvious problem is that you wouldn't be able to verify the original job. :) Thanks for submitting my mail to the devil list -- 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 -- 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
Re: [Bacula-users] virtuafull and verify
Is no one using verify jobs for virtual fulls? -Ursprüngliche Nachricht- Von: Fahrer, Julian [mailto:jul...@fahrer.net] Gesendet: Freitag, 13. November 2009 09:02 An: bacula-users@lists.sourceforge.net Betreff: [Bacula-users] virtuafull and verify Hey guys, I am currently trying to implement verify jobs at a customer's site. At that site I am running fulls and incrementals to disk and virtual fulls to tape. I want to verify that the data on tape is ok. So tried a verify job after the virtual full has finished. But instead of using the virtual full (which is the last backup for that job) the last backup to disk is choosen. Here is an Example: 13-Nov 08:23 backup01_dir JobId 3039: Verifying against JobId=3017 Job=server2_KHK.2009-11-12_21.00.00_06 13-Nov 08:23 backup01_dir JobId 3039: Bootstrap records written to /var/bacula/working/backup01_dir.restore.1.bsr 13-Nov 08:23 backup01_dir JobId 3039: Start Verify JobId=3039 Level=VolumeToCatalog Job=server2_KHK_verify.2009-11-13_08.23.43_03 13-Nov 08:23 backup01_dir JobId 3039: Using Device LTO2 13-Nov 08:23 backup01_sd JobId 3039: acquire.c:116 Changing read device. Want Media Type=File have=LTO2 device=LTO2 (/dev/nst0) 13-Nov 08:23 backup01_sd JobId 3039: Media Type change. New read device FileStorage_data2 (/data2/b2d_2) chosen. 13-Nov 08:23 backup01_sd JobId 3039: Ready to read from volume KHK_0030 on device FileStorage_data2 (/data2/b2d_2). Also there is another Job: | 3,017 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,399,178,034 | T | | 3,033 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,402,307,154 | T | Jobid 3033 is the Virtual Full. Can the same value in the date column cause this problem? Let me know if you need any parts of the config. Kind regards Julian -Ursprüngliche Nachricht- Von: r...@backup01.hettenbach.local [mailto:r...@backup01.hettenbach.local] Im Auftrag von backup-adm...@hettenbach.de Gesendet: Freitag, 13. November 2009 08:29 An: backup-adm...@hettenbach.de Betreff: Bacula: Verify OK - Job: server2_KHK_verify.2009-11-13_08.23.43_03 (backup01_fd - Verify Volume to Catalog) 13-Nov 08:23 backup01_dir JobId 3039: Verifying against JobId=3017 Job=server2_KHK.2009-11-12_21.00.00_06 13-Nov 08:23 backup01_dir JobId 3039: Bootstrap records written to /var/bacula/working/backup01_dir.restore.1.bsr 13-Nov 08:23 backup01_dir JobId 3039: Start Verify JobId=3039 Level=VolumeToCatalog Job=server2_KHK_verify.2009-11-13_08.23.43_03 13-Nov 08:23 backup01_dir JobId 3039: Using Device LTO2 13-Nov 08:23 backup01_sd JobId 3039: acquire.c:116 Changing read device. Want Media Type=File have=LTO2 device=LTO2 (/dev/nst0) 13-Nov 08:23 backup01_sd JobId 3039: Media Type change. New read device FileStorage_data2 (/data2/b2d_2) chosen. 13-Nov 08:23 backup01_sd JobId 3039: Ready to read from volume KHK_0030 on device FileStorage_data2 (/data2/b2d_2). 13-Nov 08:23 backup01_sd JobId 3039: Forward spacing Volume KHK_0030 to file:block 0:197. 13-Nov 08:28 backup01_sd JobId 3039: End of file 3 on device FileStorage_data2 (/data2/b2d_2), Volume KHK_0030 13-Nov 08:28 backup01_sd JobId 3039: End of Volume at file 3 on device FileStorage_data2 (/data2/b2d_2), Volume KHK_0030 13-Nov 08:28 backup01_sd JobId 3039: End of all volumes. 13-Nov 08:28 backup01_dir JobId 3039: Bacula backup01_dir 3.0.1 (30Apr09): 13-Nov-2009 08:28:52 Build OS: i686-pc-linux-gnu ubuntu 8.04 JobId: 3039 Job:server2_KHK_verify.2009-11-13_08.23.43_03 FileSet:server2_KHK Verify Level: VolumeToCatalog Client: backup01_fd Verify JobId: 3017 Verify Job: server2_KHK Start time: 13-Nov-2009 08:23:45 End time: 13-Nov-2009 08:28:52 Files Expected: 19,243 Files Examined: 19,243 Non-fatal FD errors:0 FD termination status: OK SD termination status: OK Termination:Verify OK 13-Nov 08:28 backup01_dir JobId 3039: Begin pruning Jobs. 13-Nov 08:28 backup01_dir JobId 3039: No Jobs found to prune. 13-Nov 08:28 backup01_dir JobId 3039: Begin pruning Files. 13-Nov 08:28 backup01_dir JobId 3039: No Files found to prune. 13-Nov 08:28 backup01_dir JobId 3039: End auto prune. -- 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 -- Let Crystal
Re: [Bacula-users] virtuafull and verify
Fahrer, Julian jul...@fahrer.net writes: Is no one using verify jobs for virtual fulls? FWIW I do, and I have the same problem. I’m using version 3.0.2. What version are you using? Have you tested the newest version (3.0.3), yet? I don’t have much time at the moment but if no one knows a solution we should perhaps raise this issue on the devel list or file a bug. HTH, Tobias -- 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
[Bacula-users] virtuafull and verify
Hey guys, I am currently trying to implement verify jobs at a customer's site. At that site I am running fulls and incrementals to disk and virtual fulls to tape. I want to verify that the data on tape is ok. So tried a verify job after the virtual full has finished. But instead of using the virtual full (which is the last backup for that job) the last backup to disk is choosen. Here is an Example: 13-Nov 08:23 backup01_dir JobId 3039: Verifying against JobId=3017 Job=server2_KHK.2009-11-12_21.00.00_06 13-Nov 08:23 backup01_dir JobId 3039: Bootstrap records written to /var/bacula/working/backup01_dir.restore.1.bsr 13-Nov 08:23 backup01_dir JobId 3039: Start Verify JobId=3039 Level=VolumeToCatalog Job=server2_KHK_verify.2009-11-13_08.23.43_03 13-Nov 08:23 backup01_dir JobId 3039: Using Device LTO2 13-Nov 08:23 backup01_sd JobId 3039: acquire.c:116 Changing read device. Want Media Type=File have=LTO2 device=LTO2 (/dev/nst0) 13-Nov 08:23 backup01_sd JobId 3039: Media Type change. New read device FileStorage_data2 (/data2/b2d_2) chosen. 13-Nov 08:23 backup01_sd JobId 3039: Ready to read from volume KHK_0030 on device FileStorage_data2 (/data2/b2d_2). Also there is another Job: | 3,017 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,399,178,034 | T | | 3,033 | server2_KHK | 2009-11-12 21:00:01 | B| F | 19,243 | 14,402,307,154 | T | Jobid 3033 is the Virtual Full. Can the same value in the date column cause this problem? Let me know if you need any parts of the config. Kind regards Julian -Ursprüngliche Nachricht- Von: r...@backup01.hettenbach.local [mailto:r...@backup01.hettenbach.local] Im Auftrag von backup-adm...@hettenbach.de Gesendet: Freitag, 13. November 2009 08:29 An: backup-adm...@hettenbach.de Betreff: Bacula: Verify OK - Job: server2_KHK_verify.2009-11-13_08.23.43_03 (backup01_fd - Verify Volume to Catalog) 13-Nov 08:23 backup01_dir JobId 3039: Verifying against JobId=3017 Job=server2_KHK.2009-11-12_21.00.00_06 13-Nov 08:23 backup01_dir JobId 3039: Bootstrap records written to /var/bacula/working/backup01_dir.restore.1.bsr 13-Nov 08:23 backup01_dir JobId 3039: Start Verify JobId=3039 Level=VolumeToCatalog Job=server2_KHK_verify.2009-11-13_08.23.43_03 13-Nov 08:23 backup01_dir JobId 3039: Using Device LTO2 13-Nov 08:23 backup01_sd JobId 3039: acquire.c:116 Changing read device. Want Media Type=File have=LTO2 device=LTO2 (/dev/nst0) 13-Nov 08:23 backup01_sd JobId 3039: Media Type change. New read device FileStorage_data2 (/data2/b2d_2) chosen. 13-Nov 08:23 backup01_sd JobId 3039: Ready to read from volume KHK_0030 on device FileStorage_data2 (/data2/b2d_2). 13-Nov 08:23 backup01_sd JobId 3039: Forward spacing Volume KHK_0030 to file:block 0:197. 13-Nov 08:28 backup01_sd JobId 3039: End of file 3 on device FileStorage_data2 (/data2/b2d_2), Volume KHK_0030 13-Nov 08:28 backup01_sd JobId 3039: End of Volume at file 3 on device FileStorage_data2 (/data2/b2d_2), Volume KHK_0030 13-Nov 08:28 backup01_sd JobId 3039: End of all volumes. 13-Nov 08:28 backup01_dir JobId 3039: Bacula backup01_dir 3.0.1 (30Apr09): 13-Nov-2009 08:28:52 Build OS: i686-pc-linux-gnu ubuntu 8.04 JobId: 3039 Job:server2_KHK_verify.2009-11-13_08.23.43_03 FileSet:server2_KHK Verify Level: VolumeToCatalog Client: backup01_fd Verify JobId: 3017 Verify Job: server2_KHK Start time: 13-Nov-2009 08:23:45 End time: 13-Nov-2009 08:28:52 Files Expected: 19,243 Files Examined: 19,243 Non-fatal FD errors:0 FD termination status: OK SD termination status: OK Termination:Verify OK 13-Nov 08:28 backup01_dir JobId 3039: Begin pruning Jobs. 13-Nov 08:28 backup01_dir JobId 3039: No Jobs found to prune. 13-Nov 08:28 backup01_dir JobId 3039: Begin pruning Files. 13-Nov 08:28 backup01_dir JobId 3039: No Files found to prune. 13-Nov 08:28 backup01_dir JobId 3039: End auto prune. -- 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