We received a report from one of our customers about issues with their pipeline executions in our Prod-2 cluster. Details about the incident are below.
We deleted the expired Delegate tasks from the database to unblock the customers.
A total of seven customers were impacted because of this incident. We will take 60 mins of partial downtime for our CD, CDNG, STO and CIE - Self-Hosted Runners.
We identified the problem with a background job that periodically cleans up expired tasks. The background job hit a latent bug where it was iterating over the same set of tasks and could not delete them. The issue surfaced due to increased database query latency due to a scheduled database upgrade.
We mitigated the incident by manually cleaning up the expired tasks from the database.