diff options
-rw-r--r-- | guix-data-service/model/git-repository.scm | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/guix-data-service/model/git-repository.scm b/guix-data-service/model/git-repository.scm index 305b3ec..463222c 100644 --- a/guix-data-service/model/git-repository.scm +++ b/guix-data-service/model/git-repository.scm @@ -46,7 +46,10 @@ " SELECT NULL AS id, load_new_guix_revision_jobs.id AS job_id, commit, source FROM load_new_guix_revision_jobs -WHERE git_repository_id = $1 AND succeeded_at IS NULL +WHERE git_repository_id = $1 AND succeeded_at IS NULL AND NOT EXISTS ( + SELECT 1 FROM load_new_guix_revision_job_events + WHERE event = 'failure' AND job_id = load_new_guix_revision_jobs.id +) UNION SELECT id, NULL, commit, NULL FROM guix_revisions |