Project

General

Profile

action #29481

[openqa-monitoring] DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "127),"

Added by okurz over 5 years ago. Updated about 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Concrete Bugs
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Difficulty:

Description

observation

[Fri Dec 15 17:27:25 2017] [23481:error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer: "127)," [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.build_version_sort, me.t_created, me.t_updated FROM job_groups me WHERE ( id = ? )" with ParamValues: 1='127),'] at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/Test.pm line 501

suggestion

wrong api use should not cause a database exception but be handled on a higher level or the error silently ignored


Related issues

Copied from openQA Project - action #18048: [tools][openqa-monitoring] AMQP connection closedResolved2017-03-27

Copied to openQA Project - action #40007: [openqa-monitoring] [warn] A message received from unknown worker connectionNew2018-08-20

History

#1 Updated by okurz over 5 years ago

  • Copied from action #18048: [tools][openqa-monitoring] AMQP connection closed added

#3 Updated by okurz almost 5 years ago

  • Copied to action #40007: [openqa-monitoring] [warn] A message received from unknown worker connection added

#4 Updated by okurz about 3 years ago

  • Status changed from New to Resolved

Might be fixed by our recent better parameter validations. Other than this we probably do not need to care that much

Also available in: Atom PDF