[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
05/07: Spawn specific PostgreSQL connections for the blocked_builds upda
From: |
Christopher Baines |
Subject: |
05/07: Spawn specific PostgreSQL connections for the blocked_builds updates |
Date: |
Sat, 12 Nov 2022 05:59:13 -0500 (EST) |
cbaines pushed a commit to branch master
in repository data-service.
commit a34bf4defcca080169770eda7bf26856c02ab940
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Sat Nov 12 10:46:46 2022 +0000
Spawn specific PostgreSQL connections for the blocked_builds updates
So that the queries don't get cancelled by the statement timeout.
---
guix-data-service/web/build-server/controller.scm | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/guix-data-service/web/build-server/controller.scm
b/guix-data-service/web/build-server/controller.scm
index 7c2ace6..750fb67 100644
--- a/guix-data-service/web/build-server/controller.scm
+++ b/guix-data-service/web/build-server/controller.scm
@@ -141,7 +141,8 @@
(spawn-fiber
(lambda ()
(parallel-via-thread-pool-channel
- (with-thread-postgresql-connection
+ (with-postgresql-connection
+ "build-event-handler-conn"
(lambda (conn)
(handler conn ids)))))))))
- branch master updated (4101c6b -> 7731c6f), Christopher Baines, 2022/11/12
- 01/07: Rework insert-blocked-builds to make it more efficient, Christopher Baines, 2022/11/12
- 03/07: Add extended statistics on package_derivations, Christopher Baines, 2022/11/12
- 06/07: Use latest_build_status rather than build_status, Christopher Baines, 2022/11/12
- 07/07: Tweak backfilling the blocked builds, Christopher Baines, 2022/11/12
- 02/07: Have insert-blocked-builds cache when the partitions exist, Christopher Baines, 2022/11/12
- 05/07: Spawn specific PostgreSQL connections for the blocked_builds updates,
Christopher Baines <=
- 04/07: Add index on derivation_outputs id and derivation_id fields, Christopher Baines, 2022/11/12