Remove auto vacuum logic, decrease batch size and interval

1 files changed, 10 insertions, 20 deletions

diff --git a/lib/gitlab/background_migration/sync_issues_state_id.rb b/lib/gitlab/background_migration/sync_issues_state_id.rb
index 053d154cef8..33b997c8533 100644
--- a/lib/gitlab/background_migration/sync_issues_state_id.rb
+++ b/lib/gitlab/background_migration/sync_issues_state_id.rb
@@ -4,29 +4,19 @@
 module Gitlab
   module BackgroundMigration
     class SyncIssuesStateId
-      include Reschedulable
-
       def perform(start_id, end_id)
         Rails.logger.info("Issues - Populating state_id: #{start_id} - #{end_id}")
 
-        reschedule_if_needed(start_id, end_id) do
-          execute_statement <<~SQL
-            UPDATE issues
-            SET state_id =
-              CASE state
-              WHEN 'opened' THEN 1
-              WHEN 'closed' THEN 2
-              END
-            WHERE state_id IS NULL
-            AND id BETWEEN #{start_id} AND #{end_id}
-          SQL
-        end
-      end
-
-      private
-
-      def should_reschedule?
-        wait_for_deadtuple_vacuum?('issues')
+        ActiveRecord::Base.connection.execute <<~SQL
+          UPDATE issues
+          SET state_id =
+            CASE state
+            WHEN 'opened' THEN 1
+            WHEN 'closed' THEN 2
+            END
+          WHERE state_id IS NULL
+          AND id BETWEEN #{start_id} AND #{end_id}
+        SQL
       end
     end
   end