Actions
action #107926
closedBroken SQL query in `lib/OpenQA/WebAPI/Plugin/Helpers.pm line 403`
Description
Today we've got the following mail from logwarn:
[2022-03-07T05:13:37.291824Z] [error] [RZKS8l14OQvS] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer: "80):"
CONTEXT: unnamed portal parameter $1 = '...' [for Statement "SELECT me.id, me.name, me.parent_id, me.size_limit_gb, me.exclusively_kept_asset_size, me.keep_logs_in_days, me.keep_important_logs_in_days, me.keep_results_in_days, me.keep_important_results_in_days, me.default_priority, me.sort_order, me.description, me.template, me.build_version_sort, me.carry_over_bugrefs, me.t_created, me.t_updated FROM job_groups me WHERE ( id = ? )" with ParamValues: 1='80):'] at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Plugin/Helpers.pm line 403
The line likely corresponds to the DBIx query @groups = $schema->resultset('JobGroups')->search(\@search_terms)->all;
in the mentioned file.
Updated by mkittler over 2 years ago
- Assignee set to mkittler
- Priority changed from High to Normal
Updated by mkittler over 2 years ago
- Status changed from New to Feedback
Actions