action #33856

openQA needle editor causes internal server error at lib/OpenQA/WebAPI/Controller/Step.pm

Added by jorauch about 2 years ago. Updated almost 2 years ago.

Status:ResolvedStart date:27/03/2018
Priority:NormalDue date:
Assignee:mkittler% Done:

0%

Category:-
Target version:Done
Difficulty:
Duration:

Description

When trying to create a needle from this screenshot http://pinky.arch.suse.de/tests/958#step/inkscape/17 I get an internal server error, other screenshots work fine

In the logs I get the following Output:


Mar 27 15:23:58 pinky openqa[2217]: Use of uninitialized value in join or string at
Mar 27 15:23:58 pinky openqa[2217]: /usr/lib/perl5/vendor_perl/5.18.2/SQL/Abstract.pm line 1482 (#1)
Mar 27 15:23:58 pinky openqa[2217]: (W uninitialized) An undefined value was used as if it were already
Mar 27 15:23:58 pinky openqa[2217]: defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
Mar 27 15:23:58 pinky openqa[2217]: To suppress this warning assign a defined value to your variables.
Mar 27 15:23:58 pinky openqa[2217]:
Mar 27 15:23:58 pinky openqa[2217]: To help you figure out what was undefined, perl will try to tell you
Mar 27 15:23:58 pinky openqa[2217]: the name of the variable (if any) that was undefined. In some cases
Mar 27 15:23:58 pinky openqa[2217]: it cannot do this, so it also tells you what operation you used the
Mar 27 15:23:58 pinky openqa[2217]: undefined value in. Note, however, that perl optimizes your program
Mar 27 15:23:58 pinky openqa[2217]: anid the operation displayed in the warning may not necessarily appear
Mar 27 15:23:58 pinky openqa[2217]: literally in your program. For example, "that $foo" is usually
Mar 27 15:23:58 pinky openqa[2217]: optimized into "that " . $foo, and the warning will refer to the
Mar 27 15:23:58 pinky openqa[2217]: concatenation (.) operator, even though there is no . in
Mar 27 15:23:58 pinky openqa[2217]: your program.
Mar 27 15:23:58 pinky openqa[2217]:
Mar 27 15:23:58 pinky openqa[2217]: [error] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: syntax error at or near "AND"
Mar 27 15:23:58 pinky openqa[2217]: LINE 1: ..._created, me.t_updated FROM needles me WHERE ( ( AND t_crea...
Mar 27 15:23:58 pinky openqa[2217]: ^ [for Statement "SELECT me.id, me.dir_id, me.filename, me.first_seen_module_id, me.last_seen_module_id, me.last_matched_module_id, me.file_present, me.tags, me.t_created, me.t_updated FROM needles me WHERE ( ( AND t_created > ? ) ) ORDER BY id DESC LIMIT ?" with ParamValues: 1='2018-03-27T07:19:42', 2='5'] at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/Step.pm line 326


Related issues

Related to openQA Project - action #9906: Show added/updated needles in editor Resolved 14/12/2015

History

#1 Updated by nicksinger about 2 years ago

Seems to happen on every step which has no canidate tags - e.g.: http://pinky.arch.suse.de/tests/958#step/inkscape/8 (no canidates, internal error).

#2 Updated by szarate about 2 years ago

  • Related to action #9906: Show added/updated needles in editor added

#3 Updated by szarate about 2 years ago

  • Target version set to Ready

#4 Updated by mkittler about 2 years ago

  • Status changed from New to In Progress

#5 Updated by mkittler about 2 years ago

  • Assignee set to mkittler

#6 Updated by szarate almost 2 years ago

  • Status changed from In Progress to Resolved

This was already merged

#7 Updated by szarate almost 2 years ago

  • Target version changed from Ready to Current Sprint

#8 Updated by szarate almost 2 years ago

  • Target version changed from Current Sprint to Done

Also available in: Atom PDF