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 about 2 years ago. Updated about 2 years ago.

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

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

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

Actions
Actions #1

Updated by tinita about 2 years ago

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

Updated by tinita about 2 years ago

  • Status changed from New to In Progress
Actions #3

Updated by tinita about 2 years ago

  • Status changed from In Progress to Feedback
Actions #4

Updated by tinita about 2 years ago

Merged

Actions #5

Updated by okurz about 2 years ago

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

Updated by tinita about 2 years ago

  • Status changed from Feedback to Resolved
Actions #7

Updated by jbaier_cz about 1 year ago

  • Copied to action #123490: o3 logreports DBI Exception: DBD::Pg::st execute failed: ERROR: invalid input syntax for type bigint size:M added
Actions

Also available in: Atom PDF