Dear Eric
Thanks for the clue regarding queries.
I have just looked at the default set of queries I use
(examples/sample-query.sql) and noticed statements like
# 5
:List all backups for a Client
*Enter Client Name:
SELECT DISTINCT Job.JobId as JobId,Client.Name as Client,
FileSet.FileSet AS FileSet,Level,StartTime,
JobFiles,JobBytes,VolumeName
FROM Client,Job,JobMedia,Media,FileSet
WHERE Client.Name='%1'
AND Client.ClientId=Job.ClientId AND Job.Type='B'
AND Job.JobStatus='T' AND Job.FileSetId=FileSet.FileSetId
AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
ORDER BY Job.StartTime;
Note the Job.JobStatus='T' - need to change to (T,W) as you said.
I retract the that there is a problem with Bacula and warnings - it is
the query !!
Sorry
Stephen Carr
Eric Bollengier wrote:
Hello,
On 23/01/2012 11:37, Stephen G Carr wrote:
Dear Eric
I sent a later email and for got to add "Update" to the subject - the
migration of jobs with warnings do migrate to tape.
I am using the "standard" queries - will look at the syntax but why is a
job shown in a Volume with warnings but not "visible" when querying the
client?
Sorry, I don't understand where jobs are not visible, we might have a
display problem somewhere like in Bat or Bweb, but the core code
should handle everything properly.
Bye
Thanks
Stephen Carr
Eric Bollengier wrote:
Hello Stephen,
On 23/01/2012 09:08, Stephen G Carr wrote:
Dear All
Have anyone had similar problems with 5.2.4 with backup warnings - the
MAJOR problem seems that the Backup is NOT added to the catalog and
as I
backup clients to disc and migrate full backups to tape I suspect
these
jobs will not be migrated - the jobs migration jobs run tonight.
I would be nice to not just "suspect" when you are reporting a
potential
problem such as this one. Did you try to migrate new jobs? Did you get
any problem related to Bacula?
I have reverted to 5.2.3 and reran the Full backups of those clients
with warnings.
I accept there will be "dodgy" files on Windows clients but would
prefer
the backup to treated as a valid backup with respect to adding it
to the
Catalog and as a job valid for migration.
The Warning job status is treated like the Ok status. Unless you are
writing your own queries to migrate jobs, you shouldn't have problems.
So, if you are using a custom query, you can just replace JobStatus =
'T' by JobStatus IN ('T', 'W') as we did in other part of Bacula.
Bye
--
Stephen Carr
Computing Officer
School of Civil and Environmental Engineering
The University of Adelaide
Tel +618-8303-4313
Fax +618-8303-4359
Emailsgcarr < at > civeng.adelaide.edu.au
CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s)and
contains information that may be confidential and/or copyright.
If you are not the intended recipient please notify the sender
by reply email and immediately delete this email. Use, disclosure
or reproduction of this email by anyone other than the intended
recipient(s) is strictly prohibited. No representation is made
that this email or any attachments are free of viruses. Virus
scanning is recommended and is the responsibility of the recipient.
--
Stephen Carr
Computing Officer
School of Civil and Environmental Engineering
The University of Adelaide
Tel +618-8303-4313
Fax +618-8303-4359
Email sgcarr < at > civeng.adelaide.edu.au
CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s)and
contains information that may be confidential and/or copyright.
If you are not the intended recipient please notify the sender
by reply email and immediately delete this email. Use, disclosure
or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made
that this email or any attachments are free of viruses. Virus
scanning is recommended and is the responsibility of the recipient.
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
