aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2019-07-19 20:12:49 +0100
committerChristopher Baines <mail@cbaines.net>2019-07-19 20:25:53 +0100
commit6dd52f08edbe7525c26b86a0d1a414b96cf2288d (patch)
treee97b9f4512db8f3f5e08b995f019dc25c62ba597
parent71607eff669345eca2a6edfd2087e79d01df6edc (diff)
downloaddata-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.scm7
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)))