cbaines pushed a commit to branch master
in repository data-service.
commit 63fc1917f89453c1072cb6972d4c512b9fc1391b
Author: Christopher Baines <[email protected]>
AuthorDate: Wed Oct 21 20:49:58 2020 +0100
Sort the pending builds by timestamp
So that builds that have been pending for a longer time are fetched first.
---
guix-data-service/builds.scm | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/guix-data-service/builds.scm b/guix-data-service/builds.scm
index 4afd362..4f2e5ed 100644
--- a/guix-data-service/builds.scm
+++ b/guix-data-service/builds.scm
@@ -493,7 +493,8 @@ WHERE builds.build_server_id = $1 AND
latest_build_status.status IN (
'scheduled', 'started'
)
-ORDER BY latest_build_status.status DESC -- 'started' first
+ORDER BY latest_build_status.status DESC, -- 'started' first
+ latest_build_status.timestamp ASC
LIMIT 10000")
(map
