We need to reindex the Gitlab PSQL database,for that we tried with the below property in gitlab.rb file
gitlab_rails[‘database_reindexing’][‘enable’]= true
gitlab_rails[‘database_reindexing’][‘hour’] = '*'
gitlab_rails[‘database_reindexing’][‘minute’] = 0
gitlab_rails[‘database_reindexing’][‘month’] = '*'
gitlab_rails[‘database_reindexing’][‘day_of_month’] = '*'
gitlab_rails[‘database_reindexing’][‘day_of_week’] = ‘0,6’
After enabling this property we have executed the reconfigure command.
gitlab-ctl reconfigure
After executing the above command, there was no error in the output, but when we try to manually run the reindex command
gitlab-rake gitlab:db:reindex
Its says the feature is not enabled, not sure whether we need to enable or change the property.
Yes, other than the changes to gitlab.rb, you also have to do this:
gitlab-rails c
--------------------------------------------------------------------------------
Ruby: ruby 2.7.5p203 (2021-11-24 revision f69aeb8314) [x86_64-linux]
GitLab: 14.9.1 (5b713e1e9a3) FOSS
GitLab Shell: 13.24.0
PostgreSQL: 13.3
------------------------------------------------------------[ booted in 16.93s ]
Loading production environment (Rails 6.1.4.6)
irb(main):001:0> Feature.enable(:database_reindexing)
=> true
irb(main):002:0> exit
basically, from the gitlab-rails console:
Feature.enable(:database_reindexing)