diff options
| author | Christopher Baines <mail@cbaines.net> | 2019-07-19 20:12:49 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2019-07-19 20:25:53 +0100 |
| commit | 6dd52f08edbe7525c26b86a0d1a414b96cf2288d (patch) | |
| tree | e97b9f4512db8f3f5e08b995f019dc25c62ba597 | |
| parent | 71607eff669345eca2a6edfd2087e79d01df6edc (diff) | |
| download | data-service-6dd52f08edbe7525c26b86a0d1a414b96cf2288d.tar data-service-6dd52f08edbe7525c26b86a0d1a414b96cf2288d.tar.gz | |
Remove restrictions in select-job-for-update
This allows running jobs manually that have failed.
| -rw-r--r-- | guix-data-service/jobs/load-new-guix-revision.scm | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/guix-data-service/jobs/load-new-guix-revision.scm b/guix-data-service/jobs/load-new-guix-revision.scm index c0360bb..d1a5fb7 100644 --- a/guix-data-service/jobs/load-new-guix-revision.scm +++ b/guix-data-service/jobs/load-new-guix-revision.scm @@ -692,12 +692,7 @@ ORDER BY load_new_guix_revision_jobs.id DESC") (string-append "SELECT id, commit, source, git_repository_id " "FROM load_new_guix_revision_jobs " - "WHERE id = $1 AND succeeded_at IS NULL AND NOT EXISTS (" - "SELECT 1 " - "FROM load_new_guix_revision_job_events " - ;; Skip jobs that have failed, to avoid trying them over and over again - "WHERE job_id = load_new_guix_revision_jobs.id AND event = 'failure'" - ") ORDER BY id DESC " + "WHERE id = $1 AND succeeded_at IS NULL " "FOR NO KEY UPDATE SKIP LOCKED") (list id))) |