Clean up unused FK for ci_stages

Problem

After making sure our referenced FK include partition_id in #436526 (closed).

Solution

• Remove fk_3a9eaa254d FK

ALTER TABLE p_ci_builds
  ADD CONSTRAINT fk_3a9eaa254d FOREIGN KEY (stage_id) REFERENCES ci_stages(id) ON DELETE CASCADE;

added to epic &12107 (closed)

@carolinesimpson, Please add a group or category label to identify issue ownership.

You can refer to the Features by Group handbook page for guidance.

If you are unsure about the correct group, please do not leave the issue without a group label, and refer to GitLab's shared responsibility functionality guidelines for more information on how to triage this kind of issue.

This message was generated automatically. You're welcome to improve it.

added CI data partitioning Category:Continuous Integration backend ciscaling cicdactive database devopsverify grouppipeline execution maintenancescalability sectionci typemaintenance workflowready for development labels

set weight to 3

marked this issue as blocked by #436527 (closed)

changed the description

added workflowplanning breakdown label and removed workflowready for development label

@panoskanell can you work with @morefice to determine if there are indexes/FKs that should be removed for ci_stages once we update FK to include partition id? Thanks!

removed weight

added cicdplanning needs weight labels and removed cicdactive label

changed milestone to %16.9

mentioned in epic &7522

mentioned in issue gitlab-org/database-team/team-tasks#397 (closed)

assigned to @panoskanell

added Deliverable label

set weight to 3

added cicdactive label and removed cicdplanning label

Setting health status to on track as the milestone has just begun.

Issue participants are welcome to override this by setting the health status to another value.

changed health status to on track

assigned to @morefice

unassigned @panoskanell

removed Deliverable label

changed milestone to %16.10

changed title from Clean up unused indexes/FKs for ci_stages to Clean up unused FK for ci_stages

changed the description

added workflowin dev label and removed workflowplanning breakdown label

added workflowin review label and removed workflowin dev label

mentioned in merge request !144021 (merged)

marked the checklist item Remove fk_3a9eaa254d FK as completed

changed weight to 1 from 3

changed milestone to %16.9

@morefice this was completed today: https://console.postgres.ai/gitlab/gitlab-production-ci/sessions/26111/commands/82170

@mbobin

Awesome thanks for double checking!

I hope !144167 (merged) will be executed this weekend

unlikely to be deployed in time.

added workflowcomplete label and removed workflowin review label

closed