[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Bacula-devel] copy jobs


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.

regards

JanJaap





----------------------------------------
> From: kern@xxxxxxxxxxx
> To: bacula-devel@xxxxxxxxxxxxxxxxxxxxx
> Subject: Re: [Bacula-devel] copy jobs
> Date: Tue, 23 Dec 2008 15:04:37 +0100
> CC: janjaapscholing@xxxxxxxxxxx
>
> 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
>> Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
>> 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
Bacula-devel@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/bacula-devel


This mailing list archive is a service of Copilotco.