action #10940
Updated by okurz about 9 years ago
## 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 ```