Unable to scan files after update

[TheHoneyBadger 0]

Hi, I am currently on 4.6.0.50 and my TV shows are no longer scanning new files. Movie scans works fine. Scanning library files or scanning TV Shows directly, both fail. 

embyserver.txt

[Abobader 3464]

Hello TheHoneyBadger,

** This is an auto reply **

Please wait for someone from staff support or our members to reply to you.

It's recommended to provide more info, as it explain in this thread:

Thank you.

Emby Team

[Carlo 4561]

Hi, you have a ton of errors in your log related to UPnP for Emby trying to set your ports but your router isn't listening.  You either need to turn on UPnP on the router OR if you manually created the ports OR don't want remote access turn off the option in NETWORK menu to automatically setup port forwarding.

Can you turn that off, rotate your log file from the scheduled tasks menu and do a new library scan?
Then upload a new server log file.

[TheHoneyBadger 0]

Thanks for the quick response. My my UPnP is set manually on the router. I uncheck "enable automatic port mapping" in Networking tab. 

embyserver (1).txt

[Carlo 4561]

That's only a 1 minute log.

Did you library scan finish that quick?

PS no errors so that's good.

[TheHoneyBadger 0]

yes, the scan is quite quick. I think it is finishing fast also because it is not scanning two of my libraries

[Carlo 4561]

Try a scan again.

Also give me a path or two of those not being scanned.

[TheHoneyBadger 0]

I ran a scan on the tv shows which was unsuccessful. The shows are sitting on two drives D:\ and E:\

movies scan successfully on Z:\

embyserver (3).txt

[Carlo 4561]

Pretty much empty log files (one page) and none of these drive letters show up at all.

[TheHoneyBadger 0]

this one is the log file for the successful movie scan. It doesn't actually list Z:\ but the scan is successful

embyserver (4).txt

[TheHoneyBadger 0]

So if I go into the tv shows folder, select the show and run a scan that way the new episode shows up in the list. it seems to be working but I have to run the scan in the show that I just added. Also, was the "upcoming"  tabs in the tv shows removed? 

[Carlo 4561]

No it's still there.  It's the 3rd tab for me.

[nofinproblem 2]

I'm having the same issue after updating to Version 4.6.0.50.  The scan gets to 27.8% and fails.  

 

Scan media library failed

 

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.

   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)

   at SQLitePCL.pretty.StatementImpl.MoveNext()

   at Emby.Server.Implementations.Data.SqliteItemRepository.GetUserDataKeyId(String userDataKey, IStatement insertUserDataKeyStatement, IStatement getUserDataKeyStatement)

   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples)

   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, Action`1 afterSave, CancellationToken cancellationToken)

   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken)

   at Emby.Server.Implementations.Library.LibraryManager.CreateItems(List`1 items, BaseItem parent, CancellationToken cancellationToken)

   at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)

   at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken)

   at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)

   at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken)

   at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)

   at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation(IProgress`1 progress, CancellationToken cancellationToken)

   at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken)

   at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

Edited May 22, 2021 by nofinproblem

[Carlo 4561]

5 hours ago, nofinproblem said:

I'm having the same issue after updating to Version 4.6.0.50.  The scan gets to 27.8% and fails.  

Scan media library failed

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.

That looks like you have a corrupted library.db database file when getting these types of SQL errors.
https://support.emby.media/support/solutions/articles/44002210894-corrupt-database

 

[TheHoneyBadger 0]

Is there a way I can get a hold of 4.6.0.48 or older to roll back?

[Luke 42079]

1 hour ago, TheHoneyBadger said:

Is there a way I can get a hold of 4.6.0.48 or older to roll back?

Hi, unfortunately if the database is corrupt due to one of the causes mentioned in the guide, then rolling back isn't going to help. Please take a look at it and let us know if you have any questions. Thanks.

[Happy2Play 9780]

7 hours ago, nofinproblem said:

I'm having the same issue after updating to Version 4.6.0.50.  The scan gets to 27.8% and fails.  

 

Scan media library failed

 

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.

   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)

   at SQLitePCL.pretty.StatementImpl.MoveNext()

   at Emby.Server.Implementations.Data.SqliteItemRepository.GetUserDataKeyId(String userDataKey, IStatement insertUserDataKeyStatement, IStatement getUserDataKeyStatement)

   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples)

   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, Action`1 afterSave, CancellationToken cancellationToken)

   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, CancellationToken cancellationToken)

   at Emby.Server.Implementations.Library.LibraryManager.CreateItems(List`1 items, BaseItem parent, CancellationToken cancellationToken)

   at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)

   at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken)

   at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)

   at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken)

   at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService)

   at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation(IProgress`1 progress, CancellationToken cancellationToken)

   at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken)

   at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

Yes we would need to see the server log as this does not show all information.

But most likely is what cayars mentioned.

[Happy2Play 9780]

1 hour ago, TheHoneyBadger said:

Is there a way I can get a hold of 4.6.0.48 or older to roll back?

.48 and .50 should be identical unless something isn't documented.

But none of your rollover logs really show any information.

You could try enabling debug logging and provided another log.  Dashboard-Logs, enable debugging and restart Emby.  Note you need to restart also when disabling debug logging also.

[TheHoneyBadger 0]

New log attached. Thanks for your help.

embyserver.txt

[Carlo 4561]

If any of you are seeing "'SQLitePCL.pretty.SQLiteException'" errors in the log.
Shutdown Emby and PM me a copy of your library.db file.

Let me take a look at it before doing anything else.

[nofinproblem 2]

FIXED! 

I'm not sure if this will work for anyone else, but it worked for me.   It doesn't make much sense how it worked, but it did.

What I did:

1) I shut down Emby.

2) I renamed C:\Users\{Username}\AppData\Roaming\Emby-Server\programdata\data\library.db to library.corrupt

3) Restarted Emby, that created a new library.db file.  Of course all of my libraries were gone.

4) I shut down Emby. 

5) I deleted C:\Users\Administrator\AppData\Roaming\Emby-Server\programdata\data\library.db

6) I renamed C:\Users\Administrator\AppData\Roaming\Emby-Server\programdata\data\library.corrupt back to library.db

7) I restarted Emby and ran the library scan, and it worked. 

[Carlo 4561]

You essentially removed the lock files.

If you take a look at the KB article you'll see I added several steps now before having to rebuild the library and this is the first step!

WELL DONE!

[nofinproblem 2]

Thank you Cayars.  That article you posted pointed me in the right direction.  I really didn't want to do a complete rebuild.  I've been running Emby for more than 5 years now and you could image how much content I've collected.  That last time I did a rebuild, it took a little more than a week to rebuild the libraries.

[Carlo 4561]

I feel your pain.  My last rebuild took over a month's time so I get it!
BTW, once a month or, shut down Emby and make a copy of your database files. Keep a couple running versions of them as they don't take up that much space.

This way at worst case you could always restore a month old database and then just run a scan to find changes.

[nofinproblem 2]

Cayars, that's a great idea!  I run the Server Configuration Backup plugin, it does a great job of restoring user profiles, but the last time I try to use it to restore my Media libraries it restored all jacked up.  Thanks!  Since I'm running it on a Windows system, I might just setup Windows Server backup so I can restore to the night before.