Removing ci_piplines uses a WHERE lock_version that should not be used

Currently removing ci_pipelines in certain cases seems to produce queries such as:

DELETE FROM "ci_pipelines" WHERE "ci_pipelines"."id" = X AND "ci_pipelines"."lock_version" IS NULL
DELETE FROM "ci_pipelines" WHERE "ci_pipelines"."id" = X AND "ci_pipelines"."lock_version" = 5

The WHERE lock_version ... bit should not be used as there's no point in locking against concurrent removals of the same row.

Edited Sep 24, 2025 by 🤖 GitLab Bot 🤖
Assignee Loading
Time tracking Loading