Skip to content

Drop invalid index from postgres_async_indexes

Max Orefice requested to merge morefice/drop-invalid-async-index-from-queue into master

Ref: #387301 (closed)

What does this MR do and why?

Following up !108823 (merged) where we referenced the wrong column when creating our index.

This MR removed our index from the async queue in order to unlock async index creation on production.

Database

https://console.postgres.ai/gitlab/gitlab-production-ci/sessions/14973/commands/52144

  1. Feature.enable(:database_async_index_creation)
  2. Feature.enable(:database_reindexing)
  3. GITLAB_SIMULATE_SAAS=1 bin/rails db:migrate
  4. bundle exec rails gitlab:db:reindex
GITLAB_SIMULATE_SAAS=1 bin/rails db:migrate
main: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrating ======
main: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrated (0.0978s)

ci: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrating ======
ci: == 20230130084718 DropInvalidAsyncIndexFromPostgresAsyncIndex: migrated (0.0070s)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Max Orefice

Merge request reports