well, I have tried to uninstall and reinstall the app.
now I have reached a scenario where I don’t have an NzbDrone library under .config all all and no .bd or logs what so ever…
trying to run sudo mono /opt/NzbDrone/NzbDrone.exe does not seem to recreate those folder nor the files inside them if I try to manually create the folders…
Any recommendations on what to do next would be appreciated.
Please run mono with the --debug switch (mono --debug /opt/NzbDrone/NzbDrone.exe).
The error looks like an issue with SQLite, but nothing I’ve seen before and the current message doesn’t contain enough details to point to what the issue could be.
my statement about the folder not being created was when I expected it to be found in my user home folder. but it does exist in /root/.config/NzbDrone/logs/nzbdrone.txt
[Info] Bootstrap: Starting NzbDrone - /opt/NzbDrone/NzbDrone.exe - Version 2.0.0.2673
[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.FormatException: Input string was not in the correct format
at System.Int32.Parse (System.String s, NumberStyles style, IFormatProvider provider) [0x00000] in :0
at System.Int32.Parse (System.String s, IFormatProvider provider) [0x00000] in :0
at System.Convert.ToInt32 (System.String value, IFormatProvider provider) [0x00000] in :0
at System.Data.SQLite.SQLiteConnection.Open () [0x00000] in :0
Is it normal for the /root/.config/NzbDrone/nzbdrone.db file to have a size of 0 ?
should i try to delete it?
will sonarr try to re-create the .db file?
At this moment, no. Do have another system you can run Sonarr on to see if it works (even a VM?). Hate to blame it on something that I can’t prove, but we haven’t been able to reproduce it (and the logs don’t show much since its happening outside of Sonarr’s code).
I understand from the stack trace that the error happens within the SQLiteConnection.Open method, and that the error itself is related to not being able to convert some value from a string to an integer.
I am assuming this is related to some form of a connection string.
could you create a version that that logs this connection string before it calls SQLiteConnection.Open ?
it might help us understand where the problem is…
also / alternatively - can we try and do whatever sonarr is trying to do directly from the sqlite console?
The connection string has always been logged (from your log above):
[Info] MigrationLogger: *** Migrating data source=/root/.config/NzbDrone/nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal;pooling=True;version=3 ***
Nothing out of the norm with it (mine is the same except for the path).
If you can open the connection using the connection string its possible, but that will just create the shell of the DB, none of the migrations would be run.
When I run sudo apt list | grep sqlite | grep installed I get a much shorter list:
welll I actually got it to work now.
I belive it is related to the language settings of my ubunto.
I was purchased pre-installed with its language set to hebrew.
I am guessing that some regional aspect was returning a string where a number was expected - maybe a month name or something similar.
anyway - it is now running and you have my thanks for your help.
just to clarify - it seems that the fact that I changed the main language to english did the trick - but I did not try to change back to make sure.
somewhere along the proccess I also go a message that said that the UI foldr was missing and I did an uninstall and an installl - but it sarted to work (in the sense that it did all the migrations and did not return the FAIL message BEFORE this re-install.