I had a massive system crash a week or two ago that caused TONS of database issues in basically all of my Docker containers. I've since gotten most of them mostly sorted except for two specific problem children...Binhex-Sonarr and Plex.
Binhex-Sonarr: I've done every database repair, restore, etc thing I can possibly think of and I STILL get "database disk image is malformed" at the top of the page as soon as I go to the UI.
I've tried everything I can think of...are there any ways to fix the DB other than this and restoring from backup? Maybe I'm repairing/restoring the wrong "sonarr.db"? Maybe I have to do something to one of these other things? Maybe a thing somewhere else? I don't know. This is the current directory contents:
Maybe I'm missing something. Maybe I'm in the wrong directory altogether. I don't know.
And...Plex: Plex refuses to cooperate. Getting another "disk image is malformed" error...
The problem with all this isn't that I can't work with SQL...I am relatively familiar with DBs. The problem is that I don't know where all these DBs are! Once I figure out where all this junk is, I can try to fix it. Worst case scenario, I can just delete it and let it rebuild. If I figure out what's broken with Sonarr for instance, I supposed I can just blow it away and restore from a backup. I still have all my data and I'm relatively diligent about backing up most stuff and I know I have pretty recent backups out of Sonarr. (Backing up from within the GUI backs up the DB, right?) I just gotta be able to get in the thing!
Anyway...any help greatly appreciated. This has been a real nightmare!!
Thanks.