Hi, bacula-dir 2.0.3, bacula-sd 2.0.3, bacula-fd 2.0.2, debian etch amd64, postgres 8.1.7
I'm running dbcheck at the moment. The bacula postgres db is 1 GB. dbcheck needs very long time to check the orphaned Path entries. Checking for orphaned Path entries. This may take some time! Found 5472 orphaned Path records. Found 5472 orphaned Path records. Found 5472 orphaned Path records. Found 5472 orphaned Path records. Found 5472 orphaned Path records. Found 5472 orphaned Path records. Found 5472 orphaned Path records. Found 5472 orphaned Path records. [snip, same output for about an hour] After one hour I stopped dbcheck and enabled the verbose output. It shows the same output for every orphaned path (I only check the first 10 paths...) Found 5472 orphaned Path records. Print them? (yes/no): yes [snip] /home/rg/mysql.bacula/benchmark/ /home/rg/mysql.bacula/ /home/rg/mysql.bacula/bacula/ /home/rg/mysql.bacula/lost+found/ /home/rg/mysql.bacula/mysql/ Found 5472 orphaned Path records. Print them? (yes/no): yes [snip] /home/rg/mysql.bacula/benchmark/ /home/rg/mysql.bacula/ /home/rg/mysql.bacula/bacula/ /home/rg/mysql.bacula/lost+found/ /home/rg/mysql.bacula/mysql/ Found 5472 orphaned Path records. Print them? (yes/no): yes ...and so on. <http://www.bacula.org/dev-manual/Volume_Utility_Tools.html#SECTION0039120000000000000000> Orphaned Path records. This condition happens any time a directory is deleted from your system and all associated Job records have been purged. During standard purging (or pruning) of Job records, Bacula does not check for orphaned Path records. As a consequence, over a period of time, old unused Path records will tend to accumulate and use space in your database. This check will eliminate them. It is recommended that you run this check at least once a year. I know that dbcheck needs some time. But the db is not very large yet and all index are there. dbcheck seems to loop somehow. bacula=> select * from pg_indexes where tablename='file'; schemaname | tablename | indexname | tablespace | indexdef ------------+-----------+----------------+------------+------------------------------------------------------------------- public | file | file_fp_idx | | CREATE INDEX file_fp_idx ON file USING btree (filenameid, pathid) public | file | file_jobid_idx | | CREATE INDEX file_jobid_idx ON file USING btree (jobid) public | file | file_pkey | | CREATE UNIQUE INDEX file_pkey ON file USING btree (fileid) (3 Zeilen) Ralf ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/bacula-users
