| 14 Dec 2023 |
|  @man2dev:fedora.im joined the room. | 08:58:57 |
|  schuelermine changed their profile picture. | 20:49:38 |
| 15 Dec 2023 |
 jackdk | When hydra farms out a build to another machine, which machine is responsible for signing and uploading the built derivation to a cache? I have a hydra machine using secret-key-files for the signing and post-build-hook for the upload, but it doesn't seem to upload derivations built on remote builders. | 04:39:08 |
 tomberek | When hydra is doing it, there are a few options.... either a store variable with ?secret-key set, or via a RunCommand hook. | 04:40:24 |
| tomberek | jackdk: take a look at this parameter: https://github.com/NixOS/nixos-org-configurations/blob/master/delft/hydra.nix#L33 | 04:41:17 |
| jackdk | So instead of using a nix.conf post-build-hook, this entry will tell hydra to copy to the remote server and sign it along the way? | 04:59:37 |
| tomberek | yep | 14:22:30 |
| jackdk | That makes sense. Thanks. | 14:24:55 |
| 16 Dec 2023 |
|  obsqrprjkt joined the room. | 04:51:09 |
| 18 Dec 2023 |
 raitobezarius | just realized that the M2M between jobset and evaluation | 12:53:06 |
| raitobezarius | was | 12:53:07 |
| raitobezarius | public.jobsetevalmembers | 186 GB
| 12:53:09 |
 K900 | Whee | 12:53:29 |
| raitobezarius | * just realized that the M2M between builds and evals | 12:53:33 |
| K900 | Can we at least make a backup of the database and truncate some history | 12:53:39 |
| raitobezarius | it's a stupid (left_id, right_id, bool) table of course | 12:53:43 |
| K900 | I don't know if I want to know the answer to this question | 12:54:03 |
| K900 | But what is the bool for | 12:54:05 |
| raitobezarius | In reply to @k900:0upti.me
Can we at least make a backup of the database and truncate some history you'd break our 2010 urls for performance ??? | 12:54:06 |
| raitobezarius | In reply to @k900:0upti.me
But what is the bool for isnew | 12:54:10 |
| raitobezarius | hydra-nixos-org=# \d jobsetevalmembers
Table "public.jobsetevalmembers"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
eval | integer | | not null |
build | integer | | not null |
isnew | integer | | not null |
| 12:54:17 |
| K900 | Ah yes] | 12:54:24 |
| K900 | * Ah yes | 12:54:25 |
| K900 | A bool | 12:54:26 |
| raitobezarius | oh fuck lol | 12:55:39 |
| raitobezarius | I didn't even realize that | 12:55:42 |
| raitobezarius | it's wasting so many fucking bytes by using an integer | 12:55:51 |
| raitobezarius | let me get the count so I can get a feeling | 12:56:21 |
| raitobezarius | hydra-nixos-org=# select count(*) from jobsetevalmembers;
count
------------
2417504605
(1 row)
| 12:56:39 |
 Sandro | In reply to @raitobezarius:matrix.org
you'd break our 2010 urls for performance ??? Yes 👀 | 13:13:52 |
