Project

General

Profile

action #108533

o3 logreports DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type integer

Added by tinita 4 months ago. Updated 3 months ago.

Status:
Resolved
Priority:
High
Assignee:
Target version:
Start date:
Due date:
2022-03-31
% Done:

0%

Estimated time:

Description

Observation

We see the following in /var/log/openqa on o3:

[2022-03-17T11:18:54.319227Z] [error] [0JFc1Shf3ijT] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception:
DBD::Pg::st execute failed: ERROR:  invalid input syntax for type integer: "hdd"
CONTEXT:  unnamed portal parameter $1 = '...' [for Statement "SELECT asset.name, asset.type FROM jobs me LEFT JOIN
jobs_assets jobs_assets ON jobs_assets.job_id = me.id LEFT JOIN assets asset ON asset.id = jobs_assets.asset_id WHERE
( ( asset.id = ? AND me.id = ? ) ) LIMIT ?" with ParamValues: 1='hdd', 2='2246653', 3='1'] at
/usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/File.pm line 139

Produced by this request: https://openqa.opensuse.org/tests/2246653/asset/hdd/


Related issues

Copied from openQA Infrastructure - action #105828: 4-7 logreport emails a day cause alert fatigue size:MResolved2022-02-032022-02-17

History

#1 Updated by tinita 4 months ago

  • Copied from action #105828: 4-7 logreport emails a day cause alert fatigue size:M added

#2 Updated by tinita 4 months ago

  • Status changed from New to In Progress

#3 Updated by tinita 4 months ago

  • Status changed from In Progress to Feedback

#4 Updated by tinita 4 months ago

Merged

#5 Updated by okurz 4 months ago

  • Due date changed from 2022-02-17 to 2022-03-31
  • Start date deleted (2022-02-03)

#6 Updated by tinita 3 months ago

  • Status changed from Feedback to Resolved

Also available in: Atom PDF