Project

General

Profile

Actions

action #29481

open

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

Added by okurz over 6 years ago. Updated 7 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Regressions/Crashes
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:

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 2 (1 open1 closed)

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

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

Actions
Actions #1

Updated by okurz over 6 years ago

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

Updated by okurz almost 6 years ago

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

Updated by okurz about 4 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

Actions #5

Updated by tinita 7 months ago

  • Status changed from Resolved to Workable

We still have this ticket referenced here: https://github.com/os-autoinst/openqa-logwarn/blob/master/logwarn_openqa#L59C8-L59C50
I say we shouldn't resolve tickets when we ignore DBI errors.

Actions #6

Updated by okurz 7 months ago

  • Target version set to future

Agreed.

Actions #7

Updated by tinita 7 months ago

  • Status changed from Workable to New
Actions

Also available in: Atom PDF