Scan Library Files failing

[ebentson 0]

I love Emby, but I'm having a problem scanning libary files.  It worked initially but I haven't been able to successfully scan recently.  I have a HDD attached to my Nvidia Shield.  Attached is my log. I'm on server 4.6.4

I really appreciate any help, thank you! 

 

embyserver.txt

[Happy2Play 9780]

This was mentioned and reproduced in this topic.

2021-08-20 16:42:39.504 Error ProviderManager: Error refreshing item
	*** Error Report ***
	Version: 4.6.4.0
	Command line: /data/app/com.emby.embyserver-kV4NZFuGRFKCPdDQiBBXbQ==/base.apk
	Operating system: Android 9 (REL) SDK:P BuildId:PPR1.180610.011  Incremental:4079208_2740.7538 Patch-Level: 2021-04-05
	Framework: Mono 6.12.0 (2020-02/5e9cb6d1c1d) 4.0.50524.0
	OS/Process: Arm64/Arm64
	Runtime: mscorlib.dll
	Processor count: 4
	Data path: /storage/emulated/0/Android/data/com.emby.embyserver/files
	Application path: /data/user/0/com.emby.embyserver
	Fingerprint: NVIDIA/mdarcy/mdarcy:9/PPR1.180610.011/4079208_2740.7538:user/release-keys
	Model: SHIELD Android TV - NVIDIA/NVIDIA
	Hardware: mdarcy/mdarcy/darcy/darcy
	SupportedAbis: arm64-v8a, armeabi-v7a, armeabi
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	SQLitePCL.pretty.SQLiteException: 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.Providers.Manager.ProviderManager.RefreshCollectionFolderChildren (MediaBrowser.Controller.Providers.MetadataRefreshOptions options, MediaBrowser.Controller.Entities.CollectionFolder collectionFolder, System.Threading.CancellationToken cancellationToken) [0x00152] in <f7aa0a431bf54c05acb3914c820ed392>:0 
	  at MediaBrowser.Providers.Manager.ProviderManager.RefreshItem (MediaBrowser.Controller.Entities.BaseItem item, MediaBrowser.Controller.Providers.MetadataRefreshOptions options, System.Threading.CancellationToken cancellationToken) [0x00130] in <f7aa0a431bf54c05acb3914c820ed392>:0 
	  at MediaBrowser.Providers.Manager.ProviderManager.StartProcessingRefreshQueue () [0x00162] in <f7aa0a431bf54c05acb3914c820ed392>:0 
	Source: mscorlib
	TargetSite: Void Throw()

 

[Luke 42077]

Hi, was 4.6.4 the first version that you installed?

[ebentson 0]

Yes 4.6.4 is the first version I installed.. just started using Emby a couple months ago.  Note -->  based on the last step in the other post, I deleted Libary.db then scanned the entire library and it worked properly.  

Thanks for the help, 

Eric

 

[Luke 42077]

On 8/21/2021 at 12:35 PM, ebentson said:

Yes 4.6.4 is the first version I installed.. just started using Emby a couple months ago.  Note -->  based on the last step in the other post, I deleted Libary.db then scanned the entire library and it worked properly.  

Thanks for the help, 

Eric

 

Thanks for the feedback. If it comes up again, or if you still have a copy of the previous library.db file, then please send it to me so that I can take a closer look. Thanks.