| 1 Jun 2021 |
 yorickvp | so I can do <<include externalconfig.rc>> | 10:49:14 |
| yorickvp | thanks for the rubber ducking :) | 10:49:27 |
 @grahamc:nixos.org | https://github.com/NixOS/hydra/pull/969 | 15:27:45 |
| @grahamc:nixos.org |
This change is primarily focused on improving the jobset overview query. This change reduces its best case from about 5 seconds to less than one second.
| 15:28:09 |
 cransom | heh, i see https://twitter.com/DeterminateSys/status/1399742076737273856 just after i pushed the button for rds to update from 9.6 to 12 on the pg db. | 15:29:47 |
| @grahamc:nixos.org | womp womp :P | 15:32:16 |
| @grahamc:nixos.org | does RDS have JIT support? | 15:32:50 |
| cransom | mentioned as available to turn on in docs (not sure if it's default) | 15:34:13 |
| cransom | not enabled in the default parameter group, but settable. | 15:34:58 |
| @grahamc:nixos.org | cool | 15:36:48 |
| @grahamc:nixos.org | I think JIT is disabled by default for postgres overall | 15:36:58 |
| @grahamc:nixos.org | but it seems to do some good stuff | 15:37:06 |
 ajs124 | https://github.com/NixOS/nixpkgs/pull/124804 | 15:37:07 |
| @grahamc:nixos.org | we turned on JIt support for h.n.o | 15:37:18 |
| cransom | my main feature was to remove this warning of 'please update your 9.6 instance to something else by jan 2022 or we do it for you', and i should do it anyway | 15:37:58 |
| @grahamc:nixos.org | ah | 15:43:02 |
| @grahamc:nixos.org | casey ©: could you run that query anyway? it'll give some useful info anyway | 15:43:10 |
| @grahamc:nixos.org | this PR is ready to go I think if anyone wants to review it: https://github.com/NixOS/hydra/pull/969 | 16:00:17 |
| cransom changed their display name from casey © to cransom. | 16:08:17 |
| 2 Jun 2021 |
|  Jez (he/him) joined the room. | 07:23:22 |
| Jez (he/him) | I have a really n00bish question: is hydra a sensible solution for something really small scale; in my case building and deploying a website with an SSG like Hugo? | 07:25:08 |
 Dandellion | I've used it for that | 11:46:48 |
| 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 |
