From fc8221ce6cae99326a0a519daa0ca7abe27e2728 Mon Sep 17 00:00:00 2001
From: Grzegorz Bizon <grzesiek.bizon@gmail.com>
Date: Tue, 8 May 2018 17:47:09 +0200
Subject: Reduce scope of orphaned builds to be removed

---
 db/migrate/20180420010016_add_pipeline_build_foreign_key.rb | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb b/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb
index 7fcd3b20d5e..6fabe07bc9c 100644
--- a/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb
+++ b/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb
@@ -13,7 +13,7 @@ class AddPipelineBuildForeignKey < ActiveRecord::Migration
     execute <<~SQL
       DELETE FROM ci_builds WHERE NOT EXISTS
         (SELECT true FROM ci_pipelines WHERE ci_pipelines.id = ci_builds.commit_id)
-        AND commit_id IS NOT NULL
+        AND stage_id IS NULL
     SQL
 
     add_concurrent_foreign_key(:ci_builds, :ci_pipelines, column: :commit_id)
-- 
cgit v1.2.1