[Feature flag] Rollout of `ci_partitioning_analyze_queries_partition_id_check`

Summary

This issue is to rollout Ci::PartitioningIdAnalyzer on production, that is currently behind the ci_partitioning_analyze_queries_partition_id_check feature flag.

Owners

• Team: grouppipeline execution
• Most appropriate Slack channel to reach out to: #g_pipeline_execution
• Best individual to reach out to: @morefice
• PM:

Stakeholders

Expectations

We should to detect queries adding partitition_id when hitting a partitionned routing table.

What are we expecting to happen?

We should raise errors when a query does not include partitition_id.

When is the feature viable?

Feature.enable(:ci_partitioning_analyze_queries_partition_id_check)

What might happen if this goes wrong?

Query time and error rate increase.

What can we monitor to detect problems with this?

Consider mentioning checks for 5xx errors or other anomalies like an increase in redirects (302 HTTP response status)

• https://dashboards.gitlab.net/d/stage-groups-pipeline_execution/stage-groups-pipeline-execution-group-dashboard?orgId=1

What can we check for monitoring production after rollouts?

Consider adding links to check for Sentry errors, Production logs for 5xx, 302s, etc.

Rollout Steps

Rollout on non-production environments

• Ensure that the feature MRs have been deployed to non-production environments.
  • /chatops run auto_deploy status <merge-commit-of-your-feature>
• Enable the feature globally on non-production environments.
  • /chatops run feature set ci_partitioning_analyze_queries_partition_id_check true --dev --staging --staging-ref
• Verify that the feature works as expected. Posting the QA result in this issue is preferable. The best environment to validate the feature in is staging-canary as this is the first environment deployed to. Note you will need to make sure you are configured to use canary as outlined here when accessing the staging environment in order to make sure you are testing appropriately.

Specific rollout on production

• Ensure that the feature MRs have been deployed to both production and canary.
  • /chatops run auto_deploy status <merge-commit-of-your-feature>
• If you're using project-actor, you must enable the feature on these entries:
  • /chatops run feature set --project=gitlab-org/gitlab,gitlab-org/gitlab-foss,gitlab-com/www-gitlab-com ci_partitioning_analyze_queries_partition_id_check true
• Verify that the feature works on the specific entries. Posting the QA result in this issue is preferable.

Preparation before global rollout

• Check if the feature flag change needs to be accompanied with a change management issue. Cross link the issue here if it does.
• 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 has been updated (More info).
• Announce on the feature issue an estimated time this will be enabled on GitLab.com.
• Ensure that any breaking changes have been announced following the release post process to ensure GitLab customers are aware.
• Notify #support_gitlab-com and your team channel (more guidance when this is necessary in the dev docs).

Global rollout on production

For visibility, all /chatops commands that target production should be executed in the #production Slack channel and cross-posted (with the command results) to the responsible team's Slack channel (#g_TEAM_NAME).

• Incrementally roll out the feature.
  • If the feature flag in code has an actor, perform actor-based rollout.
    • /chatops run feature set ci_partitioning_analyze_queries_partition_id_check <rollout-percentage> --actors
  • If the feature flag in code does NOT have an actor, perform time-based rollout (random rollout).
    • /chatops run feature set ci_partitioning_analyze_queries_partition_id_check <rollout-percentage> --random
  • Enable the feature globally on production environment.
    • /chatops run feature set ci_partitioning_analyze_queries_partition_id_check true
• Announce on #f_ci_time_decay that Ci::PartitioningAnalyzer has been globally enabled.
• Wait for at least one day for the verification term.

Release the feature

After the feature has been deemed stable, the clean 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 or use the checklist below in this same issue.

• Create a merge request to remove ci_partitioning_analyze_queries_partition_id_check feature flag. Ask for review and merge it.
  • Remove all references to the feature flag from the codebase.
  • Remove the YAML definitions for the feature from the repository.
  • Create a changelog entry.
• Ensure that the cleanup MR has been included in the release package. If the merge request was deployed before the monthly release was tagged, the feature can be officially announced in a release blog post.
  • /chatops run release check <merge-request-url> <milestone>
• Close the feature issue to indicate the feature will be released in the current milestone.
• If not already done, clean up the feature flag from all environments by running these chatops command in #production channel:
  • /chatops run feature delete ci_partitioning_analyze_queries_partition_id_check --dev --staging --staging-ref --production
• Close this rollout issue.

Rollback Steps

• This feature can be disabled by running the following Chatops command:

/chatops run feature set ci_partitioning_analyze_queries_partition_id_check false