Backup Central

I'm still having issue with a copy job.
I'm trying to copy a job using this selection query:

SELECT * FROM Job WHERE (EndTime BETWEEN NOW() - INTERVAL 40 DAY AND
NOW()) AND Type = 'B' AND Level = 'F' AND (JobStatus = 'e' OR JobStatus
= 'T') AND Name = 'myclient-job' GROUP BY Name;

This query seems to be ok, because i'm getting the proper JobID when ran
from MySQL.

Even the copy job seems to be ok:

03-Jul 15:00 b01-dir JobId 16833: The following 1 JobId was chosen to be
copied: 15487
03-Jul 15:00 b01-dir JobId 16833: Copying using JobId=15487
Job=myclient-job.2012-06-03_00.30.00_18
03-Jul 15:00 b01-dir JobId 16833: Bootstrap records written
to /var/lib/bacula/b01-dir.restore.2.bsr
03-Jul 15:00 b01-dir JobId 16833: Start Copying JobId 16833,
Job=myclient-TapeCopyFull.2012-07-03_15.00.00_06
03-Jul 15:00 b01-dir JobId 16833: Using Device "TL2000-LTO4-1"


Job 15487 is the same coming from MySQL query.

What i don't understand is why bacula is sending me this mail:

---
Subject: Backup OK per myclient-fd Full

03-Jul 15:00 b01-dir JobId 16834: No prior Full backup Job record found.
03-Jul 15:00 b01-dir JobId 16834: No prior or suitable Full backup found
in catalog. Doing FULL backup.
---

Is this ok? I don't want to run a new Full backup for every copy.











------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

On Tue, Jul 03, 2012 at 03:06:48PM +0200, Gandalf Corvotempesta wrote:
I'm still having issue with a copy job.
I'm trying to copy a job using this selection query:


Hello Gandalf,

can you post your copy job definition? Have you checked if a full
*client* backup is started after that message or wether it's just some
remnant from the copy job start?

Cheers, Uwe

SELECT * FROM Job WHERE (EndTime BETWEEN NOW() - INTERVAL 40 DAY AND
NOW()) AND Type = 'B' AND Level = 'F' AND (JobStatus = 'e' OR JobStatus
= 'T') AND Name = 'myclient-job' GROUP BY Name;

This query seems to be ok, because i'm getting the proper JobID when ran
from MySQL.

Even the copy job seems to be ok:

03-Jul 15:00 b01-dir JobId 16833: The following 1 JobId was chosen to be
copied: 15487
03-Jul 15:00 b01-dir JobId 16833: Copying using JobId=15487
Job=myclient-job.2012-06-03_00.30.00_18
03-Jul 15:00 b01-dir JobId 16833: Bootstrap records written
to /var/lib/bacula/b01-dir.restore.2.bsr
03-Jul 15:00 b01-dir JobId 16833: Start Copying JobId 16833,
Job=myclient-TapeCopyFull.2012-07-03_15.00.00_06
03-Jul 15:00 b01-dir JobId 16833: Using Device "TL2000-LTO4-1"


Job 15487 is the same coming from MySQL query.

What i don't understand is why bacula is sending me this mail:

---
Subject: Backup OK per myclient-fd Full

03-Jul 15:00 b01-dir JobId 16834: No prior Full backup Job record found.
03-Jul 15:00 b01-dir JobId 16834: No prior or suitable Full backup found
in catalog. Doing FULL backup.
---

Is this ok? I don't want to run a new Full backup for every copy.











------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Il giorno mar, 03/07/2012 alle 15.30 +0200, Uwe Schuerkamp ha scritto:
can you post your copy job definition?

Job {
Name = "myclient-TapeCopyFull"
Type = Copy
Pool = myclient-FullPool
#Level = Full
Client = myclient-fd
Fileset = None
Priority = 11
SpoolData = No
Selection Type = SQLQuery
Selection Pattern = "SELECT * FROM Job WHERE (EndTime BETWEEN NOW() -
INTERVAL 40 DAY AND NOW()) AND Type = 'B' AND Level = 'F' AND (JobStatus
= 'e' OR JobStatus = 'T') AND Name = 'myclient-job' GROUP BY Name;"
Messages = Standard
Storage = myclient-Storage
Write Bootstrap =
"/var/bacula/backups/clients/myclient/myclient-tape.bsr"
Schedule = "CopyTapeFull"
}



Have you checked if a full
*client* backup is started after that message or wether it's just some
remnant from the copy job start?

The full client backup is not run, as far as I can see.
A full backup will take many many hours and actually the copy jobs
ends in a couple of minutes.


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

On Tue, Jul 03, 2012 at 07:14:36PM +0200, Gandalf Corvotempesta wrote:

The full client backup is not run, as far as I can see.
A full backup will take many many hours and actually the copy jobs
ends in a couple of minutes.

If the copy job finishes successfully, I'd simply ignore the "starting
full backup" job message


Cheers, Uwe

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Il giorno gio, 05/07/2012 alle 13.58 +0200, Uwe Schuerkamp ha scritto:
If the copy job finishes successfully, I'd simply ignore the "starting
full backup" job message


Ok, but this is not an answer
I would like to know why bacula is telling me that a new full backup
is being made in case of copy.

This sounds like a bug.


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users