5061: Music Database doesn't show all Data... (1 Viewer)

joEhSuper

MP Donator
  • Premium Supporter
  • June 2, 2011
    1,014
    589
    Home Country
    Austria Austria
    Here comes the magic:
    Code:
    [2021-01-11 23:29:03,357] [Log    ] [MPMain   ] [DEBUG] - MusicDatabase: GetSongsByFilter - SQL: select * from artist  order by strArtist asc, Filter: artist
    [2021-01-11 23:29:03,377] [Log    ] [MPMain   ] [DEBUG] - MusicDatabase: *** GetSongsByFilter - Return: 5478
    ...
    [2021-01-11 23:30:17,385] [Log    ] [MPMain   ] [DEBUG] - MusicDatabase: GetSongsByFilter - SQL: select * from artist  order by strArtist asc, Filter: artist
    [2021-01-11 23:30:32,954] [Log    ] [MPMain   ] [DEBUG] - MusicDatabase: *** GetSongsByFilter - Return: 2578
    ...
    [2021-01-11 23:31:21,417] [Log    ] [MPMain   ] [DEBUG] - MusicDatabase: GetSongsByFilter - SQL: select * from artist  order by strArtist asc, Filter: artist
    [2021-01-11 23:31:37,496] [Log    ] [MPMain   ] [DEBUG] - MusicDatabase: *** GetSongsByFilter - Return: 1270
    :coffee:
    QED :)
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    16,039
    11,112
    Kyiv
    Home Country
    Ukraine Ukraine
    ASAP - in the evening - sadly i'm at work
    Ok, If I'm right, this is a problem with all versions of MP on large amounts of data and not very fast processing.
    I added processing time to this version, check first the first one and give the log file, then this one and also give the log file.
     

    Attachments

    • Databases.dll.Test.2.zip
      116.7 KB

    joEhSuper

    MP Donator
  • Premium Supporter
  • June 2, 2011
    1,014
    589
    Home Country
    Austria Austria
    Ok, If I'm right, this is a problem with all versions of MP on large amounts of data and not very fast processing.
    I added processing time to this version, check first the first one and give the log file, then this one and also give the log file.
    And this is with Test2...
    I think no errors - all entries allways shown (y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)
    Sometimes it take loooong time till list is shown... (but I'm sure you calculated that ;))

    For all test I kept GUIMusic.dll from very first test...
     

    Attachments

    • MediaPortalLogs_12_01_21__17_47.zip
      1.8 MB

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    16,039
    11,112
    Kyiv
    Home Country
    Ukraine Ukraine
    I think it only happened once that not all entries were shown
    It's the same library as in 1.27 you can see it all depends on the connection to the computer :)
    Sometimes it take loooong time till list is shown... (but I'm sure you calculated that ;))
    Yes, I tripled the possible sampling time, now I have to look at the logs, it's not a good solution, but I have to think about it. :)
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    16,039
    11,112
    Kyiv
    Home Country
    Ukraine Ukraine
    Here comes another batch of Magic and Mystery:
    Code:
    [2021-01-12 17:39:58,769] [Log    ] [MPMain   ] [INFO ] - *** dbs:MusicDatabaseV14.db3 sql:select * from artist  order by strArtist asc
    [2021-01-12 17:39:58,789] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -0,0205916 - 5478
    ...
    [2021-01-12 17:41:01,295] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -8,3645348 - 5478
    ...
    [2021-01-12 17:42:50,502] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -13,881237 - 5478
    ...
    [2021-01-12 17:43:13,934] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -9,0750837 - 5478
    ...
    [2021-01-12 17:43:34,354] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -4,1769909 - 5478
    ...
    [2021-01-12 17:44:45,554] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -33,9116157 - 5478
    ...
    [2021-01-12 17:46:43,958] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -34,2862796 - 5478
    Anything less than absolute 15 works in all versions of MP, the rest does not work.
    Like in this situation:
    Code:
    [2021-01-12 17:30:04,881] [Log    ] [MPMain   ] [INFO ] - ReadVm: *** -15,2338346 - 4320

    Code: MediaPortal/MediaPortal-1
    @doskabouter @Sebastiii @azzuro How to solve this problem? just increase the sample waiting time (As done in the second test library, But by how much, I increased from 15 to 50, but if the database will be larger, then increase to 100, 200, infinity)? Or is it possible to change this part nicely so that we don't get into this situation in the future? :):coffee::whistle:
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    16,039
    11,112
    Kyiv
    Home Country
    Ukraine Ukraine
    @joEhSuper I'm not sure that I can give you today a corrected version of the library without the output of debugging information, maybe tomorrow, or maybe we will find a more beautiful solution and then there will be another library. :)
     

    Users who are viewing this thread

    Top Bottom