querying for some jobs returns a 500 status code
bug
**Describe the bug**
when searching for the string `octo-nvim` on the `https://hydra.nixos.org/search` webpage, hydra returns a 500 internal server error. same behavior happens with `octo-plugin`, `foo-bar` and `foo-bar-baz`, as well as `foobarbaz`, but not with `netcoredbg`
**To Reproduce**
Steps to reproduce the behavior:
go to https://hydra.nixos.org/search?query=octo-nvim (or other similar queries)
**Expected behavior**
The expected behavior is to be able to query for builds with dashes in them like is possible with other queries
**Screenshots**
<img width="1571" height="399" alt="Image" src="https://github.com/user-attachments/assets/48f20720-c227-43c0-90fd-3884dcd036db" />
<img width="1510" height="700" alt="Image" src="https://github.com/user-attachments/assets/fc9ba416-bad6-4fa6-a719-0bc478076e25" />
**Hydra Server:**
Please fill out this data as well as you can, but don't worry if you can't -- just do your best.
- OS and version: [e.g. NixOS 22.05.20211203.ee3794c] - not sure
- Version of Hydra - 0.1.20250913.274027e (as reported on the website)
- Version of Nix Hydra is built against - nix-2.29.2, nix-eval-jobs-2.29.0 (as reported on the website)
- Version of the Nix daemon - not sure
**Error message**
```
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.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 LEFT JOIN buildoutputs buildoutputs ON buildoutputs.build = me.id WHERE ( buildoutputs.path ILIKE ? ) ORDER BY id desc LIMIT ?" with ParamValues: 1='%foo-bar%', 2='10'] at /nix/store/869js2rgzz9l8szbmsj66ywqd99hbw1b-hydra-0.1.20250913.274027e/libexec/hydra/lib/Hydra/Controller/Root.pm line 545
```
关闭于 2026-01-04 9 条评论