On Tuesday 23 December 2008 15:28:16 JanJaap Scholing wrote: > Hello, > > Patch seems to work! > > Made one backup to disk, copied that job. > Job succesfull copied to tape. > Rerun the copy job, nothing to be copied. > > Thanks, I will keep on testing this week.
Thanks for the fast feedback. The problem is that I am not sure that Migration will work with the new Copy jobs -- we need to look into that some more ... Regards, Kern > > regards > > JanJaap > > > > > > ---------------------------------------- > > > From: [email protected] > > To: [email protected] > > Subject: Re: [Bacula-devel] copy jobs > > Date: Tue, 23 Dec 2008 15:04:37 +0100 > > CC: [email protected] > > > > Hello, > > > > I think a slightly better patch (partially handles prior copy jobs too) > > is attached. > > > > Regards, > > > > Kern > > > > On Tuesday 23 December 2008 14:32:02 JanJaap Scholing wrote: > >> Hi, > >> > >> It seems that the copy jobs PoolUncopiedJobs selection type is broken in > >> the 2.5.26 version. > >> > >> Every time when the copy job runs it makes an copy of the same jobs... > >> > >> Before the copy job I run the following sql query (just for my > >> information): > >> > >> SELECT DISTINCT Job.JobId,Job.StartTime FROM Job,Pool WHERE Pool.Name = > >> 'Virt-Pool' AND Pool.PoolId = Job.PoolId AND Job.Type = 'B' AND > >> Job.JobStatus = 'T' AND Job.JobId NOT IN (SELECT PriorJobId FROM Job > >> WHERE Type = 'B' AND Job.JobStatus = 'T' AND PriorJobId != 0) ORDER by > >> Job.StartTime; > >> > >> result: > >> > >> +-------+---------------------+ > >> > >> | JobId | StartTime | > >> > >> +-------+---------------------+ > >> > >> | 240 | 2008-12-22 14:30:09 | > >> | 243 | 2008-12-22 17:27:54 | > >> | 244 | 2008-12-22 23:11:38 | > >> | 246 | 2008-12-23 01:05:02 | > >> | 247 | 2008-12-23 01:11:57 | > >> | 248 | 2008-12-23 01:20:59 | > >> | 249 | 2008-12-23 01:22:21 | > >> | 250 | 2008-12-23 01:35:06 | > >> | 251 | 2008-12-23 02:05:02 | > >> | 252 | 2008-12-23 02:05:15 | > >> | 253 | 2008-12-23 02:35:21 | > >> | 254 | 2008-12-23 02:44:33 | > >> | 255 | 2008-12-23 03:05:02 | > >> | 256 | 2008-12-23 03:06:35 | > >> | 258 | 2008-12-23 05:05:02 | > >> | 259 | 2008-12-23 06:05:02 | > >> | 260 | 2008-12-23 06:10:28 | > >> | 332 | 2008-12-23 11:13:57 | > >> > >> +-------+---------------------+ > >> > >> Then I run the copy job > >> > >> After the copy job: > >> > >> SELECT DISTINCT Job.JobId,Job.StartTime FROM Job,Pool WHERE Pool.Name = > >> 'Virt-Pool' AND Pool.PoolId = Job.PoolId AND Job.Type = 'B' AND > >> Job.JobStatus = 'T' AND Job.JobId NOT IN (SELECT PriorJobId FROM Job > >> WHERE Type = 'B' AND Job.JobStatus = 'T' AND PriorJobId != 0) ORDER by > >> Job.StartTime; > >> > >> > >> > >> result: > >> > >> > >> > >> +-------+---------------------+ > >> > >> | JobId | StartTime | > >> > >> +-------+---------------------+ > >> > >> | 240 | 2008-12-22 14:30:09 | > >> | > >> | 243 | 2008-12-22 17:27:54 | > >> | > >> | 244 | 2008-12-22 23:11:38 | > >> | > >> | 246 | 2008-12-23 01:05:02 | > >> | > >> | 247 | 2008-12-23 01:11:57 | > >> | > >> | 248 | 2008-12-23 01:20:59 | > >> | > >> | 249 | 2008-12-23 01:22:21 | > >> | > >> | 250 | 2008-12-23 01:35:06 | > >> | > >> | 251 | 2008-12-23 02:05:02 | > >> | > >> | 252 | 2008-12-23 02:05:15 | > >> | > >> | 253 | 2008-12-23 02:35:21 | > >> | > >> | 254 | 2008-12-23 02:44:33 | > >> | > >> | 255 | 2008-12-23 03:05:02 | > >> | > >> | 256 | 2008-12-23 03:06:35 | > >> | > >> | 258 | 2008-12-23 05:05:02 | > >> | > >> | 259 | 2008-12-23 06:05:02 | > >> | > >> | 260 | 2008-12-23 06:10:28 | > >> | > >> | 332 | 2008-12-23 11:13:57 | > >> > >> +-------+---------------------+ > >> > >> The same jobs.... > >> > >> When I run the copy job again, the same jobs are copied to tape again.. > >> > >> /etc/bacula/bacula-dir.conf: > >> > >> > >> # > >> # Default template for a CopyDiskToTape Job > >> # > >> JobDefs { > >> Name = CopyDiskToTape > >> Type = Copy > >> Messages = Standard > >> Client = None > >> FileSet = None > >> Selection Type = PoolUncopiedJobs > >> Maximum Concurrent Jobs = 10 > >> SpoolData = No > >> Allow Duplicate Jobs = Yes > >> Allow Higher Duplicates = No > >> Cancel Queued Duplicates = No > >> Cancel Running Duplicates = No > >> Prefer Mounted Volumes = No > >> Priority = 10 > >> } > >> > >> Schedule { > >> Name = DaySchedule11:00 > >> Run = Level=Full daily at 11:00 > >> } > >> > >> Job { > >> Name = D2D2T > >> Enabled = Yes > >> Schedule = DaySchedule11:00 > >> Pool = Virt-Pool > >> JobDefs = CopyDiskToTape > >> Prefer Mounted Volumes = No > >> } > >> > >> Regards > >> > >> JanJaap > >> > >> > >> > >> > >> > >> _________________________________________________________________ > >> De leukste online filmpjes vind je op MSN Video! > >> http://video.msn.com/video.aspx?mkt=nl-nl > >> ------------------------------------------------------------------------ > >>--- --- _______________________________________________ > >> Bacula-devel mailing list > >> [email protected] > >> https://lists.sourceforge.net/lists/listinfo/bacula-devel > > _________________________________________________________________ > Download de nieuwste emoticons voor in je Messenger > http://www.msnmessengerexperience.nl/chuck/ > --------------------------------------------------------------------------- >--- _______________________________________________ > Bacula-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-devel ------------------------------------------------------------------------------ _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
