Home of the Squeezebox™ & Transporter® network music players.
Results 1 to 8 of 8
  1. #1
    Senior Member
    Join Date
    Jan 2010
    Location
    Hertfordshire
    Posts
    1,662

    Warning in server log

    I have recently noticed quite a few warnings like this in the server log. I have no idea if it is important but thought it was worth reporting.

    [18-08-09 16:55:05.8380] Slim::Utils::Misc::msg (1252) Warning: [16:55:05.8367] DBIx::Class::ResultSet::single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 2284

  2. #2
    Senior Member
    Join Date
    Jan 2010
    Location
    Hertfordshire
    Posts
    1,662
    Quote Originally Posted by slartibartfast View Post
    I have recently noticed quite a few warnings like this in the server log. I have no idea if it is important but thought it was worth reporting.

    [18-08-09 16:55:05.8380] Slim::Utils::Misc::msg (1252) Warning: [16:55:05.8367] DBIx::Class::ResultSet::single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/perl5/Slim/Schema.pm line 2284
    Edit. running latest 7.9.2

  3. #3
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,032

    Warning in server log

    > [18-08-09 16:55:05.8380] Slim::Utils::Misc::msg (1252) Warning:
    > [16:55:05.8367] DBIx::Class::ResultSet::single(): Query returned more
    > than one row. SQL that returns multiple rows is DEPRECATED for ->find
    > and ->single at /usr/share/perl5/Slim/Schema.pm line 2284


    Most likely you have an artist "Various Artists" (or whatever string is
    defined in settings for the VA).

    --

    Michael

  4. #4
    Senior Member
    Join Date
    Jan 2010
    Location
    Hertfordshire
    Posts
    1,662
    Quote Originally Posted by mherger View Post
    > [18-08-09 16:55:05.8380] Slim::Utils::Misc::msg (1252) Warning:
    > [16:55:05.8367] DBIx::Class::ResultSet::single(): Query returned more
    > than one row. SQL that returns multiple rows is DEPRECATED for ->find
    > and ->single at /usr/share/perl5/Slim/Schema.pm line 2284


    Most likely you have an artist "Various Artists" (or whatever string is
    defined in settings for the VA).

    --

    Michael
    Do you mean I have an artist that I have named "Various Artists"? I always let LMS decide that and have not knowingly named any myself. Can I set logging to find out more?

    Sent from my SM-G900F using Tapatalk

  5. #5
    Senior Member
    Join Date
    Jan 2010
    Location
    Hertfordshire
    Posts
    1,662
    Quote Originally Posted by mherger View Post
    > [18-08-09 16:55:05.8380] Slim::Utils::Misc::msg (1252) Warning:
    > [16:55:05.8367] DBIx::Class::ResultSet::single(): Query returned more
    > than one row. SQL that returns multiple rows is DEPRECATED for ->find
    > and ->single at /usr/share/perl5/Slim/Schema.pm line 2284


    Most likely you have an artist "Various Artists" (or whatever string is
    defined in settings for the VA).

    --

    Michael
    My server log goes back to 30-03-18 and these warnings started to appear 26-07-18. Nothing added around that time is "Various Artists".

    Sent from my SM-G900F using Tapatalk

  6. #6
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,032

    Warning in server log

    > Do you mean I have an artist that I have named "Various Artists"? I

    Yes.

    > always let LMS decide that and have not knowingly named any myself. Can
    > I set logging to find out more?


    You could use a metadata editing tool like mp3tag. Or search the
    library.db if you were familiar with SQL.

    --

    Michael

  7. #7
    Babelfish's Best Boy mherger's Avatar
    Join Date
    Apr 2005
    Location
    Switzerland
    Posts
    20,032

    Warning in server log

    >>> [18-08-09 16:55:05.8380] Slim::Utils::Misc::msg (1252) Warning:
    >>> [16:55:05.8367] DBIx::Class::ResultSet::single(): Query returned more
    >>> than one row. SQL that returns multiple rows is DEPRECATED for ->find
    >>> and ->single at /usr/share/perl5/Slim/Schema.pm line 2284

    ....
    > My server log goes back to 30-03-18 and these warnings started to appear
    > 26-07-18. Nothing added around that time is "Various Artists".


    Ok, probably something else. That particular line would look up a track
    or playlist by their URL in their corresponding tables. Can you check
    the database to see whether there indeed are duplicates in there?

    Maybe a wipe & rescan would clean this up.

    --

    Michael

  8. #8
    Junior Member
    Join Date
    Dec 2015
    Location
    Hertfordshire
    Posts
    5
    My logs go back to October 2017 and these warnings were generated way back then. However, I wonder if people with this issue have installed a PiCore player on their network? I run LMS 7.9.2 on a Debian server, and have a few Booms & Duets scattered around the house. I also have one PiCore player running on a Pi3 plugged into my AV amp via HDMI. Note that this player is not running LMS. I've been running my LMS on Debian for about 10 years, and it's been upgraded, migrated to new hardware, and generally messed about with over the years.

    For reasons I don't really understand, my "server.prefs" had two entries for the variable "variousArtistsString". It seems that my PiCore player had created two sets of entries with different MAC addresses. One was all zeros, which may have happened during installation, so I simply deleted that whole section (about 190 lines). After stopping the service, deleting all the logs, restarting & doing a full rescan, the vast majority of the warnings have gone - I still have one in the scanner log, and three in the server log which I'm not going to lose any sleep over.

    I hope this gives others a bit of a clue.

    A huge thanks go to Michael & Co for all their work. It's very much appreciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •