Hi all,
Bacula 9.6.7 on Debian 11.
Every 3 months I run "dbcheck -f -c /etc/bacula/bacula-dir.conf"
Last time 32,525 orphaned filename records were found and deleted and
the count was 27,550 before that.
Today I got:
dbcheck -f -c /etc/bacula/bacula-dir.conf
Hello, this is the database check/correct program.
Modify database is on. Verbose is off.
Please select the function you want to perform.
1) Toggle modify database flag
2) Toggle verbose flag
3) Repair bad Filename records
4) Repair bad Path records
5) Eliminate duplicate Filename records
6) Eliminate duplicate Path records
7) Eliminate orphaned Jobmedia records
8) Eliminate orphaned File records
9) Eliminate orphaned Path records
10) Eliminate orphaned Filename records
11) Eliminate orphaned FileSet records
12) Eliminate orphaned Client records
13) Eliminate orphaned Job records
14) Eliminate all Admin records
15) Eliminate all Restore records
16) Eliminate all Verify records
17) All (3-16)
18) Quit
Select function number: 17
Checking for Filenames with a trailing slash
Found 0 bad Filename records.
Checking for Paths without a trailing slash
Found 0 bad Path records.
Checking for duplicate Filename entries.
Found 0 duplicate Filename records.
Checking for duplicate Path entries.
Found 0 duplicate Path records.
Checking for orphaned JobMedia entries.
Checking for orphaned File entries. This may take some time!
To prune orphaned Path entries, it is necessary to clear the BVFS Cache
first with the bconsole ".bvfs_clear_cache yes" command.
Note. Index over the FilenameId column not found, that can greatly slow
down dbcheck.
Create temporary index? (yes/no): yes
Create temporary index... This may take some time!
Checking for orphaned Filename entries. This may take some time!
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 300000 orphaned Filename records.
Deleting 300000 orphaned Filename records.
Found 45187 orphaned Filename records.
Deleting 45187 orphaned Filename records.
Drop temporary index.
Checking for orphaned FileSet entries. This takes some time!
Found 0 orphaned FileSet records.
Checking for orphaned Client entries.
Found 0 orphaned Client records.
Checking for orphaned Job entries.
Found 0 orphaned Job records.
Checking for Admin Job entries.
Found 0 Admin Job records.
Checking for Restore Job entries.
Found 1 Restore Job records.
Deleting 1 Restore Job records.
Checking for Verify Job entries.
Found 0 Verify Job records.
1) Toggle modify database flag
2) Toggle verbose flag
3) Repair bad Filename records
4) Repair bad Path records
5) Eliminate duplicate Filename records
6) Eliminate duplicate Path records
7) Eliminate orphaned Jobmedia records
8) Eliminate orphaned File records
9) Eliminate orphaned Path records
10) Eliminate orphaned Filename records
11) Eliminate orphaned FileSet records
12) Eliminate orphaned Client records
13) Eliminate orphaned Job records
14) Eliminate all Admin records
15) Eliminate all Restore records
16) Eliminate all Verify records
17) All (3-16)
18) Quit
Select function number: 18
Q1
There have been no major changes in terms of clients and datasets. What
could possibly justify a jump from 32,525 to 8,745,187 in 3 months?
Q2
I have never run ".bvfs_clear_cache yes" before typing yes.
Is it really a necessary step requiring opening a second shell and
running this command manually?
Is there any reason this step hasn't been directly incorporated into
"dbcheck"?
Regards,
Adam
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
