Manually create an index blocking projects from being deleted
We have a missing index in the database that is causing project directories to be destroyed but not the database entries themselves due to a statement timeout: https://gitlab.com/gitlab-org/gitlab-ce/issues/44008
Until this index is added via https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17632 in 10.6 RC3, we will continue to have broken projects and users that cannot delete their accounts.
I suspect it will take many more days to get 10.6 RC3, so I propose that we temporarily add this index until we have packages ready to deploy:
CREATE INDEX CONCURRENTLY index_ci_build_trace_sections_on_section_name_id ON ci_build_trace_sections (section_name_id);
Once we deploy, we shouldn't need top drop the index since the migration will only create it if it doesn't exist, but here is the command for completeness:
DROP INDEX index_ci_build_trace_sections_on_section_name_id
/cc: @ilyaf, @markglenfletcher, @lyle