TV Guide failed to refresh: "Corrupt:database disk image is malformed"

[csimon 4]

Emby Server 4.7.6.0 running on Debian.

I am using an M3U file for channels from a SAT>IP server, and Emby Guide Data for the UK and line-up Freesat (Wales).  The guide fails to refresh with the following message in the Info button in Alerts on the main dashboard.

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.RefreshChannels(IProgress`1 progress, CancellationToken cancellationToken)
at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)

I have tried restarting the server, and deleting the Guide Data Source and TV Source and setting it up again. I notice that even after removing all channels apart from one from the M3U file (and setting up from scratch again) the EPG remains with all channels that were previously there, i.e. it ties in with the error mesage above which suggests a problem with deleting channels.

I attach the full embyserver.txt log from the relevant timeframe.

embyserver.txt

[Happy2Play 9780]

Please follow the steps in the KB but most likely you will have to reset the database.

Corrupt Database : (emby.media)

Note your userdata is in this database also.

Edited August 31, 2022 by Happy2Play

[csimon 4]

Thank you, I reset the database and did a rescan and all seems OK now. Also, my user data seems to have survived...