Skip to content

Remove temporary blocking issues indexes

Felipe Artur requested to merge issue_258973 into master

What does this MR do?

Remove temporary indexes used to schedule background migrations on !42277 (merged)

Migration output

== 20201118181411 RemoveTemporaryBlockingIssuesIndex: migrating ===============
-- transaction_open?()
   -> 0.0000s
-- indexes(:issue_links)
   -> 0.0079s
-- execute("SET statement_timeout TO 0")
   -> 0.0007s
-- remove_index(:issue_links, {:algorithm=>:concurrently, :name=>"tmp_idx_blocking_type_links"})
   -> 0.0098s
-- execute("RESET ALL")
   -> 0.0018s
-- transaction_open?()
   -> 0.0000s
-- indexes(:issue_links)
   -> 0.0043s
-- remove_index(:issue_links, {:algorithm=>:concurrently, :name=>"tmp_idx_blocked_by_type_links"})
   -> 0.0052s
-- transaction_open?()
   -> 0.0000s
-- indexes(:issues)
   -> 0.0133s
-- remove_index(:issues, {:algorithm=>:concurrently, :name=>"tmp_idx_index_issues_with_outdate_blocking_count"})
   -> 0.0085s
== 20201118181411 RemoveTemporaryBlockingIssuesIndex: migrated (0.0577s) ======

related to #258973 (closed)

Edited by Felipe Artur

Merge request reports