Luke 36881 Posted August 26, 2021 Share Posted August 26, 2021 OK so you have two libraries in Emby library setup, correct? I see them both in the database and one appears to be empty. I know you can't really tell which is which, but are you able to delete either of the two? Link to comment Share on other sites More sharing options...
Meijinhada 4 Posted August 27, 2021 Author Share Posted August 27, 2021 Nope, can't remove either of them. I can tell which one is the older one, since it still hasn't updated, but the system claims to update, runs until it hits 100%, but isn't actually updating anything. Honestly, I may just dump this and keep running the one off my Synology. I thought the transcoders would help with my music streaming, but it seems it may have been an issue only because we had been running on terrible internet. (Spectrum really does enjoy screwing customers and not telling them.) Now that we upped our plan, I don't seem to have the stuttering issues I did before when outside of the house. Link to comment Share on other sites More sharing options...
schadenfred 0 Posted September 29, 2021 Share Posted September 29, 2021 Hi, new user here. I'm having a similar problem. My error message is slightly shorter than the one reported by Meijinhada, but appears similar enough that I felt like it was best to add on to this thread. If you need anyone to do any testing, please let me know. I'm happy to help. My setup: Nvidia Shield running the Emby server and client. The Shield maps storage to my Synology DS413, which contains my media in shared folders. This morning I performed a factory reset on the Shield, then installed Emby server and client, and set up my libraries from scratch. It worked for about an hour, which was long enough to populate my libraries. But now it's failing again. I deleted a couple of movies, some via Emby's UI, and some via manual deletion from the NAS. Those deletions may have been the trigger for the error. These logs are from this morning's activity, as well as my library.db and activitylog.db. If you need anything else, please let me know. embyserver.txt embyserver-63768503958.txt hardware_detection-63768503970.txt hardware_detection-63768500979.txt activitylog.db library.db Link to comment Share on other sites More sharing options...
ebr 14860 Posted September 30, 2021 Share Posted September 30, 2021 21 hours ago, schadenfred said: I'm having a similar problem. My error message is slightly shorter than the one reported by Meijinhada, but appears similar enough that I felt like it was best to add on to this thread. Hi. Exactly what is the error message and under what circumstance? Link to comment Share on other sites More sharing options...
schadenfred 0 Posted September 30, 2021 Share Posted September 30, 2021 (edited) Here's the error. This occurs a few seconds after clicking the "Scan library files" button on the Library page of Emby's web interface. EDIT: I'm not sure how to make that code pane collapse. Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3 db, System.Int32 rc) [0x00017] in <1319f47a49f34f6db3822eb2e43ff130>:0 at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3_stmt stmt, System.Int32 rc) [0x00006] in <1319f47a49f34f6db3822eb2e43ff130>:0 at SQLitePCL.pretty.StatementImpl.MoveNext () [0x0004a] in <1319f47a49f34f6db3822eb2e43ff130>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.ExecuteWithStringFormatParam (SQLitePCL.pretty.IDatabaseConnection db, System.String query, System.String valueText, System.Int64[] values) [0x00034] in <05979d9270ab4dafac52ba5587e41c17>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInTransaction (SQLitePCL.pretty.IDatabaseConnection db, System.Int64[] ids, System.Boolean supportsPeople, System.Boolean supportsChapters, System.Boolean supportsCollections, System.Boolean supportsMediaStreams, System.Boolean supportsListItems, System.Boolean supportsExternalDatabases) [0x00114] in <05979d9270ab4dafac52ba5587e41c17>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInChunks (System.Int64[] ids, SQLitePCL.pretty.IDatabaseConnection db, System.Boolean supportsPeople, System.Boolean supportsChapters, System.Boolean supportsCollections, System.Boolean supportsMediaStreams, System.Boolean supportsListItems, System.Boolean supportsExternalDatabases) [0x00027] in <05979d9270ab4dafac52ba5587e41c17>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (System.Int64[] ids) [0x00048] in <05979d9270ab4dafac52ba5587e41c17>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (MediaBrowser.Controller.Entities.BaseItem[] items) [0x0002b] in <05979d9270ab4dafac52ba5587e41c17>: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) [0x00265] in <05979d9270ab4dafac52ba5587e41c17>: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 <42f6882bd6d34115bbdd5b6f8b48c222>: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 <42f6882bd6d34115bbdd5b6f8b48c222>: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) [0x00395] in <42f6882bd6d34115bbdd5b6f8b48c222>:0 at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x0014a] in <05979d9270ab4dafac52ba5587e41c17>:0 at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x00092] in <05979d9270ab4dafac52ba5587e41c17>:0 at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal (MediaBrowser.Model.Tasks.TaskOptions options) [0x001b0] in <05979d9270ab4dafac52ba5587e41c17>:0 Edited September 30, 2021 by schadenfred Link to comment Share on other sites More sharing options...
Luke 36881 Posted September 30, 2021 Share Posted September 30, 2021 Hi, apologies for the delay. We are looking into this issue on android. Thanks. Link to comment Share on other sites More sharing options...
schadenfred 0 Posted September 30, 2021 Share Posted September 30, 2021 No problem, Luke. I saw that you're working on it, and wanted to give you another set of data to review. If I can do anything to help, please let me know. Link to comment Share on other sites More sharing options...
Carlo 4328 Posted October 1, 2021 Share Posted October 1, 2021 11 hours ago, schadenfred said: No problem, Luke. I saw that you're working on it, and wanted to give you another set of data to review. Do you know how to get to the Emby database files on the shield? If so I'd love if you could shut down Emby and copy any file in the data folder named library which could have an extension of db, -wal, -shm. I'd like to take a look at it to see if we can find what's causing that particular SQL error message. Link to comment Share on other sites More sharing options...
Carlo 4328 Posted November 14, 2021 Share Posted November 14, 2021 4.7.0.18 (beta) fixes the SQLite Foreign Key (corruption) issue. You can download it from our website: https://emby.media/server-android.html You can install this over your current system and be able to run a Full Library Scan without any of the SQLite errors. 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