From b949484783eea2ceca2c171f288c553b079abebb Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 29 Dec 2016 09:49:40 -0800 Subject: [PATCH] JBAS-1701 Stale browse entry cleaner stmt timeout Signed-off-by: Bill Erickson --- KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql b/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql index 482fc7e32b..8ab824efa7 100644 --- a/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql +++ b/KCLS/utility-scripts/browse_cleanup/delete-stale-browse-entries.sql @@ -8,6 +8,8 @@ Run this script after a browse entry re-ingest, particularly if browse indexes change, resulting in a lot of new browse entries. */ +SET STATEMENT_TIMEOUT = 0; + DELETE FROM metabib.browse_author_entry WHERE id IN ( SELECT DISTINCT(entry.id) FROM metabib.browse_author_entry entry -- 2.11.0