Corrupted database after v4 migration

Sonarr version (exact version): From v3.0.10 to v4.0.0.747
Mono version (if Sonarr is not running on Windows): 6.12.0.200
OS: Unraid
Debug logs:
Most important log:

[v4.0.0.748] code = Corrupt (11), message = System.Data.SQLite.SQLiteException (0x800007EF): database disk image is malformed

More:

19:19:56
[v3.0.10.1567] code = Corrupt (11), message = System.Data.SQLite.SQLiteException (0x800007EF): database disk image is malformed
04/01/2024
19:19:56
database disk image is malformed
04/01/2024
19:19:56
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
04/01/2024
19:19:56
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>:0 
04/01/2024
19:19:56
  at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00174] in <cf516e4846354910b3d60749c894b1bf>:0 
04/01/2024
19:19:56
  at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0008e] in <cf516e4846354910b3d60749c894b1bf>:0 
04/01/2024
19:19:56
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
04/01/2024
19:19:56
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
04/01/2024
19:19:56
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
04/01/2024
19:19:56
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
04/01/2024
19:19:56
  at Marr.Data.DataMapper.Delete[T] (System.String tableName, System.Linq.Expressions.Expression`1[TDelegate] filter) [0x00093] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:803 
04/01/2024
19:19:56
  at Marr.Data.DataMapper.Delete[T] (System.Linq.Expressions.Expression`1[TDelegate] filter) [0x00000] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:777 
04/01/2024
19:19:56
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Delete (System.Linq.Expressions.Expression`1[TDelegate] filter) [0x00000] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:56 
04/01/2024
19:19:56
  at NzbDrone.Core.Messaging.Commands.CommandRepository.Trim () [0x00022] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandRepository.cs:35 
04/01/2024
19:19:56
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.CleanCommands () [0x00051] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:225 
04/01/2024
19:19:56
  at NzbDrone.Core.Messaging.Commands.CleanupCommandMessagingService.Execute (NzbDrone.Core.Messaging.Commands.MessagingCleanupCommand message) [0x00000] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CleanupCommandMessagingService.cs:14 
04/01/2024
19:19:56
  at NzbDrone.Core.Messaging.Commands.CommandExecutor.ExecuteCommand[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandModel commandModel) [0x000e0] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandExecutor.cs:96 
04/01/2024
19:19:56
  at (wrapper dynamic-method) System.Object.CallSite.Target(System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandExecutor,object,NzbDrone.Core.Messaging.Commands.CommandModel)
04/01/2024
19:19:56
  at System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid3[T0,T1,T2] (System.Runtime.CompilerServices.CallSite site, T0 arg0, T1 arg1, T2 arg2) [0x00035] in <69ada62907b24213a012734531df1db1>:0 
04/01/2024
19:19:56
  at (wrapper dynamic-method) System.Object.CallSite.Target(System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandExecutor,object,NzbDrone.Core.Messaging.Commands.CommandModel)
04/01/2024
19:19:56
  at NzbDrone.Core.Messaging.Commands.CommandExecutor.ExecuteCommands () [0x00027] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandExecutor.cs:41 
04/01/2024
19:19:56

Description of issue:
After migrating to Sonarr v4, I’ve expreicned the database disk image is corrupt error. This prevented Sonarr from starting.
I attempted to restore from backup (both by re-installing Sonarr, restoring backup files and using built in restore utility and with external backup and restore tool), but the issue persisted.
I then attempted to deploy a fresh container, without any of the old config or database. I thought this solved the issue but after manually re-adding my media, Sonarr didn’t even finish to parse the media library (~130 shows) and the issue was back. This time, followed with a Sonarr error dialog when attempting to re-scan the media.

I just had the exact same issue with the upgrade. I actually restored a database backup and moved back to the 3.0.10 release and was able to keep going, but any attempt to migrate to v4 results in the same database corruption for me.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.