- August 25, 2009
- 230
- 57
- Home Country
- Austria
Hi there,
I store my SQLLite databases and thumbs on a share in my network. Now sometimes it happens that MePo stops responding all of a sudden and also crashes or some plugins like MP TV-Series start behaving very slow and get stuck.
When I look into the logs I see a lot of SQLLite connection errors or blocked database errors.
Is there something I can do to avoid this? I would like to keep my databases on the central share and don't have it on my clients.
Below are the relevant log parts. I can also add all logs if needed.
br
Terra
I store my SQLLite databases and thumbs on a share in my network. Now sometimes it happens that MePo stops responding all of a sudden and also crashes or some plugins like MP TV-Series start behaving very slow and get stuck.
When I look into the logs I see a lot of SQLLite connection errors or blocked database errors.
Is there something I can do to avoid this? I would like to keep my databases on the central share and don't have it on my clients.
Below are the relevant log parts. I can also add all logs if needed.
Code:
[2014-03-23 17:11:25,360] [Log ] [PicPrefetch] [WARN ] - Picture: exception loading H:\2014.03 - Sao Paulo TW\Markierte Fotos – 03.JPG
[2014-03-23 17:14:17,772] [Log ] [PoolThread22] [WARN ] - GUIPictures: Omitting outside path H: from check share H:\2014.03 - Sao Paulo TW
[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist
[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist
[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist
[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist
[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist
[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist
[2014-03-23 17:14:17,850] [Log ] [PoolThread14] [WARN ] - GUIPictures: Omitting outside path H: from check share H:\2014.03 - Sao Paulo TW
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database: PictureDatabase.db3
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[... A LOT MORE LINES LIKE THE ABOVE ...]
[2014-03-23 17:14:33,273] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:33,273] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:33,288] [Error ] [PoolThread22] [ERROR] - SQLiteClient: cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:commit
[2014-03-23 17:14:33,288] [Error ] [PoolThread22] [ERROR] - PictureDatabaseSqlLite: exception err:SQLiteClient: cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:commit stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Picture.Database.PictureDatabaseSqlLite.AddPicture(String strPicture, Int32 iRotation)
[2014-03-23 17:14:33,288] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:
[2014-03-23 17:14:33,288] [Log ] [PoolThread22] [WARN ] - PictureDatabaseSqlLite: Disposing current instance..
[2014-03-23 17:14:33,288] [Log ] [PoolThread22] [INFO ] - SQLLiteClient: database is remote
[2014-03-23 17:14:33,320] [Error ] [PoolThread22] [ERROR] - SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096
[2014-03-23 17:14:33,320] [Error ] [PoolThread22] [ERROR] - picture database exception err:SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096 stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Database.DatabaseUtility.SetPragmas(SQLiteClient m_db)
at MediaPortal.Picture.Database.PictureDatabaseSqlLite.Open()
[2014-03-23 17:14:33,320] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database: PictureDatabase.db3
[2014-03-23 17:14:33,320] [Log ] [PoolThread22] [WARN ] - PictureDatabaseSqlLite: Disposing current instance..
[2014-03-23 17:14:33,320] [Log ] [PoolThread22] [INFO ] - SQLLiteClient: database is remote
[2014-03-23 17:14:33,351] [Error ] [PoolThread22] [ERROR] - SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096
[2014-03-23 17:14:33,351] [Error ] [PoolThread22] [ERROR] - picture database exception err:SQLiteClient: PictureDatabase.db3 cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:PRAGMA cache_size=4096 stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at MediaPortal.Database.DatabaseUtility.SetPragmas(SQLiteClient m_db)
at MediaPortal.Picture.Database.PictureDatabaseSqlLite.Open()
[2014-03-23 17:14:33,351] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database: PictureDatabase.db3
[2014-03-23 17:14:33,351] [Log ] [PoolThread22] [WARN ] - PictureDatabaseSqlLite: Disposing current instance..
[2014-03-23 17:14:33,351] [Log ] [PoolThread22] [INFO ] - SQLLiteClient: database is remote
br
Terra