querying for some jobs returns a 500 status code #1529
Description
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
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