From: Lucas Di Pentima <lucas.dipentima@curii.com>
Date: Tue, 14 Feb 2023 18:57:47 +0000 (-0300)
Subject: Merge branch '20074-bigint-migration-fix'. Refs #20074
X-Git-Tag: 2.6.0~45
X-Git-Url: https://git.arvados.org/arvados.git/commitdiff_plain/e9928bf0228070a287c086eb91cf1b278bded2db?hp=2de2c96925cc3439305f16dced7f89bd9124853d

Merge branch '20074-bigint-migration-fix'. Refs #20074

Arvados-DCO-1.1-Signed-off-by: Lucas Di Pentima <lucas.dipentima@curii.com>
---

diff --git a/services/api/db/migrate/20221230155924_bigint_id.rb b/services/api/db/migrate/20221230155924_bigint_id.rb
index 20791ae017..fdac96d9ad 100644
--- a/services/api/db/migrate/20221230155924_bigint_id.rb
+++ b/services/api/db/migrate/20221230155924_bigint_id.rb
@@ -5,6 +5,9 @@
 class BigintId < ActiveRecord::Migration[5.2]
   disable_ddl_transaction!
   def up
+    old_value = query_value('SHOW statement_timeout')
+    execute "SET statement_timeout TO '0s'"
+
     change_column :api_client_authorizations, :id, :bigint
     change_column :api_client_authorizations, :api_client_id, :bigint
     change_column :api_client_authorizations, :user_id, :bigint
@@ -30,6 +33,8 @@ class BigintId < ActiveRecord::Migration[5.2]
     change_column :traits, :id, :bigint
     change_column :virtual_machines, :id, :bigint
     change_column :workflows, :id, :bigint
+
+    execute "SET statement_timeout TO '#{quote(old_value)}s'"
   end
 
   def down