CogyG 3 Posted October 29, 2022 Share Posted October 29, 2022 He Guys, I just got this message when scanning my libary? Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3 db, System.Int32 rc) [0x00017] in <3160c670dc5644c0a9f2a273b5e4e944>:0 at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3_stmt stmt, System.Int32 rc) [0x00006] in <3160c670dc5644c0a9f2a273b5e4e944>:0 at SQLitePCL.pretty.StatementImpl.MoveNext () [0x0004a] in <3160c670dc5644c0a9f2a273b5e4e944>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.ExecuteWithStringFormatParam (SQLitePCL.pretty.IDatabaseConnection db, System.String query, System.String valueText, System.Int64[] values) [0x00034] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInTransaction (SQLitePCL.pretty.IDatabaseConnection db, System.Int64[] ids, System.Boolean containsFolders, System.Boolean supportsPeople, System.Boolean supportsChapters, System.Boolean supportsCollections, System.Boolean supportsMediaStreams, System.Boolean supportsListItems, System.Boolean supportsExternalDatabases) [0x0023c] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInChunks (System.Int64[] ids, SQLitePCL.pretty.IDatabaseConnection db, System.Boolean containsFolders, System.Boolean supportsPeople, System.Boolean supportsChapters, System.Boolean supportsCollections, System.Boolean supportsMediaStreams, System.Boolean supportsListItems, System.Boolean supportsExternalDatabases) [0x00031] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (System.Int64[] ids) [0x00049] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (MediaBrowser.Controller.Entities.BaseItem[] items) [0x0002b] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at Emby.Server.Implementations.Library.LibraryManager.DeleteItem (MediaBrowser.Controller.Entities.BaseItem item, MediaBrowser.Controller.Library.DeleteOptions options, MediaBrowser.Controller.Entities.BaseItem parent, System.Boolean notifyParentItem) [0x001d6] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken, System.Boolean recursive, System.Boolean refreshChildMetadata, MediaBrowser.Controller.Providers.MetadataRefreshOptions refreshOptions, MediaBrowser.Controller.Providers.IDirectoryService directoryService) [0x0022e] in <ea29abd8f0ca46269160bb34e38b3817>:0 at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders (MediaBrowser.Controller.Entities.BaseItem[] children, MediaBrowser.Controller.Providers.IDirectoryService directoryService, System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x0013f] in <ea29abd8f0ca46269160bb34e38b3817>:0 at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken, System.Boolean recursive, System.Boolean refreshChildMetadata, MediaBrowser.Controller.Providers.MetadataRefreshOptions refreshOptions, MediaBrowser.Controller.Providers.IDirectoryService directoryService) [0x0039b] in <ea29abd8f0ca46269160bb34e38b3817>:0 at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x0014a] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x00092] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal (MediaBrowser.Model.Tasks.TaskOptions options) [0x001b0] in <8b98834ec7ec4ab3b9c3092251aa3269>:0 </ea29abd8f0ca46269160bb34e38b3817></ea29abd8f0ca46269160bb34e38b3817></ea29abd8f0ca46269160bb34e38b3817> Link to comment Share on other sites More sharing options...
Luke 37063 Posted October 29, 2022 Share Posted October 29, 2022 Hi, you'll probably need to go through the steps in this article here: https://support.emby.media/support/solutions/articles/44002210894-corrupt-database If you can attach the complete server log file we'll be able to verify. Thanks. Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted October 29, 2022 Share Posted October 29, 2022 @CogyG Can you provide the server log to see the exact error? But may need to follow the KB depending on the error. Link to comment Share on other sites More sharing options...
CogyG 3 Posted November 1, 2022 Author Share Posted November 1, 2022 On 10/29/2022 at 3:37 PM, Luke said: Hi, you'll probably need to go through the steps in this article here: https://support.emby.media/support/solutions/articles/44002210894-corrupt-database If you can attach the complete server log file we'll be able to verify. Thanks. Thanks for the response. @cayars i've attached the server log My database files are on the Shield. How can i acces these files? Is it possile to just remove everything on the shield and reinstall server and client? Edit: i think this all happend when i updated te server to 476, i'm now updating to 468.. Do you guys recommend the beta ? embyserver.txt Link to comment Share on other sites More sharing options...
Carlo 4330 Posted November 7, 2022 Share Posted November 7, 2022 Hi CogyG, I just removed the instructions I was about to post as I noticed your log showing you running an old server version. We added a new feature in the version you were just using that helps to optimize the databases on shutdown/startup depending on settings. This caused an issue for some people that were running Shields. We found the version of SQLite running on Android/Shield was slightly different and needed the code re-ordered, Luke made the changes and that fixed the issue if I remember correctly. So what I'm going to suggest is to download and install 4.7.9 from here: https://emby.media/server-android.html Let us know, how you make out after installing the current version. Carlo Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted November 7, 2022 Share Posted November 7, 2022 There is a little guess work as the log does not have any 'SQLitePCL.pretty.SQLiteException' errors, just network errors. Will guess a log after a library scan possibly. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now