Fix setting share_with_group_lock

Closes #37916

See merge request gitlab-org/gitlab-ce!14300

Prior to this commit running
Namespace#force_share_with_group_lock_on_descendants would result in
updating _all_ namespaces in the namespaces table, not just the
descendants. This is the result of ActiveRecord::Relation#update_all not
taking into account the CTE. To work around this we use the CTE query as
a sub-query instead of directly calling #update_all.

To prevent this from happening the relations returned by
Gitlab::GroupHierarchy are now marked as read-only, resulting in an
error being raised when methods such as #update_all are used.

Fortunately on GitLab.com our statement timeouts appear to have
prevented this query from actually doing any damage other than causing
a very large amount of dead tuples.

Fixes https://gitlab.com/gitlab-org/gitlab-ce/issues/37916

created services for keys

See merge request gitlab-org/gitlab-ce!13331

Make the labels in the Compare form less confusing

Closes #21331

See merge request gitlab-org/gitlab-ce!14225

SQL performance improvements for ProjectsController#show

See merge request gitlab-org/gitlab-ce!14226

Display whether branch has been merged when deleting protected branch

Closes #32295

See merge request gitlab-org/gitlab-ce!14220

* Improve the descriptive text
* Rename "from" to "Target" and "to" to "Source"
* Swap "Target" and "Source" to have the same order as in MRs
* Reworded "Switch base of comparison" to "Swap versions"
Signed-off-by: Rémy Coutable <remy@rymai.me>

Remove title attribute from sidebar elements

See merge request gitlab-org/gitlab-ce!14140

Clarify what variables can be used under `environment:`

See merge request gitlab-org/gitlab-ce!14277

Resolve "Scope users by group inside dropdowns if I'm on group page (Issue, MRs)"

Closes #20824

See merge request gitlab-org/gitlab-ce!14249

Remove extra space between profile header and navbar

Closes #37844

See merge request gitlab-org/gitlab-ce!14275

Resolve "Typo in Protected Runners setting checkbox"

Closes #37886

See merge request gitlab-org/gitlab-ce!14284

add info about UX label to feature proposal to CONTRIBUTING.md

See merge request gitlab-org/gitlab-ce!14281

Minor improvements to prometheus docs

Closes #37896

See merge request gitlab-org/gitlab-ce!14288

Add missing index for getting recent push events

See merge request gitlab-org/gitlab-ce!14273

Fixed overflow issue in changes dropdown

See merge request gitlab-org/gitlab-ce!14181

Resolve "`bin/rspec`/`bin/karma` can nuke the GDK entirely"

Closes #37872

See merge request gitlab-org/gitlab-ce!14276

This index is required to allow fast retrieval of recent push events
without merge requests. Without this index in place the query would
lead to PostgreSQL scanning over 150 000 index entries all the time,
easily taking up between 200 and 500 milliseconds. This index
reduces the time spent in this process to around 40 milliseconds on
GitLab.com.

Docs filter by my reaction

See merge request gitlab-org/gitlab-ce!14197

Constrain environment deployments to project IDs

Closes #36877

See merge request gitlab-org/gitlab-ce!14252

Changed dashed border button color to be darker

See merge request gitlab-org/gitlab-ce!14041

Add missing classes to omniauth remember-me checkbox and add correct font-size

See merge request gitlab-org/gitlab-ce!14111

Extend the QueryRecorder matcher

See merge request gitlab-org/gitlab-ce!14267

Rename Gitlab::Git::Committer to User

See merge request gitlab-org/gitlab-ce!14254

Signed-off-by: Rémy Coutable <remy@rymai.me>

Reduce footprint of animate.js

See merge request gitlab-org/gitlab-ce!14187

Improve nginx ingress configuration docs

Closes #37739

See merge request gitlab-org/gitlab-ce!14203

Signed-off-by: Rémy Coutable <remy@rymai.me>

So it can report the queries that we're run more compared to the
control point.