Project

General

Profile

Actions

action #107926

closed

Broken SQL query in `lib/OpenQA/WebAPI/Plugin/Helpers.pm line 403`

Added by mkittler about 2 years ago. Updated about 2 years ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
Regressions/Crashes
Target version:
Start date:
2022-03-07
Due date:
% Done:

0%

Estimated time:

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.

Actions #1

Updated by okurz about 2 years ago

  • Priority changed from Normal to High
Actions #2

Updated by mkittler about 2 years ago

  • Assignee set to mkittler
  • Priority changed from High to Normal
Actions #3

Updated by mkittler about 2 years ago

  • Status changed from New to Feedback
Actions #4

Updated by mkittler about 2 years ago

  • Priority changed from Normal to High
Actions #5

Updated by mkittler about 2 years ago

  • Status changed from Feedback to Resolved
Actions

Also available in: Atom PDF