Upgrade from 18.7.1 to 18.8.0 fails in DB migration
DB migration fails due to missing index `index_merge_requests_on_target_project_id_and_iid`
Some info about this index can be found here: https://gitlab.com/gitlab-org/gitlab/-/issues/507695
it can be fixed with `sudo gitlab-psql -c 'CREATE INDEX CONCURRENTLY index_merge_requests_on_target_project_id_and_iid ON merge_requests USING btree (target_project_id, iid);'` but it is really annoying, that I get a similar problem each month with a GitLab upgrade.
The same was happening here: https://gitlab.com/gitlab-org/gitlab/-/issues/581662#note_2925999993. Btw. at this post is my DB schema dump with a lot of differences to what it actually should look like. So it would be really nice, if the problem could be fixed properly and not only piece by piece.
issue