[BUG] 4.0.0.741 fails migrating from 3.0.10

[theotherp]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

I'm running an ls.io container. The previous version running was 3.0.10 which ran fine. Updating to the latest tag (version 4.0.0.741) results in a malformed database error. I tried repairing the database but get loads of constraint violation errors (excerpt):

➜  ~/.config/appdata/sonarr sqlite3 sonarr.db ".recover" | sqlite3 sonarr.repaired.db
Error: near line 42: stepping, UNIQUE constraint failed: Config.Id (19)
Error: near line 66: stepping, UNIQUE constraint failed: RootFolders.Id (19)

Manually restoring the latest backup made by the previous version and starting v4 results in the same migration errors. Manually restoring the database and starting v3 works fine.

Expected Behavior

I guess the migration should run.

Steps To Reproduce

I'd be willing to provide my database file privately.

Environment

- OS: Ubuntu 22.04
- How docker service was installed: I don't remember and it shouldn't matter.

CPU architecture

x86-64

Docker creation

Cause you asked for it...: https://i.imgur.com/QGnQsrL.png

Container logs

Log is too long for GH: https://pastebin.com/ukc57h4R

[github-actions]

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

[theotherp]

Ah fuck I'm on the wrong github repo. Sorry ;-)