Slow Music/Video Library (1 Viewer)

petrovice

MP Donator
  • Premium Supporter
  • January 8, 2009
    56
    1
    Bamberg
    Germany Germany
    TV-Server Version: 1.0
    MediaPortal Version: 1.0
    MediaPortal Skin: Monochrome
    Windows Version: Windows Vista SP1
    CPU Type: AMD Athlon X2 4850e
    Motherboard: GigaByte GA-MA78GPM-DS2H
    Video Card: Onboard ATI HD 3200
    Video Card Driver: Ati Catalyst 8.12
    1. TV Card: Floppy DTV DVB-S2
    TV - HTPC Connection: HDMI

    Hi,
    first of all I would like to say a big thank you to all the developers of MP - you have done a very good job and I am looking forward for the MP 2.0.

    I have a problem with the behaviour of the Music/Video Library. Everything is very slow and it takes about 5-10 seconds to open the ShareView.

    The following Exception is thrown when entering or navigating through the Music library:
    Code:
    2009-01-08 07:27:21.328000 [ERROR][MPMain]: SQLiteClient: query returned CORRUPT delete from tblSetting where idPath=2 and tagName ='MusicFiles'
    2009-01-08 07:27:21.329000 [ERROR][MPMain]: SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:delete from tblSetting where idPath=2 and tagName ='MusicFiles'
    2009-01-08 07:27:21.330000 [ERROR][MPMain]: Exception   :SQLite.NET.SQLiteException: SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:delete from tblSetting where idPath=2 and tagName ='MusicFiles'
       bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    2009-01-08 07:27:21.330000 [ERROR][MPMain]: Exception   :SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:delete from tblSetting where idPath=2 and tagName ='MusicFiles'
    2009-01-08 07:27:21.331000 [ERROR][MPMain]:   site      :Void ThrowError(System.String, System.String, SqliteError)
    2009-01-08 07:27:21.332000 [ERROR][MPMain]:   source    :Databases
    2009-01-08 07:27:21.332000 [ERROR][MPMain]:   stacktrace:   bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    2009-01-08 07:27:26.333000 [ERROR][MPMain]: SQLiteClient: query returned CORRUPT insert into tblSetting (idSetting,idPath, tagName,tagValue) values(NULL, 2, 'MusicFiles', '<?xml version="1.0" encoding="utf-8"?>
    <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <SortBy>0</SortBy>
      <ViewAs>4</ViewAs>
      <SortAscending>true</SortAscending>
    </MapSettings>') 
    2009-01-08 07:27:26.334000 [ERROR][MPMain]: SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:insert into tblSetting (idSetting,idPath, tagName,tagValue) values(NULL, 2, 'MusicFiles', '<?xml version="1.0" encoding="utf-8"?>
    <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <SortBy>0</SortBy>
      <ViewAs>4</ViewAs>
      <SortAscending>true</SortAscending>
    </MapSettings>') 
    2009-01-08 07:27:26.335000 [ERROR][MPMain]: Exception   :SQLite.NET.SQLiteException: SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:insert into tblSetting (idSetting,idPath, tagName,tagValue) values(NULL, 2, 'MusicFiles', '<?xml version="1.0" encoding="utf-8"?>
    <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <SortBy>0</SortBy>
      <ViewAs>4</ViewAs>
      <SortAscending>true</SortAscending>
    </MapSettings>') 
       bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.AddFolderSetting(String strPath, String Key, Type type, Object Value)
    2009-01-08 07:27:26.335000 [ERROR][MPMain]: Exception   :SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:insert into tblSetting (idSetting,idPath, tagName,tagValue) values(NULL, 2, 'MusicFiles', '<?xml version="1.0" encoding="utf-8"?>
    <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <SortBy>0</SortBy>
      <ViewAs>4</ViewAs>
      <SortAscending>true</SortAscending>
    </MapSettings>') 
    2009-01-08 07:27:26.336000 [ERROR][MPMain]:   site      :Void ThrowError(System.String, System.String, SqliteError)
    2009-01-08 07:27:26.337000 [ERROR][MPMain]:   source    :Databases
    2009-01-08 07:27:26.337000 [ERROR][MPMain]:   stacktrace:   bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.AddFolderSetting(String strPath, String Key, Type type, Object Value)
    And equal to that, I get an exception in the Video Library:
    Code:
    2009-01-08 07:32:34.270000 [ERROR][MPMain]: Exception   :System.OutOfMemoryException: Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
       bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
       bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
       bei System.Collections.Generic.List`1.Add(T item)
       bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    2009-01-08 07:32:34.271000 [ERROR][MPMain]: Exception   :Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
    2009-01-08 07:32:34.272000 [ERROR][MPMain]:   site      :Void set_Capacity(Int32)
    2009-01-08 07:32:34.272000 [ERROR][MPMain]:   source    :mscorlib
    2009-01-08 07:32:34.273000 [ERROR][MPMain]:   stacktrace:   bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
       bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
       bei System.Collections.Generic.List`1.Add(T item)
       bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    2009-01-08 07:32:38.719000 [ERROR][MPMain]: Exception   :System.OutOfMemoryException: Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
       bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
       bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
       bei System.Collections.Generic.List`1.Add(T item)
       bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.AddFolderSetting(String strPath, String Key, Type type, Object Value)
    2009-01-08 07:32:38.720000 [ERROR][MPMain]: Exception   :Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
    2009-01-08 07:32:38.720000 [ERROR][MPMain]:   site      :Void set_Capacity(Int32)
    2009-01-08 07:32:38.721000 [ERROR][MPMain]:   source    :mscorlib
    2009-01-08 07:32:38.722000 [ERROR][MPMain]:   stacktrace:   bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
       bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
       bei System.Collections.Generic.List`1.Add(T item)
       bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.AddFolderSetting(String strPath, String Key, Type type, Object Value)
    2009-01-08 07:32:44.282000 [ERROR][MPMain]: SQLiteClient: query returned CORRUPT select * from tblSetting where idPath=52 and tagName like 'VideoFiles'
    2009-01-08 07:32:44.282000 [ERROR][MPMain]: SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select * from tblSetting where idPath=52 and tagName like 'VideoFiles'
    2009-01-08 07:32:44.283000 [ERROR][MPMain]: Exception   :SQLite.NET.SQLiteException: SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select * from tblSetting where idPath=52 and tagName like 'VideoFiles'
       bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.GetFolderSetting(String strPath, String Key, Type type, Object& Value)
    2009-01-08 07:32:44.284000 [ERROR][MPMain]: Exception   :SQLiteClient:  cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:select * from tblSetting where idPath=52 and tagName like 'VideoFiles'
    2009-01-08 07:32:44.284000 [ERROR][MPMain]:   site      :Void ThrowError(System.String, System.String, SqliteError)
    2009-01-08 07:32:44.285000 [ERROR][MPMain]:   source    :Databases
    2009-01-08 07:32:44.285000 [ERROR][MPMain]:   stacktrace:   bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei Databases.Folders.FolderSettingsSqlLite.GetFolderSetting(String strPath, String Key, Type type, Object& Value)
    These exceptions occur on a fresh installation of MP 1.0. I have already made a complete rescan of the music/video database in the MP Configuration, but with no success.

    Is there a problem with the permissions on Windows Vista?
    How can I open the Music/Video Database manual to check the query?

    Thanks a lot for your help,
    Peter
     

    rtv

    Retired Team Member
  • Premium Supporter
  • April 7, 2005
    3,622
    301
    Osnabruck
    Germany Germany
    Well how did you manage to corrupt your DB?
    Which tool did you use to try to connect to those DBs?
     

    petrovice

    MP Donator
  • Premium Supporter
  • January 8, 2009
    56
    1
    Bamberg
    Germany Germany
    Hi rtv,
    I did nothing :confused:

    As I mentioned - the installation of MP 1.0 is fresh and I have only changed the root folder of the music/video to my custom paths.

    I have never tried to connect to the DB´s, because I don´t know how and where to find it. This was just a thought to find the corrupt entry.
     

    petrovice

    MP Donator
  • Premium Supporter
  • January 8, 2009
    56
    1
    Bamberg
    Germany Germany
    After getting the SourceCode from SVN and trying to reproduce the error on my working machine, I have found the reason for the exception.

    It was a permission problem in Vista! I have made the installation and configuration with my normal user account and the music/video database was not created, because MP has not the sufficent rights. After running the MP Configuration as an Admin, the music/video database was successfully created.
    Now the databases were back, I have started MP as a normal User and the exception still occurs. When running MP as an Admin, everything runs smoth and fast as expected without errors.
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    T Client / Server slow channel-to-channel change (zapping) General Support 1
    C Importer works super slow My TVSeries 5
    doskabouter 1.23.0 Slow rendering times Bugreports 46
    A Client/Server Setup: Slow TV Startup Television (MyTV frontend and TV-Server) 0
    F GUI incredibly slow Performance General 22
    P Very slow start My TVSeries 2
    B some music videos stutter Watch / Listen Media 0
    horned_reaper [solved] When playing music Fanart does not shuffle Fanart Handler 20
    horned_reaper [solved] When playing music Fanart does not appear immediately after downloading Fanart Handler 272
    horned_reaper [Music] 5012: Start current music track from the beginning Improvement Suggestions 37
    horned_reaper [solved] 5012: Restart current music track General Support 13
    atlantic How to use Spotify inside Mediaportal? Listen Music 18
    horned_reaper [solved] Music playback hangs General Support 58
    globaldonkey Music Database Error Listen Music 1
    joecrow Music on Headphones Listen Music 8
    2BitSculptor MP 1.23.. music stops playing General Support 6
    Sarxas What Music Are You Listening To? OffTopic 0
    Edwardfc [solved] Mp 2.2.1 Configuration Issues - Goes to Sleep while playing Music General 6
    G [fixed] [MP2-786] Party Music Player can only play playlists with less than 1000 items 2.2 Archive 7
    KlausWirn Music crash Bass crash no change to play music Installation, configuration support 2
    BlueMax1916 [confirm] Music: Every 2nd track skipped MediaPortal 2 30
    N Music player help Listen Music 4
    N How to shuffle all my music, and how to sort by album artist General 4
    R MP 2.2 client spielt audio-titel kurz an und springt dann zum nächten Allgemeines Support- und Diskussionsforum 9
    joecrow Music: Fade Out not working 1.20 Pre Release 0
    Top Bottom