Merge branch '357422-activerecord-querycanceled-pg-querycanceled-error-canceling-statement-due-to-statement' into 'master'

Resolve "ActiveRecord::QueryCanceled: PG::QueryCanceled: ERROR:  canceling statement due to statement timeout"

See merge request gitlab-org/gitlab!84283

Unscoping the where: :build_id scope from the cleanup_service
scan_batch relation resolves a strange issue where this query was being
carried through to the Security::Finding queries.

`unscope` is not permitted for use outside of models, so this action was
moved to a scope on the Security::Scan model.

Changelog: performance
MR: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/84283
EE: true

Merge branch '358363-replace-generic-checkbox-with-gitlab-ui-styled-checkbox-in-ee-app-views-admin' into 'master'

Replace generic checkbox with GitLab UI styled checkbox in ee/app/views/admin/application_settings/_pseudonymizer.html.haml

See merge request gitlab-org/gitlab!84883

Fix order dependent cleanup package file worker spec

See merge request gitlab-org/gitlab!85235

Remove security_scan_succeeded from code

See merge request gitlab-org/gitlab!84222

Add comment on creator_id on Deploy Tokens

See merge request gitlab-org/gitlab!85158

Use Arel-native nulls order

See merge request gitlab-org/gitlab!84377

Remove Database.nulls_order implementation with Arel-native
implementation of the same funcion.

Changelog: changed
EE: true

Merge branch '358366-replace-generic-checkbox-with-gitlab-ui-styled-checkbox-in-ee-app-views-groups-hooks' into 'master'

Pajamas migration day: replace checkboxes for group member hooks

See merge request gitlab-org/gitlab!84753

Merge branch 'aregnery/add-projects-from-environments-dashboard-button-variant-update' into 'master'

Change variant to confirm for add project button

See merge request gitlab-org/gitlab!84720

Set schema of tracking tables to gitlab_shared

See merge request gitlab-org/gitlab!84992

Better fix for PG::ObjectInUse error when dropping databases

See merge request gitlab-org/gitlab!85006

Migrate import requirements button to confirm

See merge request gitlab-org/gitlab!84812

Extend decomposition prometheus metric with information about CI

See merge request gitlab-org/gitlab!85178

Use GlBroadcastMessage in Broadcast Message admin settings page

See merge request gitlab-org/gitlab!83251

docs: Check off task for cross-joins

See merge request gitlab-org/gitlab!85346

It should not keep the geo as "ActiveRecord::Base" connection

This requires a few things to be true:

1. Database connections are opened during routes. This is true for the
   GitLab application. Note this is not allowed anymore in Rails 7.
2. Multiple databases are configured. With a single database, Rails has
   always accidentally closed the database connection for the main
   database.

This fix removes prior attempts to drop the connection(s)

Database connections opened in other initializers are still an issue but
Rails kindly closes them for us. Unfortunately Rails has an initializer,
set_routes_reloader_hook which is run _after_ `config.after_initialize`.
The sequence goes like this:

1. Various initializers run, including route loading.
1. `config.after_initialize` blocks run (called by
   Gitlab::Application.finisher_hook). One of the
   `config.after_initialize` blocks run is to close all database
   connections.
1. `Gitlab::Application.set_routes_reloader_hook` initializer runs. This
   loads routes again.

So this fix is simple: we simply call the same thing Rails to close all
database connections again.

Make OmniAuth initializer return Geo proxied URL when it exists

See merge request gitlab-org/gitlab!82703

OmniAuth full_host supports a proc, this makes it return a proc
that changes based on the env to verify whether it's a proxied
Geo request or not.

For regular requests, or non-EE requests, this keeps returning
the base URL, while proxied Geo requests return the URL of the
proxying site - to get SSO working with separate URLs.

EE: true
Changelog: changed

Migrate admin email checkboxes to gitlab-ui

See merge request gitlab-org/gitlab!84759

Use release check command in FF rollout issue

See merge request gitlab-org/gitlab!85258

Fix rendering failure for the 'Verified' badge

See merge request gitlab-org/gitlab!84862

Changelog: fixed

Add keyboard HTML tag to markdown page

See merge request gitlab-org/gitlab!85216

Fix order-dependent failure

See merge request gitlab-org/gitlab!85341

Docs: Add expected behaviour for updating users managed by LDAP

See merge request gitlab-org/gitlab!84767

Add consequences of updating user email in LDAP

Docs: Note 14.7-14.9 can have Gitaly /tmp bug

See merge request gitlab-org/gitlab!85329

The following issue has been wide-spread among our customers, so this
commit adds mention of it in the upgrade docs:
https://gitlab.com/gitlab-org/gitaly/-/issues/4113

Add name change note to markdown.md

See merge request gitlab-org/gitlab!85187

Document typePolicies and makeVar usage in frontend

See merge request gitlab-org/gitlab!84740

This change adds information on how to use typePolicies and makeVar to
maintain a local state using Apollo Client 3.

Replace 15.0 with 16.0 for self-monitoring removal

See merge request gitlab-org/gitlab!85344

spec/tasks/dev_rake_spec.rb spec/tasks/gitlab/setup_rake_spec.rb

The latter spec fails because the former spec does not reset the env
var.