Zoekt::Node offline -> lost

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166481



Merged-by: Dmitry Gruzd <dgruzd@gitlab.com>
Approved-by: Dmitry Gruzd <dgruzd@gitlab.com>
Reviewed-by: Michał Zając <mzajac@gitlab.com>
Reviewed-by: Dmitry Gruzd <dgruzd@gitlab.com>
Reviewed-by: Terri Chu <tchu@gitlab.com>
Reviewed-by: Max Woolf <mwoolf@gitlab.com>
Co-authored-by: rkumar555 <rkumar@gitlab.com>

Remove the node and attached tasks, indices and repositories
if the nide is offline for more than 12 hours.

Changelog: other
MR: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166481
EE: true

Bump gitlab-elasticsearch-indexer to 5.3

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167465



Merged-by: John Mason <9717668-johnmason@users.noreply.gitlab.com>
Approved-by: John Mason <9717668-johnmason@users.noreply.gitlab.com>
Co-authored-by: Terri Chu <tchu@gitlab.com>

Add errors to SecurityPolicyProjectCreated subscription

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167422



Merged-by: James Nutt <jnutt@gitlab.com>
Approved-by: Eva Kadlecová <ekadlecova@gitlab.com>
Approved-by: James Nutt <jnutt@gitlab.com>
Reviewed-by: Andy Schoenen <asoiron@gitlab.com>
Reviewed-by: Eva Kadlecová <ekadlecova@gitlab.com>
Co-authored-by: Andy Soiron <asoiron@gitlab.com>

Merge branch 'quarantine-flaky-tests-spec-features-merge_request-user_reverts_merge_request_spec-rb-72' into 'master' 

Quarantine a flaky test

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166976



Merged-by: Kerri Miller <kerrizor@kerrizor.com>
Approved-by: Kerri Miller <kerrizor@kerrizor.com>
Co-authored-by: Auto-quarantining bot <gitlab-auto-quarantine-bot@gitlab.com>

Add and backfill project_id for ci_builds_runner_session

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167634



Merged-by: Michał Zając <mzajac@gitlab.com>
Approved-by: Adam Hegyi <ahegyi@gitlab.com>
Approved-by: João Pereira <jpereira@gitlab.com>
Approved-by: Michał Zając <mzajac@gitlab.com>
Co-authored-by: Shubham Kumar <shukumar@gitlab.com>

## What does this MR do and why?

Add and backfill project_id for ci_builds_runner_session.

This table has a
[desired sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#define-a-desired_sharding_key-to-automatically-backfill-a-sharding_key)
configured ([view configuration](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/ci_builds_runner_session.yml)).

This merge request is the first step towards transforming the desired sharding key into a
[sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#defining-a-sharding-key-for-all-cell-local-tables).

This involves three changes:

- Adding a new column that will serve as the sharding key (along with the relevant index and foreign key).
- Populating the sharding key when new records are created by adding a database function and trigger.
- Scheduling a [batched background migration](https://docs.gitlab.com/ee/development/database/batched_background_migrations.html)
  to set the sharding key for existing records.

Once the background migration has completed, a second merge request will be created to finalize the background
migration and validate the not null constraint.

## How to verify

We have assigned a random backend engineer from ~"group::runner" to review these changes. Please review this merge
request from a ~backend perspective. The main thing we are looking to verify is that the added column and association
match the values specified by the [desired sharding key](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/ci_builds_runner_session.yml)
configuration and that backfilling the column from this other table makes sense in the context of this feature.

When you are finished, please:

1. Trigger the [database testing pipeline](https://docs.gitlab.com/ee/development/database/database_migration_pipeline.html)
   as instructed by Danger.
1. Request a review from the ~backend maintainer and ~database reviewer suggested by Danger.

If you have any questions or concerns, reach out to `@tigerwnz` or @shubhamkrai.

This merge request was generated by a once off keep implemented in
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/143774

This change was generated by
[gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::BackfillDesiredShardingKeySmallTable keep.

To provide feedback on your experience with `gitlab-housekeeper` please create an issue with the
label ~"GitLab Housekeeper" and consider pinging the author of this keep.

Changelog: other

Update Gitaly version

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167735



Merged-by: release-tools approver bot <project_278964_bot_77e28085fcec07f14dfd31c689824b5b@noreply.gitlab.com>
Approved-by: release-tools approver bot <project_278964_bot_77e28085fcec07f14dfd31c689824b5b@noreply.gitlab.com>
Co-authored-by: GitLab Release Tools Bot <delivery-team+release-tools@gitlab.com>

Refactor blobs and commits context specs

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167378



Merged-by: Terri Chu <tchu@gitlab.com>
Approved-by: Meir Benayoun <mbenayoun@gitlab.com>
Approved-by: Siddharth Dungarwal <sdungarwal@gitlab.com>
Reviewed-by: Duo Code Reviewer <duo-code-review-bot@gitlab.com>

Lint issue in headers exception

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/164689



Merged-by: Igor Drozdov <idrozdov@gitlab.com>
Approved-by: Igor Drozdov <idrozdov@gitlab.com>
Reviewed-by: Igor Drozdov <idrozdov@gitlab.com>
Co-authored-by: Archish <archishthakkar@gmail.com>

Move `%{merge_request_author}` to correct docs page

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167771



Merged-by: Brendan Lynch <blynch@gitlab.com>
Approved-by: Brendan Lynch <blynch@gitlab.com>
Co-authored-by: François Rosé <frose@gitlab.com>

Preload dates_source when the widget is requested

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167620



Merged-by: Marc Saleiko <msaleiko@gitlab.com>
Approved-by: Alexandru Croitor <acroitor@gitlab.com>
Approved-by: Kassio Borges <kborges@gitlab.com>
Approved-by: Marc Saleiko <msaleiko@gitlab.com>
Reviewed-by: Marc Saleiko <msaleiko@gitlab.com>
Co-authored-by: stefanosxan <sxanthopoulos@gitlab.com>

Merge branch '482439-migrate-the-code-suggestions-quick-start-doc-to-docs-gitlab-com' into 'master' 

Resolve "Migrate the Code Suggestions "Quick Start" doc to "docs.gitlab.com""

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/165482



Merged-by: Jon Glassman <jglassman@gitlab.com>
Approved-by: Jon Glassman <jglassman@gitlab.com>
Co-authored-by: Sri Rang <srirangan@gmail.com>

Merge branch 'renovate-workhorse/github.com-aws-aws-sdk-go-v2-feature-s3-manager-1.x' into 'master' 

workhorse: Update module github.com/aws/aws-sdk-go-v2/feature/s3/manager to v1.17.23

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167748



Merged-by: Ash McKenzie <amckenzie@gitlab.com>
Approved-by: Ash McKenzie <amckenzie@gitlab.com>
Co-authored-by: GitLab Renovate Bot <gitlab-bot@gitlab.com>

Enable /track_event(s) as official way to track events

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/165748



Merged-by: Terri Chu <tchu@gitlab.com>
Approved-by: Sebastian Rehm <srehm@gitlab.com>
Approved-by: Terri Chu <tchu@gitlab.com>
Approved-by: Amy Qualls <aqualls@gitlab.com>
Reviewed-by: Amy Qualls <aqualls@gitlab.com>
Reviewed-by: Terri Chu <tchu@gitlab.com>
Reviewed-by: Ankit Panchal <apanchal@gitlab.com>
Reviewed-by: Sebastian Rehm <srehm@gitlab.com>
Co-authored-by: Amy Qualls <aqualls@gitlab.com>
Co-authored-by: Niko Belokolodov <nbelokolodov@gitlab.com>

Changelog: changed

This variable only applies to commit templates, not MR templates.

Migrate FixCode tool

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167399



Merged-by: Vitali Tatarintev <vtatarintev@gitlab.com>
Approved-by: Vitali Tatarintev <vtatarintev@gitlab.com>
Reviewed-by: Igor Drozdov <idrozdov@gitlab.com>
Reviewed-by: Vitali Tatarintev <vtatarintev@gitlab.com>
Co-authored-by: Igor Drozdov <idrozdov@gitlab.com>

Fix several test selection gaps

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167621



Merged-by: Lin Jen-Shin <jen-shin@gitlab.com>
Approved-by: Lin Jen-Shin <jen-shin@gitlab.com>
Co-authored-by: ddieulivol <ddieulivol@gitlab.com>

Whenever we change ruby files in this folder, we'll run
feature specs for the correct edition that would contain
the word "navbar" or "sidebar".

Update KAS version

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167726



Merged-by: release-tools approver bot <project_278964_bot_77e28085fcec07f14dfd31c689824b5b@noreply.gitlab.com>
Approved-by: release-tools approver bot <project_278964_bot_77e28085fcec07f14dfd31c689824b5b@noreply.gitlab.com>
Co-authored-by: GitLab Release Tools Bot <delivery-team+release-tools@gitlab.com>

Add and backfill project_id for pages_deployment_states

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167613



Merged-by: Michał Zając <mzajac@gitlab.com>
Approved-by: Michał Zając <mzajac@gitlab.com>
Approved-by: Carla Drago <cdrago@gitlab.com>
Co-authored-by: Shubham Kumar <shukumar@gitlab.com>

## What does this MR do and why?

Add and backfill project_id for pages_deployment_states.

This table has a
[desired sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#define-a-desired_sharding_key-to-automatically-backfill-a-sharding_key)
configured ([view configuration](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/pages_deployment_states.yml)).

This merge request is the first step towards transforming the desired sharding key into a
[sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#defining-a-sharding-key-for-all-cell-local-tables).

This involves three changes:

- Adding a new column that will serve as the sharding key (along with the relevant index and foreign key).
- Populating the sharding key when new records are created by adding a database function and trigger.
- Scheduling a [batched background migration](https://docs.gitlab.com/ee/development/database/batched_background_migrations.html)
  to set the sharding key for existing records.

Once the background migration has completed, a second merge request will be created to finalize the background
migration and validate the not null constraint.

## How to verify

We have assigned a random backend engineer from ~"group::knowledge" to review these changes. Please review this merge
request from a ~backend perspective. The main thing we are looking to verify is that the added column and association
match the values specified by the [desired sharding key](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/pages_deployment_states.yml)
configuration and that backfilling the column from this other table makes sense in the context of this feature.

When you are finished, please:

1. Trigger the [database testing pipeline](https://docs.gitlab.com/ee/development/database/database_migration_pipeline.html)
   as instructed by Danger.
1. Request a review from the ~backend maintainer and ~database reviewer suggested by Danger.

If you have any questions or concerns, reach out to `@tigerwnz` or @shubhamkrai.

This merge request was generated by a once off keep implemented in
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/143774

This change was generated by
[gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::BackfillDesiredShardingKeySmallTable keep.

To provide feedback on your experience with `gitlab-housekeeper` please create an issue with the
label ~"GitLab Housekeeper" and consider pinging the author of this keep.

Changelog: other

Add and backfill project_id for packages_rpm_metadata

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167609



Merged-by: Michał Zając <mzajac@gitlab.com>
Approved-by: Alex Buijs <abuijs@gitlab.com>
Approved-by: Tetiana Chupryna <tchupryna@gitlab.com>
Approved-by: Michał Zając <mzajac@gitlab.com>
Co-authored-by: Shubham Kumar <shukumar@gitlab.com>

## What does this MR do and why?

Add and backfill project_id for packages_rpm_metadata.

This table has a
[desired sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#define-a-desired_sharding_key-to-automatically-backfill-a-sharding_key)
configured ([view configuration](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/packages_rpm_metadata.yml)).

This merge request is the first step towards transforming the desired sharding key into a
[sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#defining-a-sharding-key-for-all-cell-local-tables).

This involves three changes:

- Adding a new column that will serve as the sharding key (along with the relevant index and foreign key).
- Populating the sharding key when new records are created by adding a database function and trigger.
- Scheduling a [batched background migration](https://docs.gitlab.com/ee/development/database/batched_background_migrations.html)
  to set the sharding key for existing records.

Once the background migration has completed, a second merge request will be created to finalize the background
migration and validate the not null constraint.

## How to verify

We have assigned a random backend engineer from ~"group::package registry" to review these changes. Please review this merge
request from a ~backend perspective. The main thing we are looking to verify is that the added column and association
match the values specified by the [desired sharding key](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/packages_rpm_metadata.yml)
configuration and that backfilling the column from this other table makes sense in the context of this feature.

When you are finished, please:

1. Trigger the [database testing pipeline](https://docs.gitlab.com/ee/development/database/database_migration_pipeline.html)
   as instructed by Danger.
1. Request a review from the ~backend maintainer and ~database reviewer suggested by Danger.

If you have any questions or concerns, reach out to `@tigerwnz` or @shubhamkrai.

This merge request was generated by a once off keep implemented in
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/143774

This change was generated by
[gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::BackfillDesiredShardingKeySmallTable keep.

To provide feedback on your experience with `gitlab-housekeeper` please create an issue with the
label ~"GitLab Housekeeper" and consider pinging the author of this keep.

Changelog: other

Merge branch 'backfill-desired-sharding-key-small-table-approval_project_rules_protected_branches' into 'master' 

Add and backfill project_id for approval_project_rules_protected_branche

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167648



Merged-by: Omar Qunsul <oqunsul@gitlab.com>
Approved-by: Jeff Park <jpark@gitlab.com>
Approved-by: Omar Qunsul <oqunsul@gitlab.com>
Co-authored-by: Shubham Kumar <shukumar@gitlab.com>

## What does this MR do and why?

Add and backfill project_id for approval_project_rules_protected_branches.

This table has a
[desired sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#define-a-desired_sharding_key-to-automatically-backfill-a-sharding_key)
configured ([view configuration](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/approval_project_rules_protected_branches.yml)).

This merge request is the first step towards transforming the desired sharding key into a
[sharding key](https://docs.gitlab.com/ee/development/database/multiple_databases.html#defining-a-sharding-key-for-all-cell-local-tables).

This involves three changes:

- Adding a new column that will serve as the sharding key (along with the relevant index and foreign key).
- Populating the sharding key when new records are created by adding a database function and trigger.
- Scheduling a [batched background migration](https://docs.gitlab.com/ee/development/database/batched_background_migrations.html)
  to set the sharding key for existing records.

Once the background migration has completed, a second merge request will be created to finalize the background
migration and validate the not null constraint.

## How to verify

We have assigned a random backend engineer from ~"group::source code" to review these changes. Please review this merge
request from a ~backend perspective. The main thing we are looking to verify is that the added column and association
match the values specified by the [desired sharding key](https://gitlab.com/gitlab-org/gitlab/-/blob/master/db/docs/approval_project_rules_protected_branches.yml)
configuration and that backfilling the column from this other table makes sense in the context of this feature.

When you are finished, please:

1. Trigger the [database testing pipeline](https://docs.gitlab.com/ee/development/database/database_migration_pipeline.html)
   as instructed by Danger.
1. Request a review from the ~backend maintainer and ~database reviewer suggested by Danger.

If you have any questions or concerns, reach out to `@tigerwnz` or @shubhamkrai.

This merge request was generated by a once off keep implemented in
https://gitlab.com/gitlab-org/gitlab/-/merge_requests/143774

This change was generated by
[gitlab-housekeeper](https://gitlab.com/gitlab-org/gitlab/-/tree/master/gems/gitlab-housekeeper)
using the Keeps::BackfillDesiredShardingKeySmallTable keep.

To provide feedback on your experience with `gitlab-housekeeper` please create an issue with the
label ~"GitLab Housekeeper" and consider pinging the author of this keep.

Changelog: other

Add integration test for policy scope all projects with exceptions

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167454



Merged-by: Alexander Turinske <aturinske@gitlab.com>
Approved-by: Alexander Turinske <aturinske@gitlab.com>
Co-authored-by: Artur Fedorov <afedorov@gitlab.com>

[ci skip]

Refactor labels service to use callback classes

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/162520



Merged-by: Madelein van Niekerk <mvanniekerk@gitlab.com>
Approved-by: Ryan Cobb <rcobb@gitlab.com>
Approved-by: Madelein van Niekerk <mvanniekerk@gitlab.com>
Reviewed-by: Heinrich Lee Yu <heinrich@gitlab.com>
Reviewed-by: Madelein van Niekerk <mvanniekerk@gitlab.com>
Co-authored-by: Heinrich Lee Yu <heinrich@gitlab.com>

Add legacy notes store

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167450



Merged-by: Phil Hughes <me@iamphill.com>
Approved-by: Thomas Randolph <trandolph@gitlab.com>
Approved-by: Phil Hughes <me@iamphill.com>
Co-authored-by: Stanislav Lashmanov <slashmanov@gitlab.com>

CTRT: installation requirements (6)

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166106



Merged-by: Fiona Neill <fneill@gitlab.com>
Approved-by: Jason Plum <jplum@gitlab.com>
Approved-by: Fiona Neill <fneill@gitlab.com>
Reviewed-by: Jason Plum <jplum@gitlab.com>
Co-authored-by: Ashraf Khamis <akhamis@gitlab.com>

Edit note about member promotion management

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167740



Merged-by: Suraj Tripathi <stripathi@gitlab.com>
Approved-by: Suraj Tripathi <stripathi@gitlab.com>
Co-authored-by: Lorena Ciutacu <lciutacu@gitlab.com>

Add sharding_key_id to ci_runners table

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166916



Merged-by: Pedro Pombeiro <noreply@pedro.pombei.ro>
Approved-by: Corinna Gogolok <cgogolok@gitlab.com>
Approved-by: Rodrigo Tomonari <rtomonari@gitlab.com>
Approved-by: Krasimir Angelov <kangelov@gitlab.com>
Approved-by: Tianwen Chen <tchen@gitlab.com>
Reviewed-by: Pedro Pombeiro <noreply@pedro.pombei.ro>
Reviewed-by: Krasimir Angelov <kangelov@gitlab.com>
Reviewed-by: Corinna Gogolok <cgogolok@gitlab.com>
Reviewed-by: Rodrigo Tomonari <rtomonari@gitlab.com>

Changelog: added

Migrate empty result for issuable list

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/166518



Merged-by: Phil Hughes <me@iamphill.com>
Approved-by: Chad Lavimoniere <clavimoniere@gitlab.com>
Approved-by: Doug Stull <dstull@gitlab.com>
Approved-by: Moaz Khalifa <mkhalifa@gitlab.com>
Approved-by: Phil Hughes <me@iamphill.com>
Reviewed-by: Moaz Khalifa <mkhalifa@gitlab.com>
Co-authored-by: Julia Miocene <jmiocene@gitlab.com>

Update free trial message

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/167637



Merged-by: Andrejs Cunskis <acunskis@gitlab.com>
Approved-by: Brittany Wilkerson <bwilkerson@gitlab.com>
Approved-by: Andrejs Cunskis <acunskis@gitlab.com>
Co-authored-by: Will Meek <wmeek@gitlab.com>