Skip to content

Remove artifact expiry temp index

Matija Čupić requested to merge mc/backstage/remove-artifact-expiry-temp-index into master

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ć

Merge request reports