Skip to content

Backfill zentao_tracker_data sharding key

What does this MR do and why?

This MR backfills old records of zentao_tracker_data table that do not have sharding key set (project_id/group_id/organization_id). This is required in order for us to set multiple column not null constraint so that we can properly shard this table as part of Cells architecture.

Setting of sharding key for new records has been done in !189933 (merged) and now it's turn to backfill existing records. After that - set multiple column not null constraint (in the future MR).

We have (on .com) 331 records to update in zentao_tracker_data

Query plan

image33

References

#545940 (closed)

Screenshots or screen recordings

Before After

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by George Koltsov

Merge request reports

Loading