> >>>>> 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
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
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-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
