| 13 Jan 2022 |
 ajs124 | it's not https://github.com/NixOS/hydra/issues/1081 though, right? | 18:33:50 |
| ajs124 | because this project isn't declarative | 18:33:58 |
| ajs124 | looks like the same query, tbh | 18:34:18 |
 cole-h | Oh, I guess I did see it, but only when playing with declarative projects. I'll amend the title; pretty sure it's the same issue (or at least is related). | 18:37:10 |
| ajs124 | manually deleting from buildmetrics first seems to work | 18:40:23 |
|  NixOS Moderation Bot unbanned  David Arnold (blaggacao). | 18:43:54 |
| cole-h | Maybe because the BuildMetrics table doesn't cascade deletes from the project / jobset? https://github.com/NixOS/hydra/blob/769f56f793f5cc3ec21e2c00214c0ec9ad3dfc2c/src/sql/hydra.sql#L371-L372 | 19:31:53 |
| 14 Jan 2022 |
|  Rev. CornWallace III (novus ordo seclorum) changed their display name from Rev. CornWallace III (novus ordo seclorum) to coilWinder. | 04:39:29 |
| Rev. CornWallace III (novus ordo seclorum) changed their display name from coilWinder to CoilWinder (novus ordo seclorum). | 04:41:44 |
 @grahamc:nixos.org | https://github.com/NixOS/hydra/pull/1105#issuecomment-1013127680 this is probably fine, right? (genuine, not a snarky question) | 14:18:25 |
 das_j | In reply to @grahamc:nixos.org
https://github.com/NixOS/hydra/pull/1105#issuecomment-1013127680 this is probably fine, right? (genuine, not a snarky question) Seems fine to me | 14:19:23 |
| @grahamc:nixos.org | thanks! | 14:31:38 |
| @grahamc:nixos.org | despite knowing there is a bug in this code, and that I should refactor and write tests anyway, my heart is not in it: https://github.com/DeterminateSystems/hydra/pull/6/files | 14:31:58 |
| @grahamc:nixos.org | I found a URL on hydra.nixos.org that causes 750Mb/s of data transfer from the database to the webserver, sustained, for several minutes: https://monitoring.nixos.org/grafana/d/rYdddlPWk/node-exporter-full?orgId=1&refresh=30s&from=now-15m&to=now&var-DS_PROMETHEUS=default&var-job=node&var-node=haumea%3A9100&var-diskdevices=%5Ba-z%5D%2B%7Cnvme%5B0-9%5D%2Bn%5B0-9%5D%2B | 17:40:23 |
| @grahamc:nixos.org | pretty "cool" | 17:40:29 |
| @grahamc:nixos.org | and memory is getting squeezed on the receiver: https://monitoring.nixos.org/grafana/d/rYdddlPWk/node-exporter-full?orgId=1&refresh=30s&from=now-5m&to=now&var-DS_PROMETHEUS=default&var-job=node&var-node=ceres:9100&var-diskdevices=%5Ba-z%5D%2B%7Cnvme%5B0-9%5D%2Bn%5B0-9%5D%2B | 17:41:16 |
 cransom | query that that doesn't paginate or just throws back most of the database, eh? | 17:42:06 |
| @grahamc:nixos.org | yes-and! | 17:43:27 |
| cransom | hydra master of improv. | 17:43:56 |
| ajs124 | I deleted a full nixpkgs eval jobset from my hydra yesterday and the query took >1h. Maybe my postgres isn't configured properly 🤷 | 17:44:22 |
| @grahamc:nixos.org | hydra.nixos.org disabled deleting jobsets because of that | 17:45:28 |
| @grahamc:nixos.org | I think cleaning up some FK's and indexes will make that much faster | 17:45:39 |
| @grahamc:nixos.org | on that note, https://github.com/NixOS/hydra/pull/1109 brings us closer to doing that | 17:56:11 |
| @grahamc:nixos.org | TIL you can have github trigger evaluations on push | 19:45:25 |
| @grahamc:nixos.org | and it works on flakes: https://github.com/NixOS/hydra/pull/1110/commits/ee529c6c33b37ef76e33db685fe7fcc32312c187 | 19:46:40 |
| 15 Jan 2022 |
| @grahamc:nixos.org | In reply to @andreas.schraegle:helsinki-systems.de
I tried to delete a project right now and this happened: https://github.com/NixOS/hydra/pull/1114 | 01:39:21 |
| @grahamc:nixos.org | and this PR is getting smaller: https://github.com/NixOS/hydra/pull/1093 | 01:49:00 |
| @grahamc:nixos.org | chipping away at it, making PRs for each little bit | 01:49:07 |
| 17 Jan 2022 |
| @grahamc:nixos.org | merged & deployed and it seems to be going fine :) whose next? 😉 | 16:00:20 |
| 18 Jan 2022 |
| @grahamc:nixos.org | anyone seen errors like this one before?
| 20:21:19 |
