Bacula-users

Re: [Bacula-users] Checksum warnings during backup?

2010-07-05 11:37:08
Subject: Re: [Bacula-users] Checksum warnings during backup?
From: Andreas Koch <koch AT esa.informatik.tu-darmstadt DOT de>
To: Martin Simmons <martin AT lispworks DOT com>
Date: Mon, 05 Jul 2010 17:34:15 +0200
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/05/2010 03:50 PM, Martin Simmons wrote:
>>>>>> On Mon, 05 Jul 2010 13:10:17 +0200, Andreas Koch said:
>>
>> On 07/02/2010 04:52 PM, Martin Simmons wrote:
>>> It would be interesting to check the MD5 column in the output of the SQL 
>>> query
>>>
>>> SELECT Path.Path,Filename.Name,File.MD5 FROM File,Filename,Path WHERE 
>>> File.JobId=NNNN
>>>   AND Filename.FilenameId=File.FilenameId
>>>   AND Path.PathId=File.PathId ORDER BY
>>>   Path.Path,Filename.Name;
>>>
>>> when NNNN is the jobid of the Full backup (the column is called MD5, but it
>>> can also contain the SHA1 value).
>>
>>                  path                 |      name       |             md5 
>>  
>> -------------------------------------+-----------------+-----------------------------
>>   /usr/share/postgresql-8.4/man/man7/ |                 | 0
>>   /usr/share/postgresql-8.4/man/man7/ | I_AM_FAKE_AHK   | 
>> 9pJlAWgNbz4aM4vmduNmJkByLMU
>>   /usr/share/postgresql-8.4/man/man7/ | I_AM_FAKE_AHK_2 | 
>> 9pJlAWgNbz4aM4vmduNmJkByLMU
>>   /usr/share/postgresql-8.4/man/man7/ | I_AM_FAKE_AHK_3 | 
>> 9pJlAWgNbz4aM4vmduNmJkByLMU
>>   /usr/share/postgresql-8.4/man/man7/ | table.7.bz2     | 
>> EeaI7PgQNG2luduNX/wueQLoD7o
>> (5 rows)
>>
>> Here, the mysterious table.7.bz2 file does indeed have a checksum value.
> 
> That looks normal, so it is strange that the FD appears not to find the
> checksum.
> 
> Are those definitely the rows for the Full backup?  I'm a little surprised to
> see I_AM_FAKE_AHK_3.

Those are the three dummy files I created (all containing ``delete me'') to
mark the different differential backup runs.

Best,
  Andreas

> 
> __Martin
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkwx+3UACgkQk5ta2EV7DozieACfXN6/XlgDIkZqE5cwbopO5YjE
9vsAnRdgS7JnNbU7mmWB5iW0Pq/v3kn6
=wAnP
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users