GDK EE initial database setup fails on the IndexRoutesPathForLike migration
As per the title says, in the setup_postgresql.rake tasks, when the migration IndexRoutesPathForLike hits, the database creation will fail. However if I comment it out it will work no problem.
I wonder why that index is causing that issue
Activity
Actually I believe that we were not able to deploy on RC1 staging because of problem. Is that correct @reprazent?
@jivanvl Can you post the error log that you hit?
@stanhu Sure, here it is
NameError: uninitialized constant IndexRedirectRoutesPathForLike /Users/jivanvl/gdk-ee/gitlab/lib/tasks/migrate/setup_postgresql.rake:14:in `block in <top (required)>' /Users/jivanvl/gdk-ee/gitlab/lib/tasks/gitlab/setup.rake:19:in `setup_db' /Users/jivanvl/gdk-ee/gitlab/lib/tasks/gitlab/setup.rake:4:in `block (2 levels) in <top (required)>'-
This looks like a different issue than what we ran into with RC1.
@mkozono This looks related to the new redirect migration. Could you take a look?
@stanhu I'll check it out
-
https://gitlab.com/gitlab-org/gitlab-ce/issues/31934#note_29424556
This indeed looks a little different.
52.184.183.38 -- execute("UPDATE \"routes\" SET \"path\" = regexp_replace(\"routes\".\"path\", 't-0k-', 't-0k-/t-k-0') WHERE \"routes\".\"id\" >= 2459557 AND \"routes\".\"path\" ILIKE 't-0k-%'") 52.184.183.38 -> 0.6756s 52.184.183.38 rake aborted! 52.184.183.38 StandardError: An error has occurred, all later migrations canceled: 52.184.183.38 52.184.183.38 Invalid argument @ rb_file_s_rename - (/var/opt/gitlab/git-data-file03/repositories/t-0k-, /var/opt/gitlab/git-data-file03/repositories/t-0k-/t-k-0)/opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/shell.rb:263:in `mv_namespace' 52.184.183.38 /opt/gitlab/embedded/service/gitlab-rails/lib/gitlab/database/rename_reserved_paths_migration/v1/rename_namespaces.rb:40:in `block in move_repositories'I recalled seeing "RoutesPath" somewhere in slack, and this seemed familiar for me. Probably two separate problems.
