Skip to content

Replace runners token indices in projects table with unique versions

Having ensured that no duplicates remain in the projects table with !81991 (merged), we should now add a migration to create unique indices, drop the existing non-unique ones (index_projects_on_runners_token and index_projects_on_runners_token_encrypted), as well as the temporary indices created in !81991 (merged) (tmp_index_projects_on_id_and_runners_token and tmp_index_projects_on_id_and_runners_token_encrypted).

The following discussion from !81991 (merged) should be addressed:

  • @ahegyi started a discussion:

    We cannot remove the index because the BG migration jobs depend on it. We need to create a follow-up issue for the index removal.