Create the todos coalesced index

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



Merged-by: Adam Hegyi <ahegyi@gitlab.com>
Approved-by: Adam Hegyi <ahegyi@gitlab.com>
Reviewed-by: Paul Gascou-Vaillancourt <pgascouvaillancourt@gitlab.com>
Co-authored-by: Paul Gascou-Vaillancourt <paul.gascvail@gmail.com>

Creates the `timestamp_coalesce` SQL function which applies a `COALESCE`
clause to two potentially mismatching timestamp column types.

This will be used to create an index for the `todos` table, letting us
query rows by `COALESCE(snoozed_until, created_at)` in an efficient way
despite `snoozed_until` being of type `datetime_with_timezone` while
`created_at` is of type `datetime_without_timezone`.

Add breadcrumbs to the new project creation form

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



Merged-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Approved-by: Sascha Eggenberger <seggenberger@gitlab.com>
Approved-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Reviewed-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Reviewed-by: Sascha Eggenberger <seggenberger@gitlab.com>
Co-authored-by: Julia Miocene <jmiocene@gitlab.com>

Update docs to use admin settings to update global search settings

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



Merged-by: Tomas Bulva <tbulva@gitlab.com>
Approved-by: Ashraf Khamis <akhamis@gitlab.com>
Approved-by: Tomas Bulva <tbulva@gitlab.com>
Reviewed-by: Terri Chu <tchu@gitlab.com>
Reviewed-by: Ashraf Khamis <akhamis@gitlab.com>
Co-authored-by: Siddharth Dungarwal <sdungarwal@gitlab.com>

Updates group dormant members docs

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



Merged-by: Lorena Ciutacu <lciutacu@gitlab.com>
Approved-by: Lorena Ciutacu <lciutacu@gitlab.com>
Reviewed-by: Lorena Ciutacu <lciutacu@gitlab.com>
Co-authored-by: Vijay Hawoldar <vhawoldar@gitlab.com>

Updates the documentation to remove a reference to an old dormant criteria that
has been removed

Move publish to pages.publish

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



Merged-by: Lukas Eipert <leipert@gitlab.com>
Approved-by: Julie Huang <julhuang@gitlab.com>
Approved-by: Alisa Frunza <afrunza@gitlab.com>
Approved-by: Sam Word <sword@gitlab.com>
Approved-by: Pedro Pombeiro <noreply@pedro.pombei.ro>
Approved-by: Lukas Eipert <leipert@gitlab.com>
Reviewed-by: Lukas Eipert <leipert@gitlab.com>
Reviewed-by: Pedro Pombeiro <noreply@pedro.pombei.ro>
Reviewed-by: Sam Word <sword@gitlab.com>
Reviewed-by: Alisa Frunza <afrunza@gitlab.com>
Co-authored-by: ngala <ngala@gitlab.com>

Related: https://gitlab.com/gitlab-org/gitlab/-/issues/428018

Changelog: changed

Add a JSON service for exporting frameworks

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



Merged-by: Harsimar Sandhu <hsandhu@gitlab.com>
Approved-by: Hitesh Raghuvanshi <hraghuvanshi@gitlab.com>
Approved-by: Harsimar Sandhu <hsandhu@gitlab.com>
Reviewed-by: Hitesh Raghuvanshi <hraghuvanshi@gitlab.com>
Reviewed-by: GitLab Duo <gitlab-duo@gitlab.com>
Reviewed-by: Dakota Dux <ddux@gitlab.com>
Co-authored-by: dakotadux <ddux@gitlab.com>

We're moving the expression parsing to a public method so that it can be
used in the JSON export service.

Add indexes to web_hook_logs_daily

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



Merged-by: Pavel Shutsin <pshutsin@gitlab.com>
Approved-by: Igor Drozdov <idrozdov@gitlab.com>
Approved-by: Pavel Shutsin <pshutsin@gitlab.com>
Co-authored-by: Maxime Orefice <morefice@gitlab.com>

Disable custom role delete button for sec policy

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



Merged-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Approved-by: Daniele Rossetti <drossetti@gitlab.com>
Approved-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Reviewed-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Reviewed-by: Alexander Turinske <aturinske@gitlab.com>
Reviewed-by: Sheldon Led <sheldonled@gitlab.com>
Reviewed-by: Ryan Lehmann <rlehmann@gitlab.com>
Co-authored-by: Alexander Turinske <aturinske@gitlab.com>

- if a custom role is used in a security policy, then it should not
  be able to be deleted
- disable delete button if it is used in a security policy on
  the frontend
- if there are dependent security policies, we use a
  popover instead of a tooltip
- update tests

Changelog: added

EE: true

Replace work item list tabs with search tokens

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



Merged-by: Natalia Tepluhina <ntepluhina@gitlab.com>
Approved-by: Nick Brandt <nbrandt@gitlab.com>
Approved-by: Jack Chapman <jachapman@gitlab.com>
Approved-by: Natalia Tepluhina <ntepluhina@gitlab.com>
Reviewed-by: Natalia Tepluhina <ntepluhina@gitlab.com>
Reviewed-by: Jack Chapman <jachapman@gitlab.com>
Co-authored-by: Chaitanya Sonwane <chaitanyadsonwane2002@gmail.com>

(Part 2) Adding Loose Foreign Key trigger to existing CI Partitions

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



Merged-by: Adam Hegyi <ahegyi@gitlab.com>
Approved-by: Tianwen Chen <tchen@gitlab.com>
Approved-by: Adam Hegyi <ahegyi@gitlab.com>
Reviewed-by: Marius Bobin <mbobin@gitlab.com>
Reviewed-by: Tianwen Chen <tchen@gitlab.com>
Co-authored-by: Omar Qunsul <oqunsul@gitlab.com>

Changelog: other
First part of issue https://gitlab.com/gitlab-org/gitlab/-/issues/507343

Update dependency @sentry/browser to v8.54.0

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



Merged-by: Sheldon Led <sheldonled@gitlab.com>
Approved-by: Sheldon Led <sheldonled@gitlab.com>
Co-authored-by: GitLab Renovate Bot <gitlab-bot@gitlab.com>

Edit alt text for scheme previews

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



Merged-by: Paulina Sedlak-Jakubowska <psedlak-jakubowska@gitlab.com>
Approved-by: David O'Regan <doregan@gitlab.com>
Approved-by: Natalia Tepluhina <ntepluhina@gitlab.com>

Replaces yamlErrorMessags with errorMessages in headerbadges

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



Merged-by: Avielle Wolfe <awolfe@gitlab.com>
Approved-by: Briley Sandlin <bsandlin@gitlab.com>
Approved-by: Avielle Wolfe <awolfe@gitlab.com>
Co-authored-by: Laura Montemayor <lmontemayor@gitlab.com>

Add indexes for `verified_at` and `last_synced_at` fields on Geo Registry records

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



Merged-by: Pavel Shutsin <pshutsin@gitlab.com>
Approved-by: Fabien Catteau <fcatteau@gitlab.com>
Approved-by: Pavel Shutsin <pshutsin@gitlab.com>
Reviewed-by: Fabien Catteau <fcatteau@gitlab.com>
Reviewed-by: Pavel Shutsin <pshutsin@gitlab.com>
Co-authored-by: c_fons <cfons@gitlab.com>

In order to be able to order the records by
`verified_at` and `last_synced_at`, add an index
on each field, for each table.

EE: true
Relates to: https://gitlab.com/gitlab-org/gitlab/-/issues/514998

Enforce NOT NULL constraint on vulnerabilities.detected_at

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



Merged-by: Gregory Havenga <11164960-ghavenga@users.noreply.gitlab.com>
Approved-by: Tyler Amos <tamos@gitlab.com>
Approved-by: Ash McKenzie <amckenzie@gitlab.com>
Approved-by: Gregory Havenga <11164960-ghavenga@users.noreply.gitlab.com>
Reviewed-by: Ash McKenzie <amckenzie@gitlab.com>
Reviewed-by: Tyler Amos <tamos@gitlab.com>
Co-authored-by: Michał Zając <mzajac@gitlab.com>

* Add model validation
* Add NOT NULL constraint to vulnerabilities.detected_at column
* Schedule NOT NULL constraint validation

Changelog: added

Truncate the project description when it is long in the CI/CD Catalog

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



Merged-by: Jacques Erasmus <jerasmus@gitlab.com>
Approved-by: Sunjung Park <spark@gitlab.com>
Approved-by: Ammar Alakkad <aalakkad@gitlab.com>
Approved-by: Jacques Erasmus <jerasmus@gitlab.com>
Co-authored-by: Anton Kalmykov <anton.kalmykov@proton.me>

Merge branch '229663-improve-slow-tests-in-spec-models-design_management-design_at_version_spec-rb' into 'master' 

Improve performance of design_at_version specs

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



Merged-by: Tetiana Chupryna <tchupryna@gitlab.com>
Approved-by: Minahil Nichols <minahilnichols@gitlab.com>
Approved-by: Tetiana Chupryna <tchupryna@gitlab.com>
Co-authored-by: Matt D'Angelo <mdangelo@gitlab.com>

Add write buffer to  AiUserMetrics model

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



Merged-by: Jan Provaznik <jprovaznik@gitlab.com>
Approved-by: Dillon Wheeler <dwheeler@gitlab.com>
Approved-by: Jan Provaznik <jprovaznik@gitlab.com>
Approved-by: Adam Hegyi <ahegyi@gitlab.com>
Reviewed-by: Jan Provaznik <jprovaznik@gitlab.com>
Reviewed-by: Pavel Shutsin <pshutsin@gitlab.com>
Reviewed-by: Dillon Wheeler <dwheeler@gitlab.com>
Reviewed-by: Bishwa Hang Rai <bhrai@gitlab.com>
Co-authored-by: Pavel Shutsin <pshutsin@gitlab.com>

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

Add and backfill project_id for dast_pre_scan_verification_steps

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



Merged-by: Omar Qunsul <oqunsul@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 dast_pre_scan_verification_steps.

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/dast_pre_scan_verification_steps.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::dynamic analysis" 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/dast_pre_scan_verification_steps.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

Edit headings on DORA docs

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



Merged-by: Lorena Ciutacu <lciutacu@gitlab.com>
Reviewed-by: Ashraf Khamis <akhamis@gitlab.com>
Reviewed-by: Lorena Ciutacu <lciutacu@gitlab.com>

Merge branch '509301-404-and-other-error-pages-don-t-load-gitlab-ui-styles-but-try-to-use-gitlab-ui-components-no-vite' into 'master' 

Fix styles on error page when Vite is disabled

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



Merged-by: Olena Horal-Koretska <ohoralkoretska@gitlab.com>
Approved-by: Patrick Bajao <ebajao@gitlab.com>
Approved-by: Olena Horal-Koretska <ohoralkoretska@gitlab.com>
Co-authored-by: Florie Guibert <fguibert@gitlab.com>

Update Matrix notification integration

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



Merged-by: Bojan Marjanovic <bmarjanovic@gitlab.com>
Approved-by: Bojan Marjanovic <bmarjanovic@gitlab.com>
Reviewed-by: Justin Ho Tuan Duong <hduong@gitlab.com>
Reviewed-by: Bojan Marjanovic <bmarjanovic@gitlab.com>
Co-authored-by: Tulir Asokan <tulir@maunium.net>

Create qa image for internal release

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



Merged-by: Dat Tang <dattang@gitlab.com>
Approved-by: Kev Kloss <kkloss@gitlab.com>
Reviewed-by: Kev Kloss <kkloss@gitlab.com>

Expose link information in field linkedWorkItems

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



Merged-by: Chad Woolley <cwoolley@gitlab.com>
Approved-by: Michał Zając <mzajac@gitlab.com>
Approved-by: Chad Woolley <cwoolley@gitlab.com>
Reviewed-by: Michał Zając <mzajac@gitlab.com>
Reviewed-by: Chad Woolley <cwoolley@gitlab.com>
Co-authored-by: Eugenia Grieff <egrieff@gitlab.com>