From 26a440be76e17df608407700302e12599d7dd681 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Wed, 22 Dec 2021 11:41:27 +0000 Subject: Fix unprocessed_builds_with_derived_priorities A couple of the queries were wrong, this fixes it. --- guix-build-coordinator/datastore/sqlite.scm | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'guix-build-coordinator') diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm index bc349d9..7cc66fe 100644 --- a/guix-build-coordinator/datastore/sqlite.scm +++ b/guix-build-coordinator/datastore/sqlite.scm @@ -3662,17 +3662,17 @@ UNION FROM relevant_builds INNER JOIN builds AS relevant_builds_full ON relevant_builds.id = relevant_builds_full.id + INNER JOIN derivation_inputs + ON relevant_builds_full.derivation_id = derivation_inputs.derivation_id INNER JOIN derivation_outputs - ON relevant_builds_full.derivation_id = derivation_outputs.derivation_id + ON derivation_inputs.derivation_output_id = derivation_outputs.id INNER JOIN unbuilt_outputs ON unbuilt_outputs.output_id = derivation_outputs.output_id INNER JOIN derivation_outputs AS all_derivation_outputs - ON all_derivation_outputs.output_id = derivation_outputs.output_id - INNER JOIN derivation_inputs - ON derivation_inputs.derivation_output_id = all_derivation_outputs.id + ON all_derivation_outputs.output_id = unbuilt_outputs.output_id INNER JOIN builds ON builds.processed = 0 - AND builds.derivation_id = derivation_inputs.derivation_id + AND builds.derivation_id = all_derivation_outputs.derivation_id ) SELECT build_id FROM relevant_builds -- cgit v1.2.3