Consistent 500 from search on hydra.nixos.org

samuela · September 21, 2021, 6:46am

I’m trying to access https://hydra.nixos.org/search?query=truecrack-cuda but getting a 500 Internal Server Error response every single time…

r-burns · September 21, 2021, 7:37am

Looks like this might be the same issue?

github.com/NixOS/hydra

search feature often times out and results in error 500

opened 04:20AM - 28 Mar 21 UTC

sbourdeauducq

e.g. https://hydra.nixos.org/search?query=sd_image_raspberrypi4 500 Internal …Server Error DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: canceling statement due to statement timeout [for Statement "SELECT me.id, me.finished, me.timestamp, me.project, me.jobset, me.jobset_id, me.job, me.nixname, me.description, me.drvpath, me.system, me.license, me.homepage, me.maintainers, me.maxsilent, me.timeout, me.ischannel, me.iscurrent, me.priority, me.globalpriority, me.starttime, me.stoptime, me.iscachedbuild, me.buildstatus, me.size, me.closuresize, me.releasename, me.keep, me.notificationpendingsince FROM builds me JOIN projects project ON project.name = me.project JOIN jobsets jobset ON jobset.id = me.jobset_id WHERE ( ( iscurrent = ? AND job ILIKE ? AND jobset.hidden = ? AND project.hidden = ? ) ) ORDER BY project, jobset, job LIMIT ?" with ParamValues: 1='1', 2='%sd_image_raspberrypi4%', 3='0', 4='0', 5='11'] at /nix/store/ym9kzsdswmjlwrmj140jrq29lpgc5jjw-hydra-0.1.20210202.bc12fe1/libexec/hydra/lib/Hydra/Controller/Root.pm line 470