error...refresh guide failed

[all4dom 101]

I just started getting the above error & a scan media library error today. When i refresh the guide myself, I have no issues. I am currently running the newest version of emby have not had this problem before.

Thanks

Dom

 

ffmpeg-directstream-46ecd7f0-d051-4e5c-89d0-4604dc66211a_1.txt embyserver.txt

[Carlo 4561]

Hi, What exactly is the error you are seeing from the dashboard standpoint?

[all4dom 101]

Sorry for the delay carlo. The dashboard tells me it failed then this is the message when I click on it. 

 

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 supportsPeople, Boolean supportsChapters, Boolean supportsCollections, Boolean supportsMediaStreams, Boolean supportsListItems, Boolean supportsExternalDatabases)
at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItemsInChunks(Int64[] ids, IDatabaseConnection db, 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)

[all4dom 101]

I had 1 scan media library fail at 10 am.

 

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.TV.Series.RefreshAllMetadata(MetadataRefreshOptions refreshOptions, LibraryOptions libraryOptions, IProgress`1 progress, 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)

[Carlo 4561]

Try the solution listed here and let us know if this helps or not.

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

 

Edited May 23, 2021 by cayars

[all4dom 101]

Sending it now.