Add and backfill sharding_key_id column to ci_runners
In order to have the automated trigger in the partitioned table copy valid data into new records, we need the source table to already be populated with the sharding key.
Context: !166308 (comment 2124543673)
Proposed plan
-
Add and backfill the sharding_key_id
column with a BBM in %17.5 -
Update the app to populate sharding_key_id
for new runners -
Finalize BBM in the milestone (%17.6) following the next required stop (%17.5) -
Remove before_validation :ensure_sharding_key_id, on: :update
inapp/models/ci/runner.rb
.
Edited by Pedro Pombeiro