Sonarr version (exact version): 4.0.2.1183
OS: Debian 12.5
.NET: Yes (6.0.13)
Database: Sqlite 3.40.1
Description of issue: During the execution of Housekeeping task (both manually or scheduled), Debian syslog reports few SQLite errors.
These errors do not appear in the Sonarr log (even in Trace log mode).
Sonarr log:
2024-03-10 10:11:20.0|Info|HousekeepingService|Running housecleaning tasks
2024-03-10 10:11:20.1|Info|Database|Vacuuming Log database
2024-03-10 10:11:20.1|Info|Database|Log database compressed
2024-03-10 10:11:20.2|Info|Database|Vacuuming Main database
2024-03-10 10:11:20.9|Info|Database|Main database compressed
Debian syslog:
Mar 10 10:11:20: [Info] HousekeepingService: Running housecleaning tasks
Mar 10 10:11:20: [Info] Database: Vacuuming Log database
Mar 10 10:11:20: [Info] Database: Log database compressed
Mar 10 10:11:20: [Info] Database: Vacuuming Main database
Mar 10 10:11:20: [Info] Database: Main database compressed
Mar 10 10:11:20: SQLite error (17): statement aborts at 25: [UPDATE "Commands" SET "EndedAt" = @EndedAt, "Status" = @Status, "Duration" = @Duration, "Exception" = @Exception WHERE "Id" = @Id] database schema has changed
Mar 10 10:11:20: SQLite error (17): statement aborts at 11: [SELECT "ScheduledTasks".* FROM "ScheduledTasks"] database schema has changed
Mar 10 10:11:20: SQLite error (17): statement aborts at 18: [UPDATE "ScheduledTasks" SET "LastExecution" = @LastExecution, "LastStartTime" = @LastStartTime WHERE "Id" = @Id] database schema has changed
Mar 10 10:11:24: SQLite error (17): statement aborts at 16: [SELECT "PendingReleases".* FROM "PendingReleases" WHERE ("PendingReleases"."Reason" <> @Clause1_P1)] database schema has changed
Mar 10 10:12:38: SQLite error (17): statement aborts at 12: [SELECT "Users".* FROM "Users"] database schema has changed
Mar 10 10:12:42: SQLite error (17): statement aborts at 12: [SELECT "Users".* FROM "Users"] database schema has changed
Mar 10 10:12:42: SQLite error (17): statement aborts at 12: [SELECT "Users".* FROM "Users"] database schema has changed
Mar 10 10:12:42: SQLite error (17): statement aborts at 32: [UPDATE "ScheduledTasks" SET "TypeName" = @TypeName, "Interval" = @Interval, "LastExecution" = @LastExecution, "LastStartTime" = @LastStartTime WHERE "Id" = @Id] database schema has cha
Mar 10 10:12:42: SQLite error (17): statement aborts at 12: [SELECT "Users".* FROM "Users"] database schema has changed
Is it something you’d like to look into?
Happy to provide extra information if needed.