Hey guys, I recently removed a few (<10) old clients (deleted job and client config files) and then started bareos-dbcheck (with director shut down) to get rid of the orphaned database records. My problem is: it takes forever. Yesterday dbcheck ran the whole day until i aborted to allow the nightly backups to run, and today it also didn't manage to pull through.
The output is as follows: /usr/sbin/bareos-dbcheck -c /etc/bareos/bareos-dir.conf -b -f -D mysql Checking for Paths without a trailing slash Found 0 bad Path records. Checking for Filenames with a trailing slash Found 0 bad Filename 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! Pruning orphaned Path entries isn't possible when using BVFS. 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. and so on... We use mysql, the 12gb big database is on an SSD storage and I created indexes as stated in the bareos documentation: http://doc.bareos.org/master/html/bareos-manual-main-reference.html#x1-45000032.5.2 So does anyone have a clue why bareos-dbcheck takes this long? Any help would be greatly appreciated! -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
