Lost TV Show Library, can't delete a library

[solson440 4]

I'm assuming that the Emby server update happened today. However, tonight I cannot access my TV Show library from any Emby devices. Also, I tried to create a second TV Library to see if there was a problem with the original, but now I cannot delete the new TV Show library, either. So I now have 2 TV Show libraries that I can neither access, nor delete. Help?

PS; it worked perfectly before today.

[Luke 42085]

Hi there, what do you mean by cannot access it? What exactly happens when you try to access it?

[solson440 4]

I'm sorry, I should have clarified. The library is empty. The directory on my server is full of files, but Emby shows nothing. I am also running Plex on the same server, and Plex shows all of the files that are there and plays them just fine.

[solson440 4]

I should also clarify that none of the other libraries in the server have the same issue, only the TV Shows library.

[Happy2Play 9783]

What libraries do you have setup and their paths?

Do you have any access or parental restrictions on the user account?

Can you post a server log.

[solson440 4]

No. Nothing has changed since the last time I was able to access this library. All of the libraries (Movies, TV Shows, etc) have the same properties. As do all of the users. The library is empty even when accessed directly for the server itself. I can post the log file tomorrow. The other libraries operate as expected.

[solson440 4]

I logged into the server this morning, and found this "Refresh Guide failed" alert:

Quote

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.ExecuteWithStringFormatParam(IDatabaseConnection db, String query, String valueText, Int64[] values)
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInTransaction(IDatabaseConnection db, Int64[] ids, Boolean containsFolders, Boolean supportsPeople, Boolean supportsChapters, Boolean supportsCollections, Boolean supportsMediaStreams, Boolean supportsListItems, Boolean supportsExternalDatabases)
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInChunks(Int64[] ids, IDatabaseConnection db, Boolean containsFolders, Boolean supportsPeople, Boolean supportsChapters, Boolean supportsCollections, Boolean supportsMediaStreams, Boolean supportsListItems, Boolean supportsExternalDatabases)
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteChannels(Int64[] idsToDelete)
at Emby.LiveTV.LiveTvManager.CleanDeadChannels(Int64[] currentIdList)
at Emby.LiveTV.LiveTvManager.RefreshChannelsInternal(IProgress`1 progress, CancellationToken cancellationToken)
at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

And, a bunch of "Scan Media Library Failed" alerts like this:

Quote

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.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)

Attached is the most recent log file.

I did try re-installing Emby Server over the current installation. I did not uninstall and reinstall, however.

Thank you for your help.

embyserver.txt

[solson440 4]

I just uninstalled and reinstalled Emby Server. I can now access my TV Show library. However, I cannot remove the second TV Shows library that I created. I have changed the name, so I no longer have identically named libraries, but I can not remove it from the server. Thoughts?

Thank you.

[solson440 4]

One more thing I just noticed. When going to a specific TV show, then drilling down to a specific Season, it used to show each episode. Now, it doesn't show anything, but if you select "Play" it will play the first episode. It used to show each episode in the season folder, here, along with the synapsis. I have hit "Refresh Library" multiple times on the server, as well as on the player screen.

Edited March 11, 2022 by solson440

[Happy2Play 9783]

Sorry you have a corrupt database.

SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed

You will have to Reset your database per the KB.

https://support.emby.media/support/solutions/articles/44002210894-corrupt-database#:~:text=Steps to Reset Library Database %26 Load Fresh

[solson440 4]

That fixed it! Thank you!!

[Luke 42085]

Thanks for the feedback.