SQLLite connection lost -> crash (remote location) (1 Viewer)

[Terra]

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.

[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

 

[Terra]

bump

 

[mm1352000]

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.

The cause of the problem is the database gets corrupted. The corruption probably occurs due to simultaneous access from multiple clients. So, your configuration (storing the database on a share) is causing the problem.

I suggest you investigate MP Sync:
https://forum.team-mediaportal.com/...ediaportal-multi-seat-synchronization.117417/