[FF] `drop_stuck_builds_from_ci_pending_builds_queue` -- Fetch stuck builds from ci_pending_builds instead of p_ci_builds, and fix batching bug
<!-- Title suggestion: [FF] `drop_stuck_builds_from_ci_pending_builds_queue` -- <short description> --> ## Summary This issue is to roll out [the feature](https://gitlab.com/gitlab-org/gitlab/-/work_items/595216) on production, that is currently behind the `drop_stuck_builds_from_ci_pending_builds_queue` feature flag. MR that introduced the FF: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/229567+ ### Roll-out strategy The actor is `:instance` because `Ci::StuckBuilds::DropPendingService` is run in a background cron worker [`StuckCiJobsWorker`](https://gitlab.com/gitlab-org/gitlab/-/blob/b413369640454f3a811b73f3196578ecaaa3b040/app/workers/stuck_ci_jobs_worker.rb) that executes [once each hour](https://gitlab.com/gitlab-org/gitlab/-/blob/b413369640454f3a811b73f3196578ecaaa3b040/config/initializers/1_settings.rb#L536) and applies globally to all pending builds. After we enable the FF, we won't see a behaviour difference until the worker runs. So we need to wait to check logs/graphs on the hour. ## Owners - Most appropriate Slack channel to reach out to: `#g_ci-platform` - Best individual to reach out to: @lma-git ## Expectations ### What are we expecting to happen? The `drop_stuck` query of [`Ci::StuckBuilds::DropPendingService`](https://gitlab.com/gitlab-org/gitlab/-/blob/393b5d93b8cbb465b2d9ad853a3ab9b1d0434c88/app/services/ci/stuck_builds/drop_pending_service.rb) will fetch builds from `ci_pending_builds` instead of `p_ci_builds`. This resolves both: - https://gitlab.com/gitlab-org/gitlab/-/work_items/595216+ - https://gitlab.com/gitlab-org/gitlab/-/issues/595153+ No direct customer-facing changes are expected. More stuck jobs should be properly dropped after an hour instead of waiting to be dropped by [`drop`](https://gitlab.com/gitlab-org/gitlab/-/blob/393b5d93b8cbb465b2d9ad853a3ab9b1d0434c88/app/services/ci/stuck_builds/drop_pending_service.rb#L14-16) after 24 hours. ### What can go wrong and how would we detect it? - Monitor data on `ci_pending_builds` (Grafana) - Monitor logs related to `StuckCiJobsWorker` or `Ci::StuckBuilds::DropPendingService` - Run queries on Postgres.ai to see the number of pending builds on `p_ci_builds` vs `ci_pending_builds`. See queries in https://gitlab.com/gitlab-org/gitlab/-/merge_requests/229567#note_3211001430. ## Rollout Steps **Actor is Instance type. See Roll-out Strategy above.** ### Rollout on non-production environments - Verify the MR with the feature flag is merged to `master` and has been deployed to non-production environments with `/chatops gitlab run auto_deploy status <merge-commit-of-your-feature>` - [x] Enable the feature globally on non-production environments with `/chatops gitlab run feature set drop_stuck_builds_from_ci_pending_builds_queue true --dev --pre --staging --staging-ref` - [x] Verify that the feature works as expected. The best environment to validate the feature in is [`staging-canary`](https://about.gitlab.com/handbook/engineering/infrastructure/environments/#staging-canary) as this is the first environment deployed to. Make sure you are [configured to use canary](https://next.gitlab.com/). - [ ] If the feature flag causes end-to-end tests to fail, disable the feature flag on staging to avoid blocking [deployments](https://about.gitlab.com/handbook/engineering/deployments-and-releases/deployments/). - See [`#e2e-run-staging` Slack channel](https://gitlab.enterprise.slack.com/archives/CBS3YKMGD) and look for the following messages: - test kicked off: `Feature flag drop_stuck_builds_from_ci_pending_builds_queue has been set to true on **gstg**` - test result: `This pipeline was triggered due to toggling of drop_stuck_builds_from_ci_pending_builds_queue feature flag` If you encounter end-to-end test failures and are unable to diagnose them, you may reach out to the [`#s_developer_experience` Slack channel](https://gitlab.enterprise.slack.com/archives/C07TWBRER7H) for assistance. Note that end-to-end test failures on `staging-ref` [don't block deployments](https://about.gitlab.com/handbook/engineering/infrastructure/environments/staging-ref/#how-to-use-staging-ref). ### Before production rollout - [ ] If the change is significant and you wanted to announce in [#whats-happening-at-gitlab](https://gitlab.enterprise.slack.com/archives/C0259241C), it best to do it before rollout to `gitlab-org/gitlab-com`. ### ~~Specific rollout on production~~ Actor is Instance For visibility, all `/chatops` commands that target production must be executed in the [`#production` Slack channel](https://gitlab.slack.com/archives/C101F3796) and cross-posted (with the command results) to the responsible team's Slack channel. - Ensure that the feature MRs have been deployed to both production and canary with `/chatops gitlab run auto_deploy status <merge-commit-of-your-feature>` - [ ] Depending on the [type of actor](https://docs.gitlab.com/development/feature_flags/#feature-actors) you are using, pick one of these options: - For **project-actor**: `/chatops gitlab run feature set --project=gitlab-org/gitlab,gitlab-org/gitlab-foss,gitlab-com/www-gitlab-com drop_stuck_builds_from_ci_pending_builds_queue true` - For **group-actor**: `/chatops gitlab run feature set --group=gitlab-org,gitlab-com drop_stuck_builds_from_ci_pending_builds_queue true` - For **user-actor**: `/chatops gitlab run feature set --user=lma-git drop_stuck_builds_from_ci_pending_builds_queue true` - For **all internal users**: `/chatops gitlab run feature set --feature-group=gitlab_team_members drop_stuck_builds_from_ci_pending_builds_queue true` - [ ] Verify that the feature works for the specific actors. ### Preparation before global rollout - [x] Set a milestone to this rollout issue to signal for enabling and removing the feature flag when it is stable. - [ ] Check if the feature flag change needs to be accompanied with a [change management issue](https://about.gitlab.com/handbook/engineering/infrastructure-platforms/change-management/#feature-flags-and-the-change-management-process). Cross link the issue here if it does. - [x] Ensure that you or a representative in development can be available for at least 2 hours after feature flag updates in production. If a different developer will be covering, or an exception is needed, please inform the oncall SRE by using the `@sre-oncall` Slack alias. - [ ] Ensure that documentation exists for the feature, and the [version history text](https://docs.gitlab.com/development/documentation/feature_flags/#add-history-text) has been updated. - [ ] Ensure that any breaking changes have been announced following the [release post process](https://about.gitlab.com/handbook/marketing/blog/release-posts/#deprecations-removals-and-breaking-changes) to ensure GitLab customers are aware. - [ ] Notify the [`#support_gitlab-com` Slack channel](https://gitlab.slack.com/archives/C4XFU81LG) and your team channel ([more guidance when this is necessary in the dev docs](https://docs.gitlab.com/development/feature_flags/controls/#communicate-the-change)). - [ ] If this flag is or may be queried by external API consumers (for example, IDE extensions, Duo CLI, or CI integrations), follow the [external API consumer guidance](https://docs.gitlab.com/development/feature_flags/#do-not-use-feature-flags-in-external-api-consumers) and ensure a fail-open mechanism is in place before the rollout milestone is finalised. ### Global rollout on production For visibility, all `/chatops` commands that target production must be executed in the [`#production` Slack channel](https://gitlab.slack.com/archives/C101F3796) and cross-posted (with the command results) to the responsible team's Slack channel. - [x] ~~[Incrementally roll out](https://docs.gitlab.com/development/feature_flags/controls/#process) the feature on production.~~ **Actor is Instance** - Example: `/chatops gitlab run feature set drop_stuck_builds_from_ci_pending_builds_queue <rollout-percentage> --actors`. - Between every step wait for at least 15 minutes and monitor the appropriate graphs on https://dashboards.gitlab.net. - [x] After the feature has been 100% enabled, wait for [at least one day before releasing the feature](#release-the-feature). ### (Optional) Release the feature with the feature flag **WARNING:** This approach has the downside that it makes it difficult for us to [clean up](https://docs.gitlab.com/development/feature_flags/controls/#cleaning-up) the flag. For example, on-premise users could disable the feature on their GitLab instance. But when you remove the flag at some point, they suddenly see the feature as enabled and they can't roll it back to the previous behavior. To avoid this potential breaking change, use this approach only for urgent matters. <details><summary>See instructions if you're sure about enabling the feature globally through the feature flag definition</summary> If you're still unsure whether the feature is [deemed stable](https://about.gitlab.com/handbook/product-development-flow/feature-flag-lifecycle/#including-a-feature-behind-feature-flag-in-the-final-release) but want to release it in the current milestone, you can change the default state of the feature flag to be enabled. To do so, follow these steps: - [ ] Create a merge request with the following changes. - [ ] If feature was enabled for various actors, ensure the feature has been enabled globally on production `/chatops gitlab run feature get drop_stuck_builds_from_ci_pending_builds_queue`. If the feature has not been globally enabled then enable the feature globally using: `/chatops gitlab run feature set drop_stuck_builds_from_ci_pending_builds_queue true` - [ ] Set the `default_enabled` attribute in [the feature flag definition](https://docs.gitlab.com/development/feature_flags/#feature-flag-definition-and-validation) to `true`. - [ ] Decide [which changelog entry](https://docs.gitlab.com/development/feature_flags/#changelog) is needed. - [ ] Ensure that the default-enabling MR has been included in the release package. If the merge request was deployed before [the monthly release was tagged](https://about.gitlab.com/handbook/engineering/releases/#self-managed-releases-1), the feature can be officially announced in a release blog post: `/chatops gitlab run release check https://gitlab.com/gitlab-org/gitlab/-/merge_requests/229567 18.11` - [ ] After the default-enabling MR has been deployed, clean up the feature flag from all environments by running these chatops command in the `#production` channel: `/chatops gitlab run feature delete drop_stuck_builds_from_ci_pending_builds_queue --dev --pre --staging --staging-ref --production` - [ ] Close [the feature issue](https://gitlab.com/gitlab-org/gitlab/-/work_items/595216) to indicate the feature will be released in the current milestone. - [ ] Set the next milestone to this rollout issue for scheduling [the flag removal](#release-the-feature). - [ ] (Optional) You can [create a separate issue](https://gitlab.com/gitlab-org/gitlab/-/issues/new?issuable_template=Feature%20Flag%20Cleanup) for scheduling the steps below to [Release the feature](#release-the-feature). - [ ] Set the title to "[FF] `drop_stuck_builds_from_ci_pending_builds_queue` - Cleanup". - [ ] Execute the `/copy_metadata <this-rollout-issue-link>` quick action to copy the labels from this rollout issue. - [ ] Link this rollout issue as a related issue. - [ ] Close this rollout issue. </details> ### Release the feature After the feature has been [deemed stable](https://about.gitlab.com/handbook/product-development-flow/feature-flag-lifecycle/#including-a-feature-behind-feature-flag-in-the-final-release), the [clean up](https://docs.gitlab.com/development/feature_flags/controls/#cleaning-up) should be done as soon as possible to permanently enable the feature and reduce complexity in the codebase. You can either [create a follow-up issue for Feature Flag Cleanup](https://gitlab.com/gitlab-org/gitlab/-/issues/new?issuable_template=Feature%20Flag%20Cleanup) or use the checklist below in this same issue. <!-- The checklist here is to help stakeholders keep track of the feature flag status --> - [x] Create a merge request to remove the `drop_stuck_builds_from_ci_pending_builds_queue` feature flag. Ask for review/approval/merge as usual. The MR should include the following changes: - Remove all references to the feature flag from the codebase. - Remove the YAML definitions for the feature from the repository. - [x] Ensure that the cleanup MR has been included in the release package. If the merge request was deployed before [the monthly release was tagged](https://about.gitlab.com/handbook/engineering/releases/#self-managed-releases-1), the feature can be officially announced in a release blog post: `/chatops gitlab run release check https://gitlab.com/gitlab-org/gitlab/-/merge_requests/229567 18.11` - [x] Close [the feature issue](https://gitlab.com/gitlab-org/gitlab/-/work_items/595216) to indicate the feature will be released in the current milestone. - [x] Once the cleanup MR has been deployed to production, clean up the feature flag from all environments by running these chatops command in `#production` channel: `/chatops gitlab run feature delete drop_stuck_builds_from_ci_pending_builds_queue --dev --pre --staging --staging-ref --production` - [ ] Close this rollout issue. ## Rollback Steps - [ ] This feature can be disabled on production by running the following Chatops command: ``` /chatops gitlab run feature set drop_stuck_builds_from_ci_pending_builds_queue false ``` - [ ] Disable the feature flag on non-production environments: ``` /chatops gitlab run feature set drop_stuck_builds_from_ci_pending_builds_queue false --dev --pre --staging --staging-ref ``` - [ ] Delete feature flag from all environments: ``` /chatops gitlab run feature delete drop_stuck_builds_from_ci_pending_builds_queue --dev --pre --staging --staging-ref --production ```
issue