Skip to content

search feature often times out and results in error 500 #901

@sbourdeauducq

Description

@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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions