Re: [Bacula-users] missing a file during verification

[Martin S. <ma...@li...>]

>>>>> On Tue, 31 Jan 2012 11:02:59 -0800, Doug Sampson said:
> 
> > >>>>> On Mon, 30 Jan 2012 13:28:47 -0800, Doug Sampson said:
> > >
> > > Hello-
> > >
> > > Since upgrading to 5.2.3 from 5.0.3 on a FreeBSD 7.4 server two
> weeks
> > > ago, I've started seeing this message:
> > >
> > > 28-Jan 06:08 pisces-sd JobId 8299: End of Volume at file 1 on device
> > > "FileStoragecepheus" (/backup), Volume
> > > "Backup_cepheus-fd_2012-01-28_00.05.01"
> > > 28-Jan 06:08 pisces-sd JobId 8299: End of all volumes.
> > > 28-Jan 06:08 pisces-dir JobId 8299: Error: Bacula pisces-dir 5.2.3
> > > (16Dec11):
> > >   Build OS:               i386-portbld-freebsd7.4 freebsd
> 7.4-RELEASE-p3
> > >   JobId:                  8299
> > >   Job:                    cepheusVerifyData.2012-01-28_06.00.00_15
> > >   FileSet:                cepheus
> > >   Verify Level:           VolumeToCatalog
> > >   Client:                 cepheus-fd
> > >   Verify JobId:           8295
> > >   Verify Job:
> > >   Start time:             28-Jan-2012 06:00:00
> > >   End time:               28-Jan-2012 06:08:40
> > >   Files Expected:         989
> > >   Files Examined:         988
> > >   Non-fatal FD errors:    0
> > >   FD termination status:  OK
> > >   SD termination status:  OK
> > >   Termination:            *** Verify Error ***
> > >
> > > This is for a differential backup of a Windows machine each
> Saturday.
> > > The daily incremental backups appear to be fine. The machine
> 'cepheus'
> > > is a Windows 2003 server running Winbacula 5.2.3. Prior to upgrading
> to
> > > 5.2.3 on all Bacula devices, there were no errors reported on this
> > > instance.
> > >
> > > How do I turn on or increase logging to try to identify the reason
> for
> > > the skip? Or at least identify the file being skipped?
> > 
> > Check the log lines above the ones you posted.  Bacula should print
> > 
> > The following files are in the Catalog but not on the Volume(s):
> > 
> > followed by the list of them.
> > 
> > If not, what is your Message resource in the bacula-dir.conf?
> > 
> 
> Whoops. I thought I had copied the entire message for JobId 8299. I'm
> enclosing both JobId 8295 (the original backup job) and JobId 8299 (the
> verify job) here:
>  ...
> As you can see Bacula does not print anything indicating which file is
> not on the Volume. Message resource info below:
>  ...
> Does these help?

The messages look normal -- I would expect it to list them.

You could try the following SQL commands to get more info about what is in the
catalog for this job:

SELECT COUNT(*) FROM File
      WHERE File.JobId=8295;

SELECT COUNT(*) FROM File
      WHERE File.JobId=8295 AND File.FileIndex > 0;

SELECT Path.Path,Filename.Name FROM File,Path,Filename 
      WHERE File.JobId=8295 AND File.FileIndex > 0 
      AND File.MarkId!=8299 AND File.PathId=Path.PathId 
      AND File.FilenameId=Filename.FilenameId;

__Martin