From: Lucas Di Pentima <lucas.dipentima@curii.com>
Date: Tue, 14 Feb 2023 18:34:16 +0000 (-0300)
Subject: 20074: Disables statement timeout on rails migration.
X-Git-Tag: 2.6.0~45^2
X-Git-Url: https://git.arvados.org/arvados.git/commitdiff_plain/cffecc32488ab5c7ef44d1d855fb8c0e55d76b1f?ds=inline;hp=-c

20074: Disables statement timeout on rails migration.

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

cffecc32488ab5c7ef44d1d855fb8c0e55d76b1f
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