LInux epic fail related to database problem

[iamwhatiam]

When Sonarr works, it is great. Unfortunately, it almost never works anymore. I use Ubuntu 14.04, and have followed a few different installation guides. I have purged and reinstalled the whole program twice now. It works for awhile, but after a reboot or two, it stops working entirely. None of my information is retained, or it doesn’t run at all. When I run from in debug mode from the command line, now I get:

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

[Fatal] ConsoleApp: EPIC FAIL!

System.Data.SQLite.SQLiteException: file is encrypted or is not a database
file is encrypted or is not a database
at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) <0x41f82250 + 0x00cc3> in :0
at System.Data.SQLite.SQLiteCommand.BuildNextCommand () <0x41f81da0 + 0x00239> in :0

Press any key to exit…

Any help is appreciated. If you tell me where they are stored, I can also upload log files.

[markus101]

Your database is corrupt, you’ll need to restore from a backup.

[iamwhatiam]

Thanks Markus. That fixed it. I recall that it was corrupted recently, although the error message was different. Is there some reason that it keeps happening that I could uncover? If it keeps happening every few weeks, it is a real problem.

[markus101]

It can happen when the OS shuts down unexpectedly, or could be an issue with the filesystem and SQLite (OS X has a similar issue).