Sonarr version (exact version): 3.0.3.928
Mono version (if Sonarr is not running on Windows): 6.10.0.104
OS: Ubuntu 20.04 desktop
Debug logs:
Description of issue: database disk image is malformed database disk image is malformed
I had a catastrophe in the OS and had to restore it via Clonezilla. I updated the Sonarr to its current version, stopped its service, copied the current version of sonarr.db to /var/lib/sonarr and restarted the service. When I did, I got the message, ‘database disk image is malformed database disk image is malformed’.
sqlite3 sonarr.db “.dump” | sqlite3 new.db
Error: near line 9195: NOT NULL constraint failed: Commands.Trigger
Error: near line 9196: NOT NULL constraint failed: Commands.Trigger
Error: near line 9197: NOT NULL constraint failed: Commands.Trigger
Nightly I had saved both config.xml and sonarr.db to an archive. Now I must assume that I cannot do this because it may be updating?
If I still want to do this, would it help if I were to stop the sonarr.service? Is this safe and will it prevent database corruption?