X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/1962fd79f400d605c4b26e2add0157c6b504803a..bb1d0c7499ad7c8d48c28a611c2d6a99c170265b:/services/api/lib/refresh_permission_view.rb?ds=sidebyside

diff --git a/services/api/lib/refresh_permission_view.rb b/services/api/lib/refresh_permission_view.rb
index 4d3df7d4dc..4ee45ab088 100644
--- a/services/api/lib/refresh_permission_view.rb
+++ b/services/api/lib/refresh_permission_view.rb
@@ -5,5 +5,8 @@
 PERMISSION_VIEW = "materialized_permission_view"
 
 def refresh_permission_view
-  ActiveRecord::Base.connection.exec_query("REFRESH MATERIALIZED VIEW #{PERMISSION_VIEW}")
+  ActiveRecord::Base.transaction do
+    ActiveRecord::Base.connection.execute("LOCK TABLE permission_refresh_lock")
+    ActiveRecord::Base.connection.execute("REFRESH MATERIALIZED VIEW #{PERMISSION_VIEW}")
+  end
 end