Skip to content

Resolve "Remove the index_namespaces_id_parent_id_is_not_null index"

What does this MR do?

Remove the index_namespaces_id_parent_id_is_not_null index added in !61098 (merged). Now that the namespaces traversal_ids migration has finished we no longer need this index.

$ rails db:migrate:up:main VERSION=20220505053504
== 20220505053504 RemoveNamespacesIdParentIdInversePartialIndex: migrating ====
-- transaction_open?()
   -> 0.0000s
-- index_exists?(:namespaces, :id, {:name=>"index_namespaces_id_parent_id_is_not_null", :algorithm=>:concurrently})
   -> 0.0261s
-- execute("SET statement_timeout TO 0")
   -> 0.0008s
-- remove_index(:namespaces, {:name=>"index_namespaces_id_parent_id_is_not_null", :algorithm=>:concurrently, :column=>:id})
   -> 0.0224s
-- execute("RESET statement_timeout")
   -> 0.0008s
== 20220505053504 RemoveNamespacesIdParentIdInversePartialIndex: migrated (0.0625s)

$ rails db:migrate:down:main VERSION=20220505053504
== 20220505053504 RemoveNamespacesIdParentIdInversePartialIndex: reverting ====
-- transaction_open?()
   -> 0.0000s
-- index_exists?(:namespaces, :id, {:where=>"parent_id IS NOT NULL", :name=>"index_namespaces_id_parent_id_is_not_null", :algorithm=>:concurrently})
   -> 0.0254s
-- execute("SET statement_timeout TO 0")
   -> 0.0007s
-- add_index(:namespaces, :id, {:where=>"parent_id IS NOT NULL", :name=>"index_namespaces_id_parent_id_is_not_null", :algorithm=>:concurrently})
   -> 0.0048s
-- execute("RESET statement_timeout")
   -> 0.0008s
== 20220505053504 RemoveNamespacesIdParentIdInversePartialIndex: reverted (0.0449s)

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Closes #330099 (closed)

Edited by Alex Pooley

Merge request reports