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
