Project

General

Profile

action #123490

Updated by okurz over 1 year ago

## Observation 

 We see the following in `/var/log/openqa` on o3: 
 ``` 
 [2023-01-21T22:04:08.897649Z] [error] [bXpoFGyR3PEg] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:    invalid input syntax for type bigint: "root-console-20200501" 
 CONTEXT:    unnamed portal parameter $1 = '...' [for Statement "SELECT me.id, me.dir_id, me.filename, me.last_seen_time, me.last_seen_module_id, me.last_matched_time, me.last_matched_module_id, me.last_updated, me.file_present, me.tags, me.t_created, me.t_updated FROM needles me WHERE ( me.id = ? )" with ParamValues: 1='root-console-20200501'] at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/File.pm line 65 
 ``` 

 ## Acceptance criteria 
 * **AC1:** No new error messages like this in the logs 

 ## Suggestions 
 * Add input validation to route 

 

Back