| 2 Jun 2021 |
 cransom | hydra-evaluator[7343]: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: index "indexbuildoutputspath" has wro
ng hash version
hydra-evaluator[7343]: HINT: Please REINDEX it. [for Statement "INSERT INTO buildoutputs ( build, name, path) VALUES ( ?, ?, ? )" with ParamValues: 1='377725', 2='out', 3='/nix/store/z5paak2hhq96q5aq9568k6a0i18590hy-prod-0-disk-image'] at /nix/store/wp79qdry1zd26ish3bddbz95c2zwca0q-hydra-2021-03-10/bin/.hydra-eval-jobset-wrapped line 477
interesting. right after the 9->12 postgres update. reindex did indeed fix it.
| 15:26:23 |
 @grahamc:nixos.org | interesting | 15:33:31 |
| @grahamc:nixos.org |
grahamc (he/him)
vacuum has been failing on the builds table: May 15 12:46:26 haumea postgres[1630]: user=,db=,app=,client= ERROR: failed to re-find parent key in index "indexbuildsonjobiscurrent" for deletion target page 138878. I'm going to recreate this index, I've confirmed this is the only unhappy index. it should take about 4 minutes.
| 15:34:28 |
| @grahamc:nixos.org | ^ this started happening around our upgrade to v12 | 15:34:40 |
|  risson left the room. | 16:58:07 |
|  lewo set a profile picture. | 18:16:54 |
| lewo changed their profile picture. | 18:17:31 |
| lewo changed their profile picture. | 18:42:11 |
|  Jez (he/him) left the room. | 20:29:35 |
| 3 Jun 2021 |
| @grahamc:nixos.org | https://twitter.com/grhmc/status/1400245103373996036 | 00:19:31 |
 das_j | grahamc (he/him) since I don't have twitter, I'll have to respond here. No statsd anymore would be my personal preference | 09:31:29 |
 Sandro | FYI the six people on Twitter are for statsd | 09:32:49 |
| @grahamc:nixos.org | I'm pretty sure they're only +1 on statsd b/c they can't imagine ever investing in a perl codebase | 12:47:03 |
 ajs124 | maybe they're just a big fan of statsd | 12:57:28 |
| das_j | Yeah, investing in a perl codebase is unarguably an idea that results in mixed feelings | 13:12:31 |
| @grahamc:nixos.org | for sure | 13:26:23 |
| @grahamc:nixos.org | it certainly isn't my idea of career development lol | 13:26:43 |
| Sandro | do you want to maintain it or use something already there? | 14:12:35 |
| cransom | imo, i try not to stack bandaids. if you have to go through code change anyway and the end result is prometheus, going through an intermediate statsd step is cumbersome. regardless of if it's perl or not. | 15:50:37 |
| @grahamc:nixos.org | I agree cransom | 17:29:48 |
| @grahamc:nixos.org | I don't suppose you would be interested in making a Prometheus version of that Plack middleware? | 17:30:12 |
| @grahamc:nixos.org | it isn't actually so complicated to write, but I'd want to write tests for it too, and I think it'd take more time than I can really commit :( | 17:30:31 |
| 4 Jun 2021 |
 andi- | Do the hydra tests have any concept of test fixtures? Just looking at writing a test around a jobset and so far the tests look like they depend on each other (being executed in order). Usually I'd just setup a jobset and discard of it after my test again. | 14:28:49 |
| andi- | cole-h: ^ you wrote most of the code there :D | 14:29:02 |
| @grahamc:nixos.org | every .t file runs its own postgres database | 14:31:39 |
| @grahamc:nixos.org | * every .t file runs its own postgres server | 14:31:47 |
| @grahamc:nixos.org | and hydra-init runs then you have to create everything from scratch from there | 14:32:00 |
| andi- | Ah nice, I'll just add another file then. | 14:34:08 |
| 6 Jun 2021 |
|  Valodim joined the room. | 11:01:00 |
| Valodim | https://hydra.nixos.org/search?query=aaaa it seems that just about any search term that isn't very short will run into query timeouts. also, "aaaa" finds results with four as anywhere in the Job name. is the hydra search doing an unoptimized fuzzy search? | 11:13:30 |
