TV Shows not adding

[tda0626 0]

Hello,

Premier subscriber here and just got done doing a computer upgrade: ram, cpu, and motherboard. Now my TV Shows won't add or update. I have movies, concerts, and music libraries and everyone of them will update but TV shows. I can't figure it out. I don't know if it is related but I noticed Emby reports these errors with this info:

 

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.SaveItem(IDatabaseConnection db, BaseItem item, Int64 topParentId, Int64 userDataKeyId, IStatement insertItemStatement, IStatement updateItemStatement)
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.UpdateItems(List`1 items, BaseItem parent, ItemUpdateType updateReason, Boolean setDateLastSaved, Boolean saveMetadata, CancellationToken cancellationToken)
at Emby.Server.Implementations.Library.LibraryManager.UpdateItem(BaseItem item, BaseItem parent, ItemUpdateType updateReason)
at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason)
at MediaBrowser.Providers.Manager.MetadataService`2.SaveItem(MetadataResult`1 result, Boolean isFirstRefresh, LibraryOptions libraryOptions, ItemUpdateType reason, IDirectoryService directoryService, CancellationToken cancellationToken)
at MediaBrowser.Providers.Manager.MetadataService`2.RefreshMetadata(BaseItem item, MetadataRefreshOptions refreshOptions, LibraryOptions libraryOptions, CancellationToken cancellationToken)
at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, LibraryOptions libraryOptions, CancellationToken cancellationToken)
at MediaBrowser.Controller.Entities.Folder.RefreshAllMetadataForContainer(IMetadataContainer container, MetadataRefreshOptions refreshOptions, LibraryOptions libraryOptions, IProgress`1 progress, CancellationToken cancellationToken)
at MediaBrowser.Controller.Entities.Folder.RefreshMetadataRecursive(BaseItem[] children, MetadataRefreshOptions refreshOptions, LibraryOptions libraryOptions, Boolean recursive, IProgress`1 progress, CancellationToken cancellationToken)
at MediaBrowser.Controller.Entities.Folder.RefreshMetadataRecursive(BaseItem[] children, MetadataRefreshOptions refreshOptions, LibraryOptions libraryOptions, Boolean recursive, 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)

Any idea why only TV Shows are affected?

 

 

Tim

[Luke 42081]

Hi there @tda0626, can you please attach the complete emby server log file? thanks.

[Carlo 4561]

Hi, please take a look at this KB article.  Try the first option (locked database files) and let us know if this fixes your issue.  If not please upload the complete log as Luke suggested so we can take a look before you try the other options in that KB article.

https://support.emby.media/support/solutions/articles/44002210894-corrupt-database

[tda0626 0]

I ended up downloading the latest version of Emby, standalone, and overwrote the files in the install directory. Whatever that did, fixed it. I am assuming that something got corrupted at some point and caused my issue. Thank you for your help!

 

Regards,

Tim

[Carlo 4561]

Glad you got it working but you really only needed to delete a couple of files per the KB article.

[Happy2Play 9782]

Glad it worked out but a database lock would have nothing to do with a reinstall.  But the first question would have been what server version were you on as 4.6.4.0 has a fix to prevent it from happening again.

Note a Locked database is not a corrupt database, these are two totally different issues covered in the same KB.

[tda0626 0]

On 7/19/2021 at 7:36 PM, Happy2Play said:

Glad it worked out but a database lock would have nothing to do with a reinstall.  But the first question would have been what server version were you on as 4.6.4.0 has a fix to prevent it from happening again.

Note a Locked database is not a corrupt database, these are two totally different issues covered in the same KB.

The lock I guess wasn't the source of my problem. I am still getting these errors. When I get home, I will remove the files to see if it clears it up.

 

Edit:

I haven't seen any errors for the past few days since I deleted the two files in the article. Just wanted to share that...

 

Edited July 22, 2021 by tda0626