[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
03/06: Only query recent pending builds
From: |
Christopher Baines |
Subject: |
03/06: Only query recent pending builds |
Date: |
Sun, 1 Nov 2020 17:53:32 -0500 (EST) |
cbaines pushed a commit to branch master
in repository data-service.
commit adc1d01525b0f96c3c9ada1a33654beaa971aafd
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Sun Nov 1 21:53:19 2020 +0000
Only query recent pending builds
To avoid old pending builds that never leave the scheduled/started state.
---
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 41473fc..68f4a6b 100644
--- a/guix-data-service/builds.scm
+++ b/guix-data-service/builds.scm
@@ -501,7 +501,8 @@ LEFT JOIN latest_build_status
WHERE builds.build_server_id = $1 AND
latest_build_status.status IN (
'scheduled', 'started'
- )
+ ) AND
+ latest_build_status.timestamp > (current_date - interval '28' day)
ORDER BY latest_build_status.status DESC, -- 'started' first
latest_build_status.timestamp ASC
LIMIT 10000")
- branch master updated (e394d1d -> 375a6a3), Christopher Baines, 2020/11/01
- 02/06: Improve verbose output for fetching build information, Christopher Baines, 2020/11/01
- 01/06: Fix call-with-time-logging in (guix-data-service utils), Christopher Baines, 2020/11/01
- 04/06: Support limiting fetching pending builds to specific revisions, Christopher Baines, 2020/11/01
- 05/06: Allow only fetching builds for a specific system, Christopher Baines, 2020/11/01
- 03/06: Only query recent pending builds,
Christopher Baines <=
- 06/06: Support not querying pending builds, Christopher Baines, 2020/11/01