Skip to content

Delete invalid ci_runner_machines records

In order to validate the not-null constraint on the sharding_key_id column, we will need to remove the invalid records from orphaned runners (group/project runners without associated group/project). Related to #498019 (closed)

There are currently 4K records in this situation, the vast majority still in contact with the GitLab instance:

image

image

As demonstrated in #498019 (comment 2171685064), the runners haven't executed jobs since at least end of September.

The ci_runner_machines are created in the following endpoints:

  • DELETE /runners
  • POST /runners/verify
  • POST /runners/reset_authentication_token
  • POST /jobs/request
  • PUT /jobs/:id
  • PATCH /jobs/:id/trace
Edited by Pedro Pombeiro - OOO from Oct 13-24