17090: Migration to refresh_permissions

Arvados-DCO-1.1-Signed-off-by: Peter Amstutz <peter.amstutz@curii.com>

diff --git a/services/api/db/migrate/20201105190435_refresh_permissions.rb b/services/api/db/migrate/20201105190435_refresh_permissions.rb
new file mode 100644 (file)
index 0000000..1ced9d2
--- /dev/null
+++ b/services/api/db/migrate/20201105190435_refresh_permissions.rb
@@ -0,0 +1,15 @@
+# Copyright (C) The Arvados Authors. All rights reserved.
+#
+# SPDX-License-Identifier: AGPL-3.0
+
+require '20200501150153_permission_table_constants'
+
+class RefreshPermissions < ActiveRecord::Migration[5.2]
+  def change
+    # There was a report of deadlocks resulting in failing permission
+    # updates.  These failures should not have corrupted permissions
+    # (the failure should have rolled back the entire update) but we
+    # will refresh the permissions out of an abundance of caution.
+    refresh_permissions
+  end
+end

diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql
index 6f9cee270741562cb1b653bf47469521d0766f34..58c064ac3341ce953d41f83cab0425a0370e5f67 100644 (file)
--- a/services/api/db/structure.sql
+++ b/services/api/db/structure.sql
@@ -3185,6 +3185,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20200501150153'),
 ('20200602141328'),
 ('20200914203202'),
-('20201103170213');
+('20201103170213'),
+('20201105190435');