Sometimes it takes more time to refute a gcc bug than confirm it. This week I spent most time on https://gcc.gnu.org/PR114872 where sagemathSIGSEGVed on some simple inputs.
@sandro Yeah, VACUUM usually helps a lot. I intentionally kept the file fragmented as it's the most fragmented file on my system :)
Generally I'm slightly worried to run direct sqlite commands against databases that are actively used by nix-daemon. Would be nice if nix-daemon provided a direct call for it: https://github.com/NixOS/nix/issues/5319
Today's gcc bug https://gcc.gnu.org/PR111051 is a case where gcc stopped recognizing some avx2 primitives on avx512 code (all on highway-1.0.6 code again):
Every 6 months nixpkgs enters "Zero Hydra Failures" development phase when the main focus is to fix most known build or test failures.
It's a good opportunity to get your first contribution as fixing the package is usually straightforward: it used to work and your goal is to make it build again (or schedule it for deletion).
I usually try to fix at least one package during ZHF.