QA » openQA Project

observation¶

many errors reported on openqa.suse.de:

Feb 26 14:14:29 openqa openqa[3421]: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/API/V1.pm line 85
Feb 26 14:14:30 openqa openqa[3421]: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row.  SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/openqa/script/../lib/OpenQA/WebAPI/Controller/API/V1.pm line 85
...

steps to reproduce¶

• login to openqa.suse.de
• journalctl -f -u openqa-webui
• observe error

further notes¶

also other warnings

Feb 26 14:15:30 openqa openqa[3421]: Use of uninitialized value $md5 in substr at
Feb 26 14:15:30 openqa openqa[3421]: /usr/share/openqa/script/../lib/OpenQA/Utils.pm line 181 (#1)
Feb 26 14:15:30 openqa openqa[3421]: (W uninitialized) An undefined value was used as if it were already
Feb 26 14:15:30 openqa openqa[3421]: defined.  It was interpreted as a "" or a 0, but maybe it was a mistake.
Feb 26 14:15:30 openqa openqa[3421]: To suppress this warning assign a defined value to your variables.
Feb 26 14:15:30 openqa openqa[3421]: To help you figure out what was undefined, perl will try to tell you
Feb 26 14:15:30 openqa openqa[3421]: the name of the variable (if any) that was undefined.  In some cases
Feb 26 14:15:30 openqa openqa[3421]: it cannot do this, so it also tells you what operation you used the
Feb 26 14:15:30 openqa openqa[3421]: undefined value in.  Note, however, that perl optimizes your program
Feb 26 14:15:30 openqa openqa[3421]: anid the operation displayed in the warning may not necessarily appear
Feb 26 14:15:30 openqa openqa[3421]: literally in your program.  For example, "that $foo" is usually
Feb 26 14:15:30 openqa openqa[3421]: optimized into "that " . $foo, and the warning will refer to the
Feb 26 14:15:30 openqa openqa[3421]: concatenation (.) operator, even though there is no . in
Feb 26 14:15:30 openqa openqa[3421]: your program.
Feb 26 14:15:30 openqa openqa[3421]: Use of uninitialized value $md5 in substr at
Feb 26 14:15:30 openqa openqa[3421]: /usr/share/openqa/script/../lib/OpenQA/Utils.pm line 182 (#1)
Feb 26 14:15:30 openqa openqa[3421]: substr outside of string at /usr/share/openqa/script/../lib/OpenQA/Utils.pm
Feb 26 14:15:30 openqa openqa[3421]: line 182 (#2)
Feb 26 14:15:30 openqa openqa[3421]: (W substr)(F) You tried to reference a substr() that pointed outside of
Feb 26 14:15:30 openqa openqa[3421]: a string.  That is, the absolute value of the offset was larger than the
Feb 26 14:15:30 openqa openqa[3421]: length of the string.  See "substr" in perlfunc.  This warning is fatal if
Feb 26 14:15:30 openqa openqa[3421]: substr is used in an lvalue context (as the left hand side of an
Feb 26 14:15:30 openqa openqa[3421]: assignment or as a subroutine argument for example).
Feb 26 14:15:30 openqa openqa[3421]: Use of uninitialized value $md5 in concatenation (.) or string at
Feb 26 14:15:30 openqa openqa[3421]: /usr/share/openqa/script/../lib/OpenQA/Utils.pm line 183 (#1)
Feb 26 14:15:30 openqa openqa[3421]: Use of uninitialized value in concatenation (.) or string at
Feb 26 14:15:30 openqa openqa[3421]: /usr/share/openqa/script/../lib/OpenQA/Schema/Result/JobModules.pm line 266 (#1)
Feb 26 14:15:30 openqa openqa[3421]: Use of uninitialized value in concatenation (.) or string at
Feb 26 14:15:30 openqa openqa[3421]: /usr/share/openqa/script/../lib/OpenQA/Schema/Result/JobModules.pm line 267 (#1