home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
General Support
SQLLite connection lost -> crash (remote location)
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Terra" data-source="post: 1071693" data-attributes="member: 97366"><p>Hi there,</p><p></p><p>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.</p><p>When I look into the logs I see a lot of SQLLite connection errors or blocked database errors.</p><p></p><p>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.</p><p></p><p>Below are the relevant log parts. I can also add all logs if needed.</p><p></p><p>[CODE]</p><p>[2014-03-23 17:11:25,360] [Log ] [PicPrefetch] [WARN ] - Picture: exception loading H:\2014.03 - Sao Paulo TW\Markierte Fotos – 03.JPG</p><p>[2014-03-23 17:14:17,772] [Log ] [PoolThread22] [WARN ] - GUIPictures: Omitting outside path H: from check share H:\2014.03 - Sao Paulo TW</p><p>[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist</p><p>[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist</p><p>[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist</p><p>[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist</p><p>[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist</p><p>[2014-03-23 17:14:17,772] [Log ] [MPMain ] [WARN ] - GUIFontManager: Font with the name 'font16' does not exist</p><p>[2014-03-23 17:14:17,850] [Log ] [PoolThread14] [WARN ] - GUIPictures: Omitting outside path H: from check share H:\2014.03 - Sao Paulo TW</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database: PictureDatabase.db3</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:19,468] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p></p><p>[... A LOT MORE LINES LIKE THE ABOVE ...]</p><p></p><p>[2014-03-23 17:14:33,273] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:33,273] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[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</p><p>[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)</p><p> at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr& pVm)</p><p> at SQLite.NET.SQLiteClient.Execute(String query)</p><p> at MediaPortal.Picture.Database.PictureDatabaseSqlLite.AddPicture(String strPicture, Int32 iRotation)</p><p>[2014-03-23 17:14:33,288] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database:</p><p>[2014-03-23 17:14:33,288] [Log ] [PoolThread22] [WARN ] - PictureDatabaseSqlLite: Disposing current instance..</p><p>[2014-03-23 17:14:33,288] [Log ] [PoolThread22] [INFO ] - SQLLiteClient: database is remote</p><p>[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</p><p>[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)</p><p> at SQLite.NET.SQLiteClient.Execute(String query)</p><p> at MediaPortal.Database.DatabaseUtility.SetPragmas(SQLiteClient m_db)</p><p> at MediaPortal.Picture.Database.PictureDatabaseSqlLite.Open()</p><p>[2014-03-23 17:14:33,320] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database: PictureDatabase.db3</p><p>[2014-03-23 17:14:33,320] [Log ] [PoolThread22] [WARN ] - PictureDatabaseSqlLite: Disposing current instance..</p><p>[2014-03-23 17:14:33,320] [Log ] [PoolThread22] [INFO ] - SQLLiteClient: database is remote</p><p>[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</p><p>[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)</p><p> at SQLite.NET.SQLiteClient.Execute(String query)</p><p> at MediaPortal.Database.DatabaseUtility.SetPragmas(SQLiteClient m_db)</p><p> at MediaPortal.Picture.Database.PictureDatabaseSqlLite.Open()</p><p>[2014-03-23 17:14:33,351] [Log ] [PoolThread22] [INFO ] - SQLiteClient: Closing database: PictureDatabase.db3</p><p>[2014-03-23 17:14:33,351] [Log ] [PoolThread22] [WARN ] - PictureDatabaseSqlLite: Disposing current instance..</p><p>[2014-03-23 17:14:33,351] [Log ] [PoolThread22] [INFO ] - SQLLiteClient: database is remote</p><p>[/CODE]</p><p></p><p>br</p><p>Terra</p></blockquote><p></p>
[QUOTE="Terra, post: 1071693, member: 97366"] 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. [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 [/CODE] br Terra [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
SQLLite connection lost -> crash (remote location)
Contact us
RSS
Top
Bottom
