Helthar 0 Posted May 13, 2022 Posted May 13, 2022 Hey guys can anyone help me? I have 5 libraries on my server that's located on my Nvidia Shield, I'm using two external hard drives, but one of my libraries suddenly stopped updating when adding new files. I went to the "alert" tab on server configurations and there is a message saind "Library Media Scan Failed". I'll paste the info in that message bellow. Thanks in advance for any help. Spoiler Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown. at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3 db, System.Int32 rc) [0x00017] in <8d7d68df8e9f436fa757b0acd6d56ab6>:0 at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCLEx.sqlite3_stmt stmt, System.Int32 rc) [0x00006] in <8d7d68df8e9f436fa757b0acd6d56ab6>:0 at SQLitePCL.pretty.StatementImpl.MoveNext () [0x0004a] in <8d7d68df8e9f436fa757b0acd6d56ab6>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.ExecuteWithStringFormatParam (SQLitePCL.pretty.IDatabaseConnection db, System.String query, System.String valueText, System.Int64[] values) [0x00034] in <0914aad53d214f5093d6e8aa4f5ba4c1>: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) [0x00244] in <0914aad53d214f5093d6e8aa4f5ba4c1>: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 <0914aad53d214f5093d6e8aa4f5ba4c1>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (System.Int64[] ids) [0x00049] in <0914aad53d214f5093d6e8aa4f5ba4c1>:0 at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems (MediaBrowser.Controller.Entities.BaseItem[] items) [0x0002b] in <0914aad53d214f5093d6e8aa4f5ba4c1>: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 <0914aad53d214f5093d6e8aa4f5ba4c1>: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 <140d946ec45d4dc2abbceda42ec1fb62>: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 <140d946ec45d4dc2abbceda42ec1fb62>: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 <140d946ec45d4dc2abbceda42ec1fb62>:0 at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x0014a] in <0914aad53d214f5093d6e8aa4f5ba4c1>:0 at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal (System.IProgress`1[T] progress, System.Threading.CancellationToken cancellationToken) [0x00092] in <0914aad53d214f5093d6e8aa4f5ba4c1>:0 at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal (MediaBrowser.Model.Tasks.TaskOptions options) [0x001b0] in <0914aad53d214f5093d6e8aa4f5ba4c1>:0
Luke 39825 Posted May 13, 2022 Posted May 13, 2022 HI there @Helthar please attach the complete emby server log. thanks !
Helthar 0 Posted May 13, 2022 Author Posted May 13, 2022 Here's the log, forgot to attach it embyserver.txt
Helthar 0 Posted May 13, 2022 Author Posted May 13, 2022 I figured out the problem. Turns out I put a dash(-) on 3 of the folders inside the folder of my library, that's what caused the issue. Thanks!
Helthar 0 Posted May 14, 2022 Author Posted May 14, 2022 In the folder name, for example, my library folder name is Series and inside I renamed The folder Star Trek - Picard, that was the problem, when I remove that dash, it detecte normally.
Happy2Play 9398 Posted May 14, 2022 Posted May 14, 2022 @cayarsisn't this the Android server issue that was corrected in 4.6.7.0. Errror after "Removing item from database". SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
Carlo 4550 Posted May 15, 2022 Posted May 15, 2022 Sure looks like it! I'd suggest downloading and installing the current beta release (.39) for Android from right here: https://emby.media/server-android.html
Helthar 0 Posted May 18, 2022 Author Posted May 18, 2022 Thanks for the help guys. I'll download the beta release.
Luke 39825 Posted May 18, 2022 Posted May 18, 2022 Just now, Helthar said: Thanks for the help guys. I'll download the beta release. At this point you can just download the new 4.7 stable release. No need to download the beta unless you want to help with testing.
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