Checksum Checker is program that can run to verify the checksum of every item within DSpace. Checksum Checker was designed with the idea that most System Administrators will run it from the cron. Depending on the size of the repository choose the options wisely.
Arguments short and (long) forms):
Loop continuously through the bitstreams
Specify a handle to check
Space separated list of bitstream IDs
Calls online help
Loop once through bitstreams
Prune old results (optionally using specified properties file for configuration
Report all processing
There are three aspects of the Checksum Checker's operation that can be configured:
- Limited-count mode:
[dspace]/bin/dspace checker -cTo check a specific number of bitstreams. The -c option if followed by an integer, the number of bitstreams to check. Example:
[dspace/bin/dspace checker -c 10This is particularly useful for checking that the checker is executing properly. The Checksum Checker's default execution mode is to check a single bitstream, as if the option was -c 1
[dspace]/bin/dspace checker -dTo run the Check for a specific period of time with a time argument. You may use any of the time arguments below: Example:
[dspace/bin/dspace checker -d 2h(Checker will run for 2 hours)
The checker will keep starting new bitstream checks for the specific durations, so actual execution duration will be slightly longer than the specified duration. Bear this in mind when scheduling checks.
- Specific Bitstream mode:
[dspace]/bin/dspace checker -bChecker will only look at the internal bitstream IDs. Example:
[dspace]/bin/dspace checker -b 112 113 4567Checker will only check bitstream IDs 112, 113 and 4567.
- Specific Handle mode:
[dspace]/bin/dspace checker -aChecker will only check bitstreams within the Community, Community or the item itself. Example:
[dspace]/bin/dspace checker -a 123456/999Checker will only check this handle. If it is a Collection or Community, it will run through the entire Collection or Community.
- Looping mode:
[dspace]/bin/dspace checker -lor
[dspace]/bin/dspace checker -LThere are two modes. The lowercase 'el' (-l) specifies to check every bitstream in the repository once. This is recommended for smaller repositories who are able to loop through all their content in just a few hours maximum. An uppercase 'L' (-L) specifies to continuously loops through the repository. This is not recommended for most repository systems. Cron Jobs. For large repositories that cannot be completely checked in a couple of hours, we recommend the -d option in cron.
- Pruning mode:
[dspace]/bin/dspace checker -pThe Checksum Checker will store the result of every check in the checksum_history table. By default, successful checksum matches that are eight weeks old or older will be deleted when the -p option is used. (Unsuccessful ones will be retained indefinitely). Without this option, the retention settings are ignored and the database table may grow rather large!
Optionally, you may choose to receive automated emails listing the Checksum Checkers' results to the email address specified in the
mail.admin configuration property. Schedule it to run after the Checksum Checker has completed its processing (otherwise the email may not contain all the results). As of DSpace 4.1, an email is only generated if the selected report contains at least one bitstream needing attention.
Arguments short and (long) forms):
Send all the results (everything specified below)
Send E-mail report for all bitstreams set as deleted for today.
Send E-mail report for all bitstreams not found in assetstore for today.
Send E-mail report for all bitstreams where checksum has been changed for today.
Send the Unchecked bitstream report.
Send E-mail report for all bitstreams set to longer be processed for today.
You can also combine options (e.g.
-m -c) for combined reports.
SELECT ch.process_start_date, ch.process_end_date, ch.result, ch.checksum_expected, ch.checksum_calculated, b.bitstream_id, bfr.short_description, b.store_number, substring(b.internal_id for 2) || '/' || substring(b.internal_id from 3 for 2) || '/' || substring(b.internal_id from 5 for 2) || '/' || b.internal_id AS bitstream_path, hi.handle AS item_handle, hc.handle AS collection_handle FROM checksum_history ch JOIN bitstream b ON ch.bitstream_id = b.bitstream_iduuid JOIN bitstreamformatregistry bfr ON b.bitstream_format_id = bfr.bitstream_format_id LEFT JOIN bundle2bitstream bb ON b.bitstream_iduuid = bb.bitstream_id LEFT JOIN item2bundle ib ON bb.bundle_id = ib.bundle_id LEFT JOIN item i ON ib.item_id = i.item_iduuid LEFT JOIN handle hi ON i.item_iduuid = hi.resource_id AND hi.resource_type_id = 2 LEFT JOIN handle hc ON i.owning_collection = hc.resource_id AND hc.resource_type_id = 3 WHERE ch.result != 'CHECKSUM_MATCH' AND date_trunc('day', process_start_date) = CURRENT_DATE ORDER BY ch.check_id DESC;