[fixed] - [MP2-786] Cannot play audio playlist with >=1000 entries

Discussion in '2.2 Archive' started by Nikki Locke, February 6, 2019.

  1. Nikki Locke
    • Team MediaPortal

    Nikki Locke Development Group

    Joined:
    February 2, 2019
    Messages:
    457
    Likes Received:
    32
    Gender:
    Male
    Ratings:
    +59 / 0
    Home Country:
    United Kingdom United Kingdom
    MediaPortal 2 Version: 2.2

    Description
    I have reproduced the problem with VS2017 compiled current master branch (SHA-1: 11cc07571c5240288128e4dae4ce69b66085569c).

    I have created a playlist of all my music (4860 tracks altogether), but any attempt to play it results in the following exception in the log:

    Steps to Reproduce:
    Have lots of music (I have 4680 tracks in my playlist, but I suspect anything over 1000 would do).

    Create a playlist with lots of tracks.



    Go to playlists and choose the playlist.

    Click Load playlist.

    Click Play audio items.

    Nothing is played, and the exception above appears in the log.
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Nikki Locke
    • Team MediaPortal

    Nikki Locke Development Group

    Joined:
    February 2, 2019
    Messages:
    457
    Likes Received:
    32
    Gender:
    Male
    Ratings:
    +59 / 0
    Home Country:
    United Kingdom United Kingdom
    Note - I am happy to try to debug this further, and even fix it, but I don't really understand the way the clustering works, and where to put a breakpoint to find the error.
     
  4. HTPCSourcer
    • Team MediaPortal
    • Administrator

    HTPCSourcer MP2 Product Manager

    Joined:
    May 16, 2008
    Messages:
    10,457
    Likes Received:
    1,103
    Gender:
    Male
    Ratings:
    +2,366 / 21
    Home Country:
    Germany Germany
    Show System Specs
    @Nikki Locke , now I start getting annoyed:
    1. We cannot accept any bug report that is based on own builds
    2. I have absolutely no problem to play a 12000 track playlist on my system.
    Use the official release and things will work. If not, upload DEBUG logs.

    Marking as No Bug.
     
    Last edited: February 6, 2019
  5. Nikki Locke
    • Team MediaPortal

    Nikki Locke Development Group

    Joined:
    February 2, 2019
    Messages:
    457
    Likes Received:
    32
    Gender:
    Male
    Ratings:
    +59 / 0
    Home Country:
    United Kingdom United Kingdom
    It happens exactly the same with the official release - sorry I didn't mention that. I only compiled my own version to try to find out what was happening, but I got lost in a twisty maze of async remote function calls.

    Interesting that it works for you (with the official release, I assume?)

    I wonder what is wrong with my system?
     
  6. HTPCSourcer
    • Team MediaPortal
    • Administrator

    HTPCSourcer MP2 Product Manager

    Joined:
    May 16, 2008
    Messages:
    10,457
    Likes Received:
    1,103
    Gender:
    Male
    Ratings:
    +2,366 / 21
    Home Country:
    Germany Germany
    Show System Specs
    That would have avoided the annoyance at my side. Still, we won't be looking at custom builds in the bug section for obvious reasons.

    This is why we are asking for full Logs.

    At my side I can for example start with the artist view and select ''Add all to Playlist'. This adds my complete collection to the playlist, which then starts playing automatically. Does this work for you?
     
  7. Nikki Locke
    • Team MediaPortal

    Nikki Locke Development Group

    Joined:
    February 2, 2019
    Messages:
    457
    Likes Received:
    32
    Gender:
    Male
    Ratings:
    +59 / 0
    Home Country:
    United Kingdom United Kingdom
    Herewith the logs. Steps used:
    Reboot machine.
    Go to Settings/System/Diagnostics/Enable DEBUG logging, and turn on
    Go to Audio/Audio/Playlists and select large playlist.
    Click Load playlist button. Rectangle (dialog) appears on screen saying "Adding items to playlist 0", then goes away again.
    Click Show audio playlist - it says <No items in playlist>
     

    Attached Files:

  8. Nikki Locke
    • Team MediaPortal

    Nikki Locke Development Group

    Joined:
    February 2, 2019
    Messages:
    457
    Likes Received:
    32
    Gender:
    Male
    Ratings:
    +59 / 0
    Home Country:
    United Kingdom United Kingdom
    I guess the initial problem is at the server end:

    [ERROR] - Unable to query
    code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error
    too many SQL variables
    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
    at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
    at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
    at System.Data.SQLite.SQLiteDataReader.NextResult()
    at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
    at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
    at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
    at MediaPortal.Backend.Services.MediaLibrary.QueryEngine.CompiledMediaItemQuery.GetMediaItems(ISQLDatabase database, ITransaction transaction, Boolean singleMode, IEnumerable`1 selectedMIAs, IList`1& mediaItemIds, IDictionary`2& complexMediaItems, Boolean forceSingleMIAMode)
    at MediaPortal.Backend.Services.MediaLibrary.QueryEngine.CompiledMediaItemQuery.Query(ISQLDatabase database, ITransaction transaction, Boolean singleMode)

    and the client end is not trapping and reporting the exception (except to the log) - but maybe that is working as designed, as an error message would not help most users.
     
  9. HTPCSourcer
    • Team MediaPortal
    • Administrator

    HTPCSourcer MP2 Product Manager

    Joined:
    May 16, 2008
    Messages:
    10,457
    Likes Received:
    1,103
    Gender:
    Male
    Ratings:
    +2,366 / 21
    Home Country:
    Germany Germany
    Show System Specs
    Can you please try this:
     
  10. Nikki Locke
    • Team MediaPortal

    Nikki Locke Development Group

    Joined:
    February 2, 2019
    Messages:
    457
    Likes Received:
    32
    Gender:
    Male
    Ratings:
    +59 / 0
    Home Country:
    United Kingdom United Kingdom
    Sorry, I thought I had replied to that one.

    Yes, I can add all my music to the currently playing playlist, and that works fine.

    But if I save that playlist as a saved playlist, and try to load it again, that causes the exception at the server end (and creates an empty audio playlist at the client end, which shows as playing in the little icon at the top left of the screen, but obviously no music happens).
     
  11. HTPCSourcer
    • Team MediaPortal
    • Administrator

    HTPCSourcer MP2 Product Manager

    Joined:
    May 16, 2008
    Messages:
    10,457
    Likes Received:
    1,103
    Gender:
    Male
    Ratings:
    +2,366 / 21
    Home Country:
    Germany Germany
    Show System Specs
    Good. So at least this is working.

    I'll try to reproduce this. You mentioned 1000+ tracks. Did you try with a small number, e.g. 20, 50, 100?
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!