Slow Music/Video Library

Discussion in 'General Support' started by petrovice, January 8, 2009.

  1. petrovice
    • Premium Supporter

    petrovice MP Donator

    Joined:
    January 8, 2009
    Messages:
    56
    Likes Received:
    1
    Occupation:
    IT-Developer
    Location:
    Bamberg
    Ratings:
    +1 / 0
    Home Country:
    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 (Text):
    1. 2009-01-08 07:27:21.328000 [ERROR][MPMain]: SQLiteClient: query returned CORRUPT delete from tblSetting where idPath=2 and tagName ='MusicFiles'
    2. 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'
    3. 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'
    4.    bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    5.    bei SQLite.NET.SQLiteClient.Execute(String query)
    6.    bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    7. 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'
    8. 2009-01-08 07:27:21.331000 [ERROR][MPMain]:   site      :Void ThrowError(System.String, System.String, SqliteError)
    9. 2009-01-08 07:27:21.332000 [ERROR][MPMain]:   source    :Databases
    10. 2009-01-08 07:27:21.332000 [ERROR][MPMain]:   stacktrace:   bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    11.    bei SQLite.NET.SQLiteClient.Execute(String query)
    12.    bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    13. 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"?>
    14. <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    15.   <SortBy>0</SortBy>
    16.   <ViewAs>4</ViewAs>
    17.   <SortAscending>true</SortAscending>
    18. </MapSettings>')
    19. 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"?>
    20. <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    21.   <SortBy>0</SortBy>
    22.   <ViewAs>4</ViewAs>
    23.   <SortAscending>true</SortAscending>
    24. </MapSettings>')
    25. 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"?>
    26. <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    27.   <SortBy>0</SortBy>
    28.   <ViewAs>4</ViewAs>
    29.   <SortAscending>true</SortAscending>
    30. </MapSettings>')
    31.    bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    32.    bei SQLite.NET.SQLiteClient.Execute(String query)
    33.    bei Databases.Folders.FolderSettingsSqlLite.AddFolderSetting(String strPath, String Key, Type type, Object Value)
    34. 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"?>
    35. <MapSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    36.   <SortBy>0</SortBy>
    37.   <ViewAs>4</ViewAs>
    38.   <SortAscending>true</SortAscending>
    39. </MapSettings>')
    40. 2009-01-08 07:27:26.336000 [ERROR][MPMain]:   site      :Void ThrowError(System.String, System.String, SqliteError)
    41. 2009-01-08 07:27:26.337000 [ERROR][MPMain]:   source    :Databases
    42. 2009-01-08 07:27:26.337000 [ERROR][MPMain]:   stacktrace:   bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    43.    bei SQLite.NET.SQLiteClient.Execute(String query)
    44.    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 (Text):
    1. 2009-01-08 07:32:34.270000 [ERROR][MPMain]: Exception   :System.OutOfMemoryException: Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
    2.    bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
    3.    bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
    4.    bei System.Collections.Generic.List`1.Add(T item)
    5.    bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
    6.    bei SQLite.NET.SQLiteClient.Execute(String query)
    7.    bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    8. 2009-01-08 07:32:34.271000 [ERROR][MPMain]: Exception   :Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
    9. 2009-01-08 07:32:34.272000 [ERROR][MPMain]:   site      :Void set_Capacity(Int32)
    10. 2009-01-08 07:32:34.272000 [ERROR][MPMain]:   source    :mscorlib
    11. 2009-01-08 07:32:34.273000 [ERROR][MPMain]:   stacktrace:   bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
    12.    bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
    13.    bei System.Collections.Generic.List`1.Add(T item)
    14.    bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
    15.    bei SQLite.NET.SQLiteClient.Execute(String query)
    16.    bei Databases.Folders.FolderSettingsSqlLite.DeleteFolderSetting(String strPath, String Key)
    17. 2009-01-08 07:32:38.719000 [ERROR][MPMain]: Exception   :System.OutOfMemoryException: Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
    18.    bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
    19.    bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
    20.    bei System.Collections.Generic.List`1.Add(T item)
    21.    bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
    22.    bei SQLite.NET.SQLiteClient.Execute(String query)
    23.    bei Databases.Folders.FolderSettingsSqlLite.AddFolderSetting(String strPath, String Key, Type type, Object Value)
    24. 2009-01-08 07:32:38.720000 [ERROR][MPMain]: Exception   :Eine Ausnahme vom Typ System.OutOfMemoryException wurde ausgelöst.
    25. 2009-01-08 07:32:38.720000 [ERROR][MPMain]:   site      :Void set_Capacity(Int32)
    26. 2009-01-08 07:32:38.721000 [ERROR][MPMain]:   source    :mscorlib
    27. 2009-01-08 07:32:38.722000 [ERROR][MPMain]:   stacktrace:   bei System.Collections.Generic.List`1.set_Capacity(Int32 value)
    28.    bei System.Collections.Generic.List`1.EnsureCapacity(Int32 min)
    29.    bei System.Collections.Generic.List`1.Add(T item)
    30.    bei SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
    31.    bei SQLite.NET.SQLiteClient.Execute(String query)
    32.    bei Databases.Folders.FolderSettingsSqlLite.AddFolderSetting(String strPath, String Key, Type type, Object Value)
    33. 2009-01-08 07:32:44.282000 [ERROR][MPMain]: SQLiteClient: query returned CORRUPT select * from tblSetting where idPath=52 and tagName like 'VideoFiles'
    34. 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'
    35. 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'
    36.    bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    37.    bei SQLite.NET.SQLiteClient.Execute(String query)
    38.    bei Databases.Folders.FolderSettingsSqlLite.GetFolderSetting(String strPath, String Key, Type type, Object& Value)
    39. 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'
    40. 2009-01-08 07:32:44.284000 [ERROR][MPMain]:   site      :Void ThrowError(System.String, System.String, SqliteError)
    41. 2009-01-08 07:32:44.285000 [ERROR][MPMain]:   source    :Databases
    42. 2009-01-08 07:32:44.285000 [ERROR][MPMain]:   stacktrace:   bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    43.    bei SQLite.NET.SQLiteClient.Execute(String query)
    44.    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
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. rtv
    • Premium Supporter

    rtv Retired Team Member

    Joined:
    April 7, 2005
    Messages:
    3,622
    Likes Received:
    301
    Occupation:
    CTO at ES2000
    Location:
    Osnabruck
    Ratings:
    +301 / 0
    Home Country:
    Germany Germany
    Show System Specs
    Well how did you manage to corrupt your DB?
    Which tool did you use to try to connect to those DBs?
     
  4. petrovice
    • Premium Supporter

    petrovice MP Donator

    Joined:
    January 8, 2009
    Messages:
    56
    Likes Received:
    1
    Occupation:
    IT-Developer
    Location:
    Bamberg
    Ratings:
    +1 / 0
    Home Country:
    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.
     
  5. petrovice
    • Premium Supporter

    petrovice MP Donator

    Joined:
    January 8, 2009
    Messages:
    56
    Likes Received:
    1
    Occupation:
    IT-Developer
    Location:
    Bamberg
    Ratings:
    +1 / 0
    Home Country:
    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.
     
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!