Project

General

Profile

Actions

action #33856

closed

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

Added by jorauch about 6 years ago. Updated about 6 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
-
Target version:
Start date:
2018-03-27
Due date:
% Done:

0%

Estimated time:

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 1 (0 open1 closed)

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

Actions
Actions #1

Updated by nicksinger about 6 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).

Actions #2

Updated by szarate about 6 years ago

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

Updated by szarate about 6 years ago

  • Target version set to Ready
Actions #4

Updated by mkittler about 6 years ago

  • Status changed from New to In Progress
Actions #5

Updated by mkittler about 6 years ago

  • Assignee set to mkittler
Actions #6

Updated by szarate about 6 years ago

  • Status changed from In Progress to Resolved

This was already merged

Actions #7

Updated by szarate about 6 years ago

  • Target version changed from Ready to Current Sprint
Actions #8

Updated by szarate about 6 years ago

  • Target version changed from Current Sprint to Done
Actions

Also available in: Atom PDF