Skip to content

Remove tmp_index_merge_requests_draft_and_status

Cleanup from !63703 (merged), we need to remove tmp_index_merge_requests_draft_and_status

Related to #333947 (closed)

Database

Up

main: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: migrating ==========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- indexes(:merge_requests)
main:    -> 0.0430s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0005s
main: -- remove_index(:merge_requests, {:algorithm=>:concurrently, :name=>"tmp_index_merge_requests_draft_and_status"})
main:    -> 0.0095s
main: -- execute("RESET statement_timeout")
main:    -> 0.0005s
main: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: migrated (0.0665s) =

ci: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: migrating ==========
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- indexes(:merge_requests)
ci:    -> 0.0299s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0005s
ci: -- remove_index(:merge_requests, {:algorithm=>:concurrently, :name=>"tmp_index_merge_requests_draft_and_status"})
ci:    -> 0.0076s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0005s
ci: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: migrated (0.0433s) =

Down

main: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: reverting ==========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- index_exists?(:merge_requests, :id, {:where=>"draft = false AND state_id = 1 AND ((title)::text ~* '^(\\[draft\\]|\\(draft\\)|draft:|draft|\\[WIP\\]|WIP:|WIP)'::text)", :name=>"tmp_index_merge_requests_draft_and_status", :algorithm=>:concurrently})
main:    -> 0.0378s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0006s
main: -- add_index(:merge_requests, :id, {:where=>"draft = false AND state_id = 1 AND ((title)::text ~* '^(\\[draft\\]|\\(draft\\)|draft:|draft|\\[WIP\\]|WIP:|WIP)'::text)", :name=>"tmp_index_merge_requests_draft_and_status", :algorithm=>:concurrently})
main:    -> 0.0175s
main: -- execute("RESET statement_timeout")
main:    -> 0.0006s
main: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: reverted (0.0710s) =

ci: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: reverting ==========
ci: -- transaction_open?()
ci:    -> 0.0000s
ci: -- index_exists?(:merge_requests, :id, {:where=>"draft = false AND state_id = 1 AND ((title)::text ~* '^(\\[draft\\]|\\(draft\\)|draft:|draft|\\[WIP\\]|WIP:|WIP)'::text)", :name=>"tmp_index_merge_requests_draft_and_status", :algorithm=>:concurrently})
ci:    -> 0.0331s
ci: -- execute("SET statement_timeout TO 0")
ci:    -> 0.0004s
ci: -- add_index(:merge_requests, :id, {:where=>"draft = false AND state_id = 1 AND ((title)::text ~* '^(\\[draft\\]|\\(draft\\)|draft:|draft|\\[WIP\\]|WIP:|WIP)'::text)", :name=>"tmp_index_merge_requests_draft_and_status", :algorithm=>:concurrently})
ci:    -> 0.0154s
ci: -- execute("RESET statement_timeout")
ci:    -> 0.0005s
ci: == 20220707192420 RemoveTmpIdxMergeRequestsDraftAndStatus: reverted (0.0624s) =
Edited by Kerri Miller

Merge request reports