Remove tmp idx null project namespace id
What does this MR do and why?
Describe in detail what your merge request does and why.
Remove temporary index tmp_index_for_null_project_namespace_id
% rails db:migrate
main: == 20220920022404 RemoveTempIndexNullProjectNamespaceId: migrating ============
main: -- transaction_open?()
main: -> 0.0000s
main: -- indexes(:projects)
main: -> 0.0459s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0009s
main: -- remove_index(:projects, {:algorithm=>:concurrently, :name=>"tmp_index_for_null_project_namespace_id"})
main: -> 0.0046s
main: -- execute("RESET statement_timeout")
main: -> 0.0004s
main: == 20220920022404 RemoveTempIndexNullProjectNamespaceId: migrated (0.0651s) ===
% rails db:rollback:main STEP=1
main: == 20220920022404 RemoveTempIndexNullProjectNamespaceId: reverting ============
main: -- transaction_open?()
main: -> 0.0000s
main: -- index_exists?(:projects, :id, {:name=>"tmp_index_for_null_project_namespace_id", :where=>"project_namespace_id IS NULL", :algorithm=>:concurrently})
main: -> 0.0199s
main: -- execute("SET statement_timeout TO 0")
main: -> 0.0003s
main: -- add_index(:projects, :id, {:name=>"tmp_index_for_null_project_namespace_id", :where=>"project_namespace_id IS NULL", :algorithm=>:concurrently})
main: -> 0.0077s
main: -- execute("RESET statement_timeout")
main: -> 0.0003s
main: == 20220920022404 RemoveTempIndexNullProjectNamespaceId: reverted (0.0344s) ===
Screenshots or screen recordings
Screenshots are required for UI changes, and strongly recommended for all other merge requests.
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Serena Fang