One more real quick question about dbcheck: What is it intended that
the batch mode (-b) option do? I ASSUME it's intended to run without
interaction. This is not, however, the case:
babylon4:root:/opt/bacula/etc:4 # time ../sbin/dbcheck -c dir.conf -C
Catalog -b -f
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!
Note. Index over the PathId column not found, that can greatly slow down
dbcheck.
Create temporary index? (yes/no): ^C
(I was trying to time how long it takes to run in batch mode on a
reasonably clean DB, with an eye to running it as a weekly or monthly
admin job, since after gone several years without running it, it just
freed about a million rows total.)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
