>>>>> On Thu, 2 Feb 2012 13:11:15 -0800, Doug Sampson said:
>
> > >>>>> 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;
> >
>
>
> $ psql bacula
> Welcome to psql 8.3.16, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> bacula=# SELECT COUNT(*) FROM File
> bacula-# WHERE File.JobId=8295;
> count
> -------
> 988
> (1 row)
>
> bacula=# SELECT COUNT(*) FROM File
> bacula-# WHERE File.JobId=8295 AND File.FileIndex > 0;
> count
> -------
> 988
> (1 row)
>
> bacula=# SELECT Path.Path,Filename.Name FROM File,Path,Filename
> bacula-# WHERE File.JobId=8295 AND File.FileIndex > 0
> bacula-# AND File.MarkId!=8299 AND File.PathId=Path.PathId
> bacula-# AND File.FilenameId=Filename.FilenameId;
> path | name
> ------+------
> (0 rows)
>
> bacula=#
>
>
> Um, so where's the error coming from?
>
> ~Doug
>
The error occurs because Bacula thinks there are 989 files in the backup,
though only 988 were recorded in the File table.
What is the fileset definition?
What does the following SQL command print?
SELECT MIN(FileIndex), MAX(FileIndex) FROM File WHERE JobId=8295;
You could try to compare the list of files printed by
list files jobid=8295
with the output of the bls command for the volume containing that job (that
will print the files from all jobs on the volume, so you will have to filter
it).
__Martin
------------------------------------------------------------------------------
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 DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
