Hi. I know this is a common error, but I can’t seem to find a solution to the problem. My Sonarr was working fine on my Mac (with SABnzbd) and then my power went out two days ago. Since then, I get a localhost:8989 webpage is not found. When I try to open Sonarr, it doesn’t open.
I went to ~/.config/NzbDrone/ and deleted the logs.db file, but that didn’t work. I then pulled the config file from a previous backup (at which time it was working) and replaced the config file, but that didn’t work either. I tried to launch again, and the config file now says:
8989 * 9898 False API_KEY None Info True master builtin
Anyone have any the solution or any suggestions? Any help would be appreciated!
Thanks. I just opened it and scrolled to the bottom, as the top part appeared to be functioning properly. Here’s what I see:
16-3-4 21:27:48.0|Info|Bootstrap|Starting Sonarr - /Applications/Sonarr.app/Contents/MacOS/NzbDrone.exe - Version 2.0.0.3732
16-3-4 21:27:48.7|Debug|ProcessProvider|Found 0 processes with the name: NzbDrone.Console
16-3-4 21:27:49.0|Debug|ProcessProvider|Found 0 processes with the name: NzbDrone
16-3-4 21:27:49.1|Info|MigrationLogger|*** Migrating data source=/Users/Kevin/.config/NzbDrone/nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Truncate;pooling=True;version=3;Full FSync=True ***
16-3-4 21:27:49.2|Fatal|ConsoleApp|EPIC FAIL!
System.Data.SQLite.SQLiteException: database disk image is malformed
database disk image is malformed
at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in :0
at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in :0
Forgive my ignorance, but what does that mean? Thanks for your response, and thanks in advance for any help!!
Unfortunately your database is corrupt and you will need to restore from a backup (Weekly backups are taken automatically).
Thanks for the info! That worked perfectly.
Hello,
I’m having the same exact problem. Sonarr has been working perfectly for several months, I love it! Then all of a sudden I get this error message:
http://localhost:8989/
This site can’t be reached
localhost refused to connect.
ERR_CONNECTION_REFUSED
Sorry for sounding like a total noob, but I can’t even find the /Users//.config/NzbDrone/logs on my iMac. I even tried a simple search for NzbDrone and that folder doesn’t exist. What am I doing wrong? Please help.
Thank you!
Chrome Version 49.0.2623.87 (64-bit)
OS X Yosemite 10.10.5
.config
is a hidden folder, which lives under your user folder.
Using go to folder in finder might work better for you: ~/.config/NzbDrone
Great, thanks for the pointer, I found the folder.
I extracted 2 files from the last backup zip file…config.xml and nzbdrone.db. So now do I just follow steps 5 through 7? And if so, where is the AppData directory located that is mentioned in point 5? And do I delete all the files in that directory?
- Re-install Sonarr
- Run Sonarr once to get the AppData directory location
- Stop Sonarr
- Extract the backup
5, Delete the contents of the AppData directory
- Restore the files extracted from the zip
- Start Sonarr
Thanks for your patience and your help.
Up one folder from the backup and logs folders.
Thanks for your quick response.
Unfortunately I don’t see the AppData directory up one folder from the backups folder. Pls see this screenshot:
https://drive.google.com/file/d/0B3u6C0XPJsqheE9Cc0xCZnRlZVU/view?usp=sharing
Any recommendations?
Thanks!
Its not labeled AppData, that is the folder, in the UI and docs we refer to the folder that has the logs and backups folder as well as nzbdrone.db as the AppData folder.
Ok, so I should just replace the old nzbdrone.db and config.xml files with the 2 new files that I unzipped from the backups?
Yeah and remove any extra nzbdrone.db files (they are in working copies that will cause issues if left).
Removed and replace both files and an extra nzbdrone.db file and sonarr is still not working. Any other recommendations? Thanks!
Make sure you restarted Sonarr and then check the ((log files)) again, if its still corrupt, you will need to try restoring again, possibly using an older backup.
I’m in the same boat suddenly as the OP. How do I stop sonarr if I can’t access the UI? Also when reinstalling, if I had previously used the homebrew method do I have to use that again or can I just download the application? The latter is a lot more straight forward for my needs.
So far all my attempts at restoring are failing. I have a feeling either I’m doing something wrong somewhere, or it’s because I can’t formally stop Sonarr before restoring the db. Really could use some sort of pointer on this.
The settings should be in the same place, so either should work.
Can you stop it in whatever the equivalent of task manager is (resource monitor maybe)?
Nope, Activity Monitor (OSX Mavericks) does not show sonarr running at all. I saw the same thing in another post I made some time ago. Sonarr seems to be running because it replaces the db file moments after deleting it, and writes to it continuously.
So if sonarr does not appear in activity monitor, what can I do? How can I stop it so I can perform a proper restore? Looks like sonarr has been down now for about 6 days which really stinks. =(