From 040c8fd997bb153dcbfe9af9919a190b70d7a1c8 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 18 Dec 2014 13:46:54 -0500 Subject: [PATCH] JBAS-258 various utility server script repairs * Give all batch SQL scripts a 0 statement timeout * Avoid cd'ing into nonexistent directories Signed-off-by: Bill Erickson --- KCLS/utility-scripts/copy_loc_fix/fix_copy_locations.sql | 2 ++ KCLS/utility-scripts/copy_loc_fix/run_copy_location_fix.sh | 3 +-- KCLS/utility-scripts/del_empty_vol/del_all_empty_vols.sql | 2 ++ KCLS/utility-scripts/inactive_cards/remove_inactive_patron_cards.sql | 3 +++ KCLS/utility-scripts/reshelving/reshelving.sh | 3 +-- 5 files changed, 9 insertions(+), 4 deletions(-) diff --git a/KCLS/utility-scripts/copy_loc_fix/fix_copy_locations.sql b/KCLS/utility-scripts/copy_loc_fix/fix_copy_locations.sql index d4443a2f7e..e774f53f89 100644 --- a/KCLS/utility-scripts/copy_loc_fix/fix_copy_locations.sql +++ b/KCLS/utility-scripts/copy_loc_fix/fix_copy_locations.sql @@ -2,6 +2,8 @@ BEGIN; +SET SESSION STATEMENT_TIMEOUT TO 0; + UPDATE asset.copy a SET location = c.id FROM asset.copy_location b, asset.copy_location c diff --git a/KCLS/utility-scripts/copy_loc_fix/run_copy_location_fix.sh b/KCLS/utility-scripts/copy_loc_fix/run_copy_location_fix.sh index ebb33908ba..f50ad9b344 100755 --- a/KCLS/utility-scripts/copy_loc_fix/run_copy_location_fix.sh +++ b/KCLS/utility-scripts/copy_loc_fix/run_copy_location_fix.sh @@ -2,6 +2,5 @@ # Script to change item copy locations so that the # copy location owning library matches the item's circ library -cd /home/opensrf/esi_data_services psql -U evergreen < fix_copy_locations.sql > log.fix_copy_locations -cat log.fix_copy_locations | mailx -s "Copy location fix report" bbonner@kcls.org,mcarlson@kcls.org +#cat log.fix_copy_locations | mailx -s "Copy location fix report" bbonner@kcls.org,mcarlson@kcls.org diff --git a/KCLS/utility-scripts/del_empty_vol/del_all_empty_vols.sql b/KCLS/utility-scripts/del_empty_vol/del_all_empty_vols.sql index ba0757c9f5..0428f7535b 100644 --- a/KCLS/utility-scripts/del_empty_vol/del_all_empty_vols.sql +++ b/KCLS/utility-scripts/del_empty_vol/del_all_empty_vols.sql @@ -1,6 +1,8 @@ \echo running empty volume deletion BEGIN; +SET SESSION STATEMENT_TIMEOUT TO 0; + \echo compiling list of volumes to delete TRUNCATE TABLE m_kcls.vols_to_delete; diff --git a/KCLS/utility-scripts/inactive_cards/remove_inactive_patron_cards.sql b/KCLS/utility-scripts/inactive_cards/remove_inactive_patron_cards.sql index a39f2b7ba6..a1ab51dd8f 100644 --- a/KCLS/utility-scripts/inactive_cards/remove_inactive_patron_cards.sql +++ b/KCLS/utility-scripts/inactive_cards/remove_inactive_patron_cards.sql @@ -1,4 +1,7 @@ BEGIN; + +SET SESSION STATEMENT_TIMEOUT TO 0; + SELECT o.barcode as "Old BC", n.barcode as "New BC" FROM actor.card AS o INNER JOIN actor.card AS n ON o.usr = n.usr WHERE NOT o.active AND n.active AND EXISTS (SELECT usr FROM actor.card WHERE usr = o.usr AND active); \echo Backing up inactive patron cards diff --git a/KCLS/utility-scripts/reshelving/reshelving.sh b/KCLS/utility-scripts/reshelving/reshelving.sh index 91de2b78ca..f217301aa2 100755 --- a/KCLS/utility-scripts/reshelving/reshelving.sh +++ b/KCLS/utility-scripts/reshelving/reshelving.sh @@ -4,8 +4,7 @@ set -eu echo -n "Reshelving copies at " date +"%F %T" -psql -U evergreen \ - -f /home/opensrf/scripts/reshelving/reshelving.sql +psql -U evergreen -f reshelving.sql echo -n "Reshelving complete at " date +"%F %T" -- 2.11.0