Project

General

Profile

Actions

action #108533

closed

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

Added by tinita almost 3 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
High
Assignee:
Category:
-
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 2 (0 open2 closed)

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

Actions
Copied to openQA Infrastructure (public) - action #123490: o3 logreports DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type bigint size:MResolvedkraih2023-01-23

Actions
Actions

Also available in: Atom PDF