X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/eafbd28d0a866807471951e133a8132dbdfa9cfc..4e110f379fe26b646c75cb3164f882567fdb17fd:/services/api/app/controllers/sys_controller.rb diff --git a/services/api/app/controllers/sys_controller.rb b/services/api/app/controllers/sys_controller.rb index 3d434f2d69..7d20cf77fd 100644 --- a/services/api/app/controllers/sys_controller.rb +++ b/services/api/app/controllers/sys_controller.rb @@ -12,9 +12,11 @@ class SysController < ApplicationController # Sweep trashed collections Collection. where('delete_at is not null and delete_at < statement_timestamp()'). + in_batches(of: 15). destroy_all Collection. where('is_trashed = false and trash_at < statement_timestamp()'). + in_batches(of: 15). update_all('is_trashed = true') # Sweep trashed projects and their contents (as well as role @@ -38,8 +40,8 @@ class SysController < ApplicationController def delete_project_and_contents(p_uuid) p = Group.find_by_uuid(p_uuid) - if !p || p.group_class != 'project' - raise "can't sweep group '#{p_uuid}', it may not exist or not be a project" + if !p + raise "can't sweep group '#{p_uuid}', it may not exist" end # First delete sub projects Group.where({group_class: 'project', owner_uuid: p_uuid}).each do |sub_project| @@ -50,7 +52,7 @@ class SysController < ApplicationController skipped_classes = ['Group', 'User'] ActiveRecord::Base.descendants.reject(&:abstract_class?).each do |klass| if !skipped_classes.include?(klass.name) && klass.columns.collect(&:name).include?('owner_uuid') - klass.where({owner_uuid: p_uuid}).destroy_all + klass.where({owner_uuid: p_uuid}).in_batches(of: 15).destroy_all end end # Finally delete the project itself