Sonarr version (exact version): 3.x Not sure of exact version since I can’t get into it.
Mono version (if Sonarr is not running on Windows):
OS: Docker on unRAID
Debug logs:
Description of issue:
I have been using SABNZBD and the -arr suite for some time. I started out using the Binhex containers. Sometime in 2021, I switched the repository for my existing container from the Binhex source to Linuxserver’s. I’m not exactly sure why I did this, but it might have been because of the major version release around that time and Linuxserver had a preview build of it. I only did this switch with Sonarr.
Fast forward to a couple weeks ago, I noticed that the container was no longer updating and probably hasn’t for some time. This is when I noticed and remembered that the container was pointed to the Linuxserver repository preview build, even though I know it was originally the Binhex container. I pointed it back to the Binhex repo and updated to pull down the new container. After updating, the web UI was no longer available. I didn’t have time to mess with it, so I switched it back to the Linuxserver repo, updated, and everything looked good. “This is a future me problem” I thought.
Fast forward again to today, and future me noticed that nothing has downloaded for any of my monitored shows in the last two weeks. I did a search on one of the shows that are on my calendar and there were indeed episodes that matched the criteria in my profiles that should have downloaded. However, they were all rejecting with the error. “BlacklistSpecification: SQL logic error no such table: Blacklist.” I get this with every single entry for every single show. I can still manually download them, however.
I did some research and apparently this happens when you upgrade Sonarr and then roll back. It seems that when I switched back to the Binhex repo and Sonarr was able to update again, it also updated the database. (So I’m guessing Sonarr was working under the hood even if the UI was busted) And since I had to switch back to Linuxserver’s, it can now no longer properly read the database since it is an older version.
I tried switching back to the Binhex repo again today, but were met with the same results as two weeks ago. An inaccessible UI. Since my database is now unreadable by the previous version, it looks like my only option short of wiping my Sonarr appdata is to figure out how to get it working using the container from the Binhex repo again.