From 97968ad661a5879347eaec3839d5fde376ea326d Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 3 Feb 2017 11:31:23 -0500 Subject: [PATCH] JBAS-1445 2.9 SQL update statement timeouts Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.7-to-2.9-upgrade-part-2.sql | 2 ++ KCLS/sql/schema/deploy/2.7-to-2.9-upgrade.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade-part-2.sql b/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade-part-2.sql index 8ab50594ac..f2be168d66 100644 --- a/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade-part-2.sql +++ b/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade-part-2.sql @@ -4,6 +4,8 @@ --BEGIN; -- No transaction required for batch update. +SET STATEMENT_TIMEOUT = 0; + \qecho \qecho Updating the thesaurus codes in authority.simple_heading; \qecho diff --git a/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade.sql b/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade.sql index 90badfd9a5..0c13a0f311 100644 --- a/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.7-to-2.9-upgrade.sql @@ -1,5 +1,7 @@ BEGIN; +SET STATEMENT_TIMEOUT = 0; + --Upgrade Script for 2.7.4 to 2.8.0 \set eg_version '''2.8.0''' -- 2.11.0