Just to say that the difference problem I had between "Files Expected" and "Files Restored" has been resolved with a $> dbcheck
I don't understand why my database had inconsistencies (as I never had any hard reboot, electric cut or such) ... should dbcheck be executed at regular interval ? On Tue, 2007-07-24 at 05:25 +0300, Doytchin Spiridonov wrote: > Hello, > > Tuesday, July 24, 2007, 2:25:44 AM: > > FS> Doytchin Spiridonov wrote: > >> Hello, > >> > >> Monday, July 23, 2007, 9:02:21 PM: > >> > >> > >> FS> The first thing that I would try is unmounting the filesystem and > >> performing a > >> FS> full fsck on it, to rule out filesystem corruption. > >> > >> not a problem with the FS or disks, checked that. > >> > >> Checked the logical content of the volumes as well (bls -k -v) - no > >> errors. For curiosity as I don't know if bls should print errors if > >> content is damaged, I changed one random byte of one volume to "0", > >> run the bls and got an error: Block checksum mismatch in block=113 > >> len=64512: calc=2a576dc5 blk=44a509f3 > >> > >> So I would say the 3 problems (files with wrong size, missing files > >> and error about ID: "BB02") are not hardware/fs/disks related and are > >> caused by a bug in Bacula and it is related to wrong positioning in > >> the volumes and mismatched numbers. > > FS> Based on this and your other emails, I would next suspect a problem with > the > FS> catalog. Again, I'd start by making sure no errors have crept in by > doing a > FS> consistency check at the database level - a 'repair tables' in mysql, or > the > FS> equivalent in postgresql. > > > Not the case - we are doing daily DB dumps before backups and they > would crash if tables are damaged. No mysql error logs. The problem is > not in the MySQL or broken dbs. > > Regards. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
