1 files changed, 25 insertions, 0 deletions
diff --git a/app/workers/loose_foreign_keys/cleanup_worker.rb b/app/workers/loose_foreign_keys/cleanup_worker.rb
new file mode 100644
index 00000000000..b4565dbf624
--- /dev/null
+++ b/app/workers/loose_foreign_keys/cleanup_worker.rb
@@ -0,0 +1,25 @@
+# frozen_string_literal: true
+
+module LooseForeignKeys
+  class CleanupWorker
+    include ApplicationWorker
+    include Gitlab::ExclusiveLeaseHelpers
+    include CronjobQueue # rubocop: disable Scalability/CronWorkerContext
+
+    feature_category :sharding
+    data_consistency :always
+    idempotent!
+
+    def perform
+      return if Feature.disabled?(:loose_foreign_key_cleanup, default_enabled: :yaml)
+
+      ttl = ModificationTracker::MAX_RUNTIME + 1.minute
+      in_lock(self.class.name.underscore, ttl: ttl, retries: 0) do
+        # TODO: Iterate over the connections
+        # https://gitlab.com/gitlab-org/gitlab/-/issues/341513
+        stats = ProcessDeletedRecordsService.new(connection: ApplicationRecord.connection).execute
+        log_extra_metadata_on_done(:stats, stats)
+      end
+    end
+  end
+end