Remove artifact expiry temp index
What does this MR do?
Related #295659 (closed)
Migration output:
== 20210215172449 RemoveArtifactExpiryTempIndex: migrating ====================
-- transaction_open?()
-> 0.0000s
-- indexes(:ci_job_artifacts)
-> 0.0107s
-- execute("SET statement_timeout TO 0")
-> 0.0005s
-- remove_index(:ci_job_artifacts, {:algorithm=>:concurrently, :name=>"expired_artifacts_temp_index"})
-> 0.0077s
-- execute("RESET ALL")
-> 0.0005s
== 20210215172449 RemoveArtifactExpiryTempIndex: migrated (0.0202s) ===========
== 20210215172449 RemoveArtifactExpiryTempIndex: reverting ====================
-- transaction_open?()
-> 0.0000s
-- index_exists?(:ci_job_artifacts, [:id, :created_at], {:where=>"expire_at IS NULL AND date(created_at AT TIME ZONE 'UTC') < '2020-06-22'::date", :name=>"expired_artifacts_temp_index", :algorithm=>:concurrently})
-> 0.0034s
-- execute("SET statement_timeout TO 0")
-> 0.0005s
-- add_index(:ci_job_artifacts, [:id, :created_at], {:where=>"expire_at IS NULL AND date(created_at AT TIME ZONE 'UTC') < '2020-06-22'::date", :name=>"expired_artifacts_temp_index", :algorithm=>:concurrently})
-> 0.0103s
-- execute("RESET ALL")
-> 0.0005s
== 20210215172449 RemoveArtifactExpiryTempIndex: reverted (0.0154s) ===========
Does this MR meet the acceptance criteria?
Conformity
Edited by Matija Čupić