CI Partitions LFK dependency cleanups

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Context: #505813 (comment 2226473839)

It was discovered as part of this issue #505813 (closed) that CI new partitions, on p_ci_pipelines and p_ci_builds don't have LFK trigger installed. So as part of this issue we need to do the following:

1. Cleanup all the records that should have been deleted. By checking all the tables that depend on partitions of ci_builds from the YAML file: config/gitlab_loose_foreign_keys.yml, and delete all the records that should have been deleted, if their corresponding CI Build doesn't exist any more

References:

• https://docs.gitlab.com/ee/development/database/loose_foreign_keys.html

CC: @tianwenchen @ahegyi