We want to drop the `vulnerability_occurrence_pipelines` table. In
order to do this, we still need the first and latest pipeline ID
stored somewhere to support the existing feature-set

We added these columns, along with indexes, in previous commits.

With that work done, we are now unblocked to add foreign keys and
model associations, to prepare to actually backfill and use these
columns

Loose Foreign Keys
------------------------

As the pipelines table and the vulnerabilities table are in separate
databases, we need to use [loose foreign keys][0]. As part of that
process, I ran the script:

```sh
scripts/decomposition/generate-loose-foreign-key -c vulnerability_occurrences
```

This generated specs that were not passing. To make these specs pass I
needed to modify the factories from:

```ruby
let_it_be(:model) { create(:vulnerability_occurrences, initial_pipeline: parent) }
let_it_be(:model) { create(:vulnerability_occurrences, latest_pipeline: parent) }
```

to:

```ruby
let_it_be(:model) { create(:vulnerabilities_finding, initial_pipeline_id: parent.id) }
let_it_be(:model) { create(:vulnerabilities_finding, latest_pipeline_id: parent.id) }
```

[0]:https://docs.gitlab.com/ee/development/database/loose_foreign_keys.html

related to: #422382
resolves: #443284
resolves: #443283

Changelog: changed

We want to drop the `vulnerability_occurrence_pipelines` table. In
order to do this, we still need the first and latest pipeline ID
stored somewhere to support the existing feature-set

The columns and asynchronous index creation were added in a
[previous MR][0]

This change adds the synchronous index migration to complete the index
creation [process][1]

Follow-up Work
---------------------------

We will need to add loose foreign keys and model association. Both of
these are blocked on this index creation

That work is tracked in the following tasks:

- #443283
- #443284

---

Related to #422382
Resolves #443282

[0]:!144697
[1]:https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#create-indexes-asynchronously

Changelog: added

We want to drop the `vulnerability_occurrence_pipelines` table. In
order to do this, we still need the first and latest pipeline ID
stored somewhere to support the existing feature-set

Follow-up Work
---------------------------

We will need to add loose foreign keys and model association. Both of
these are blocked on index creation, which has to be done via the
[async process][0]

That work is tracked in the following tasks:

- #443282
- #443283
- #443284

---

Related to #422382
Resolves #443281
Resolves #443280

[0]:https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#create-indexes-asynchronously

Changelog: added

CI: Decrease the expected runtimes of `gettext:updated_check` rake task

See merge request !144359



Merged-by: David Dieulivol <ddieulivol@gitlab.com>
Approved-by: David Dieulivol <ddieulivol@gitlab.com>
Co-authored-by: Peter Leitzen <pleitzen@gitlab.com>

Add new generic worker to handle auto merges from events

See merge request !145460



Merged-by: Patrick Bajao <ebajao@gitlab.com>
Approved-by: Patrick Bajao <ebajao@gitlab.com>
Approved-by: Alex Buijs <abuijs@gitlab.com>
Reviewed-by: Patrick Bajao <ebajao@gitlab.com>
Reviewed-by: Alex Buijs <abuijs@gitlab.com>
Co-authored-by: Marc Shaw <mshaw@gitlab.com>

Update Opensearch port requirements

See merge request !145737



Merged-by: Ashraf Khamis <akhamis@gitlab.com>
Co-authored-by: Kent Japhet Ballon <kballon@gitlab.com>

Turn on link-fragments Markdownlint check

See merge request !145471



Merged-by: Kati Paizee <kpaizee@gitlab.com>
Approved-by: Kati Paizee <kpaizee@gitlab.com>
Approved-by: Diana Logan <dlogan@gitlab.com>
Co-authored-by: Evan Read <eread@gitlab.com>

Adds Service Desk overview video to gitlab navigation tutorials

See merge request !145596



Merged-by: Kati Paizee <kpaizee@gitlab.com>
Approved-by: Kati Paizee <kpaizee@gitlab.com>
Co-authored-by: Marc Saleiko <msaleiko@gitlab.com>
Co-authored-by: Marcin Sedlak-Jakubowski <msedlakjakubowski@gitlab.com>

Tag spec with :elastic to fix broken master

See merge request !145770



Merged-by: Ash McKenzie <amckenzie@gitlab.com>
Approved-by: Ash McKenzie <amckenzie@gitlab.com>
Co-authored-by: Patrick Bajao <ebajao@gitlab.com>

Improve clarity of FF changelog flow diagram

See merge request !145740



Merged-by: Mark Chao <mchao@gitlab.com>
Approved-by: Mark Chao <mchao@gitlab.com>
Co-authored-by: Malcolm Locke <mlocke@gitlab.com>

Changelog: added

Remove GPC from the Browser SDK Doc

See merge request !145105



Merged-by: Niko Belokolodov <nbelokolodov@gitlab.com>
Approved-by: Michał Wielich <mwielich@gitlab.com>
Approved-by: Niko Belokolodov <nbelokolodov@gitlab.com>
Co-authored-by: Ankit <apanchal@gitlab.com>

[Token notifications] Clarify owners are also notified of PAT expiry

See merge request !145630



Merged-by: Russell Dickenson <rdickenson@gitlab.com>
Approved-by: Russell Dickenson <rdickenson@gitlab.com>
Co-authored-by: Tom McAtee <tmcatee@gitlab.com>

Deprecation: Container registry API pagination

See merge request !143393



Merged-by: Marcel Amirault <mamirault@gitlab.com>
Approved-by: Crystal Poole <cpoole@gitlab.com>
Approved-by: Marcel Amirault <mamirault@gitlab.com>
Reviewed-by: Marcel Amirault <mamirault@gitlab.com>
Co-authored-by: Tim Rizzi <trizzi@gitlab.com>
Co-authored-by: Adie (she/her) <avpfestin@gitlab.com>

Secret detection vulnerabilities not auto set to "No longer detected"

See merge request !145442



Merged-by: Russell Dickenson <rdickenson@gitlab.com>
Approved-by: Neil McCorrison <nmccorrison@gitlab.com>
Co-authored-by: Bruno Freitas <bfreitas@gitlab.com>

Fix tables and links in blueprint docs

See merge request !145202



Merged-by: Evan Read <eread@gitlab.com>
Approved-by: Kamil Trzciński <ayufan@ayufan.eu>
Approved-by: Evan Read <eread@gitlab.com>
Reviewed-by: Kamil Trzciński <ayufan@ayufan.eu>
Co-authored-by: Marcel Amirault <mamirault@gitlab.com>

Remove sentence in docs saying pipeline name not available by default

See merge request !145662



Merged-by: Marcel Amirault <mamirault@gitlab.com>
Approved-by: Marcel Amirault <mamirault@gitlab.com>
Co-authored-by: Reuben Pereira <rpereira@gitlab.com>

Bring user accounts section under prerequisites

See merge request !145735



Merged-by: Russell Dickenson <rdickenson@gitlab.com>
Co-authored-by: Evan Read <eread@gitlab.com>

Update Security demo publication date

See merge request !145734



Merged-by: Evan Read <eread@gitlab.com>
Approved-by: Evan Read <eread@gitlab.com>
Co-authored-by: Russell Dickenson <rdickenson@gitlab.com>

doc/gitaly: Update the documentation for commit signing

See merge request !145652



Merged-by: Evan Read <eread@gitlab.com>
Approved-by: Evan Read <eread@gitlab.com>
Co-authored-by: Karthik Nayak <knayak@gitlab.com>

Revert "Update to account for v16 changes"

See merge request !145672



Merged-by: Russell Dickenson <rdickenson@gitlab.com>
Approved-by: Russell Dickenson <rdickenson@gitlab.com>
Co-authored-by: David Nelson <dnelson@gitlab.com>

Add supported architectures section for operational container scanning

See merge request !145592



Merged-by: Russell Dickenson <rdickenson@gitlab.com>
Approved-by: Thiago Figueiró <tfigueiro@gitlab.com>
Co-authored-by: Nick Ilieskou <nilieskou@gitlab.com>

Update Cells prefix routing spec

See merge request !145639



Merged-by: Thong Kuah <tkuah@gitlab.com>
Approved-by: Thong Kuah <tkuah@gitlab.com>
Co-authored-by: Steve Xuereb <sxuereb@gitlab.com>

Align docs style guide with MD table format steps

See merge request !145023



Merged-by: Suzanne Selhorn <sselhorn@gitlab.com>
Co-authored-by: Edward Angert <eangert-ext@gitlab.com>

Add more detail to the offering badges rule message

See merge request !145354



Merged-by: Suzanne Selhorn <sselhorn@gitlab.com>
Approved-by: Suzanne Selhorn <sselhorn@gitlab.com>
Co-authored-by: Evan Read <eread@gitlab.com>

Fix typo in email ingestion flowchart

See merge request !145659



Merged-by: Amy Qualls <aqualls@gitlab.com>
Approved-by: Amy Qualls <aqualls@gitlab.com>
Approved-by: Marc Saleiko <msaleiko@gitlab.com>
Co-authored-by: Steve Xuereb <sxuereb@gitlab.com>