Slow Music/Video Library (1 Viewer)

[petrovice]

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:

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:

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]

Well how did you manage to corrupt your DB?
Which tool did you use to try to connect to those DBs?

 

[petrovice]

Hi rtv,
I did nothing

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]

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.