Updated to 2.0.0.3357 and now will not start

[ohlordy]

Running sonarr on an asus router for a past few months. Usually the updates are smooth but for some reason since this update, sonarr wont start.

The log file shows this error:

[Info] Bootstrap: Starting Sonarr - /opt/NzbDrone/NzbDrone.exe - Version 2.0.0.3357
[Debug] ProcessProvider: Found 0 processes with the name: NzbDrone.Console
[Debug] ProcessProvider: Found 0 processes with the name: NzbDrone
[Info] MigrationLogger: *** Migrating data source=/root/.config/NzbDrone/nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***

[Fatal] ConsoleApp: EPIC FAIL!

System.Data.SQLite.SQLiteException: unable to open database file
unable to open database file
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

Not sure why it is saying it is unable to open the db file as the file /root/.config/NzbDrone/nzbdrone.db exists.
I tried restoring the config and db from various backups but it still gives the same error at startup.
Any tips?

[markus101]

Which version of mono is it running?

Try deleting nzbdrone.db as well as the nzbdrone.db-shm and nzbdrone.db-wal files as they could mess up the DB on start up.

Is Sonarr running as root? Not permissions related?

[ohlordy]

Hi Markus,

It’s mono v4.0

It’s fixed now. Here is the solution in case anyone else has a simial issue.

rename /root/.config/NzbDrone to /root/.config/NzbDrone-bak
Start sonarr, it should start ok and create a new /root/.config/NzbDrone folder with defaults
Stop sonarr and copy in the following from the original /root/.config/NzbDrone-bak to the new /root/.config/NzbDrone
nzbdrone.db
config.xml
MediaCover

Now start sonarr again and all should be okay