| 31 Aug 2024 |
 hacker1024 | * I am getting a lot of these messages from hydra-server and hydra-send-stats after upgrading nixos-unstable. Is there a manual step that needs to be done? I did not change my system stateVersion.
WARNING: database "hydra" has a collation version mismatch
DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.39.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE hydra REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
| 11:47:36 |
| hacker1024 | * I am getting a lot of these messages from hydra-server and hydra-send-stats after upgrading nixos-unstable. Is there a manual step that needs to be done? I did not change my system stateVersion.
WARNING: database "hydra" has a collation version mismatch
DETAIL: The database was created using collation version 2.38, but the operating system provides version 2.39.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE hydra REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
| 11:47:42 |
 K900 | It literally tells you what to do | 11:49:50 |
| hacker1024 | I am not familiar with SQL or SQL servers in general. Am I supposed to use some tool to open a PostgeSQL console? | 11:51:19 |
| hacker1024 | And I'm not sure what are keywords or placeholders in the given command | 11:51:53 |
| hacker1024 | Or if Hydra needs to be stopped during this process | 11:52:21 |
 Rick (Mindavi) | Hmm, maybe PostgreSQL updated? Normally this shouldn't happen, and nothing in the hydra schema changed | 13:50:17 |
| 2 Sep 2024 |
 das_j | It happens when the glibc version of postgres changes | 06:48:10 |
|  stigo joined the room. | 10:43:54 |
| 3 Sep 2024 |
 Sandro | sudo -u postgres psql and run the command | 12:14:17 |
| Rick (Mindavi) | Maybe something for the wiki | 17:48:25 |
|  noisersup joined the room. | 17:58:00 |
| Sandro | that's pretty much standard postgres knowledge | 18:25:42 |
 Alyssa Ross | not necessarily standard Hydra knowledge though | 18:26:29 |
| Rick (Mindavi) | I don't really feel qualified as a database admin but generally it goes fine for me, until I need to update major PostgreSQL databases | 19:41:54 |
| Rick (Mindavi) | * I don't really feel qualified as a database admin but generally it goes fine for me, until I need to update major PostgreSQL versions | 19:42:12 |
| 5 Sep 2024 |
 dramforever | til to even use the postgres user, i've been using hydra | 02:06:43 |
| dramforever | unrelatedly | 02:24:20 |
| dramforever | how do the hydra people, so to speak, feel about adding additional meta attributes to the db into the builds table? | 02:24:44 |
| dramforever | basically i'm trying to see if i can (we can?) work around this https://github.com/NixOS/nix/issues/2742 in hydra by adding like meta attributes | 02:27:33 |
| dramforever | so i'm imagining something like meta.requiredSystemFeatures that adds the features strictly when scheduling in hydra | 02:31:34 |
| 6 Sep 2024 |
 vcunat | Hydra already has issues with the case where you change a (fixed-output) derivation while keeping the output hash. | 10:20:41 |
| vcunat | It will reuse the old build and with it the old derivation. | 10:21:18 |
| vcunat | Even if it was failed. | 10:22:08 |
| 9 Sep 2024 |
|  @meep_bleep:matrix.org joined the room. | 16:00:28 |
| 11 Sep 2024 |
|  nyanbinary left the room. | 15:29:02 |
| 16 Sep 2024 |
|  silentlurker joined the room. | 20:00:40 |
| 17 Sep 2024 |
|  Tom (deprecated) joined the room. | 21:10:15 |
| 18 Sep 2024 |
 cleverca22 | John Ericson: https://github.com/NixOS/nix/commit/bc085022494fe90f733aef0832b6d7dcc34709cf has the fix to hydra been written yet? i updated my hydra recently, and now the cache is down | 03:42:13 |
 John Ericson | In reply to @cleverca22:matrix.org
John Ericson: https://github.com/NixOS/nix/commit/bc085022494fe90f733aef0832b6d7dcc34709cf has the fix to hydra been written yet? i updated my hydra recently, and now the cache is down which fix / which problem? | 03:58:20 |
