]> git.evergreen-ils.org Git - Evergreen.git/commit
Make authority_control_fields.pl resistant to database timeouts
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 26 Apr 2011 14:12:46 +0000 (14:12 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 26 Apr 2011 14:12:46 +0000 (14:12 +0000)
commitb75dd4435c73dfb41561c2f48c8e2edf1c3dc770
treeb703482c1d3fe775950dc00ae750b1c58823a6b8
parent8eecfbf4903f2f95890bce1c4f3282ee94fbaabd
Make authority_control_fields.pl resistant to database timeouts

LP 771237 describes how on an underpowered system, the work that
authority_control_fields.pl tries to do on a per-record basis may hit the
CStore default timeout of 6 seconds for a transaction and automatically
end the transaction, resulting in no work being committed once the script tries
to update the bibliographic record. Searching each controlled field for a
matching authority record can be costly in a database with millions of
authority records.

To enable the script to accomplish its work on underpowered test systems, use a
regular read-only CStoreEditor session to accomplish the lookups and create a
separate CStoreEditor session to issue the update in a transaction if required.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
git-svn-id: svn://svn.open-ils.org/ILS/trunk@20311 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/support-scripts/authority_control_fields.pl