Sonarr version (exact version): 2.0.0.4753
Mono version (if Sonarr is not running on Windows):5.0.1.1
OS: Ubuntu 16.04 running under Virtualbox
((Debug logs)): Now on here’s all collected so far.
17-6-17 18:10:23.7|Debug|Api|[PUT] /api/config/host: 202.Accepted (55 ms)
17-6-17 18:10:23.9|Debug|Api|[GET] /api/health: 200.OK (1 ms)
17-6-17 18:10:44.5|Debug|Api|[GET] /api/health: 200.OK (2 ms)
17-6-17 18:10:44.5|Debug|Api|[GET] /api/health: 200.OK (1 ms)
17-6-17 18:10:44.6|Debug|Api|[GET] /api/diskspace: 200.OK (42 ms)
17-6-17 18:10:44.7|Debug|Api|[GET] /api/diskspace: 200.OK (67 ms)
17-6-17 18:10:48.1|Debug|Api|[GET] /api/log?page=1&pageSize=50&sortKey=time&sortDir=desc: 200.OK (5 ms)
17-6-17 18:10:48.1|Debug|Api|[GET] /api/log?page=1&pageSize=50&sortKey=time&sortDir=desc: 200.OK (3 ms)
17-6-17 18:10:52.1|Debug|Api|[GET] /api/log/file: 200.OK (3 ms)
(Make sure debug logging is enabled in settings and post the full log to hastebin/pastebin/dropbox/google drive or something similar, do not post them directly here)
Description of issue: Sonarr will run for a few hours and then throw …
Task Error: unable to open database file
System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
at System.Data.SQLite.SQLite3.Open (System.String strFilename, System.Data.SQLite.SQLiteConnectionFlags connectionFlags, System.Data.SQLite.SQLiteOpenFlagsEnum openFlags, System.Int32 maxPoolSize, System.Boolean usePool) [0x00074] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteConnection.Open () [0x00959] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at Marr.Data.DataMapper.OpenConnection () [0x00019] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\DataMapper.cs:847
at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection1[T] entityList, System.Boolean useAltName) [0x00065] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\DataMapper.cs:566 at Marr.Data.QGen.QueryBuilder
1[T].ToList () [0x00052] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\Marr.Data\QGen\QueryBuilder.cs:279
at NzbDrone.Core.Datastore.BasicRepository`1[TModel].All () [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Core\Datastore\BasicRepository.cs:60
at NzbDrone.Core.Jobs.TaskManager.GetPending () [0x00000] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Core\Jobs\TaskManager.cs:44
at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x0000b] in M:\BuildAgent\work\b69c1fe19bfc2c38\src\NzbDrone.Core\Jobs\Scheduler.cs:36
at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in :0
at System.Threading.Tasks.Task.Execute () [0x00010] in :0
Close
I have followed the FAQ and cleared out the db files more than once. I have removed sonarr and the .config directory and re-installed (oddly enough it re-created the DB) and it still does this.
Funnily enough radarr on the same VM is doing the same thing.
This might be relevant … seen it on both Sonarr and Radarr.
[v0.2.0.696] System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.Data.SQLite.SQLiteException: constraint failed
UNIQUE constraint failed: Config.Key
at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00083] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0003c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0016b] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteDataReader…ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x00090] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader:.ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <61a20cde294d4a3eb43b9d9f6284613b>:0
at Marr.Data.QGen.InsertQueryBuilder1[T].Execute () [0x00046] in C:\projects\radarr-usby1\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005d] in C:\projects\radarr-usby1\src\Marr.Data\DataMapper.cs:728 at NzbDrone.Core.Datastore.BasicRepository
1[TModel].Insert (TModel model) [0x0002d] in C:\projects\radarr-usby1\src\NzbDrone.Core\Datastore\BasicRepository.cs:111
at NzbDrone.Core.Configuration.ConfigRepository.Upsert (System.String key, System.String value) [0x0000b] in C:\projects\radarr-usby1\src\NzbDrone.Core\Configuration\ConfigRepository.cs:33
at NzbDrone.Core.Configuration.ConfigService.SetValue (System.String key, System.String value) [0x0001a] in C:\projects\radarr-usby1\src\NzbDrone.Core\Configuration\ConfigService.cs:490
at NzbDrone.Core.Configuration.ConfigService.GetValue (System.String key, System.Object defaultValue, System.Boolean persist) [0x0009a] in C:\projects\radarr-usby1\src\NzbDrone.Core\Configuration\ConfigService.cs:464
at NzbDrone.Core.Configuration.ConfigService.get_RijndaelSalt () [0x00000] in C:\projects\radarr-usby1\src\NzbDrone.Core\Configuration\ConfigService.cs:406
at (wrapper delegate-invoke) :invoke_callvirt_string_ConfigService (NzbDrone.Core.Configuration.ConfigService)
at System.Reflection.MonoProperty.GetterAdapterFrame[T,R] (System.Reflection.MonoProperty+Getter2[T,R] getter, System.Object obj) [0x00000] in <a07d6bf484a54da2861691df910339b1>:0 at System.Reflection.MonoProperty.GetValue (System.Object obj, System.Object[] index) [0x00075] in <a07d6bf484a54da2861691df910339b1>:0 --- End of inner exception stack trace --- at System.Reflection.MonoProperty.GetValue (System.Object obj, System.Object[] index) [0x00089] in <a07d6bf484a54da2861691df910339b1>:0 at NzbDrone.Core.Configuration.ConfigService.AllWithDefaults () [0x0001f] in C:\projects\radarr-usby1\src\NzbDrone.Core\Configuration\ConfigService.cs:43 at NzbDrone.Core.Configuration.ConfigService.SaveConfigDictionary (System.Collections.Generic.Dictionary
2[TKey,TValue] configValues) [0x00000] in C:\projects\radarr-usby1\src\NzbDrone.Core\Configuration\ConfigService.cs:52
at NzbDrone.Api.Config.HostConfigModule.SaveHostConfig (NzbDrone.Api.Config.HostConfigResource resource) [0x0005c] in C:\projects\radarr-usby1\src\NzbDrone.Api\Config\HostConfigModule.cs:77
at NzbDrone.Api.REST.RestModule1[TResource].<set_UpdateResource>b__44_0 (System.Object options) [0x00008] in C:\projects\radarr-usby1\src\NzbDrone.Api\REST\RestModule.cs:177 at (wrapper dynamic-method) System.Object:CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func
2<object, object>,object)
at Nancy.Routing.Route+<>c__DisplayClass4.b__3 (System.Object parameters, System.Threading.CancellationToken context) [0x00049] in <63c44d6f8d7e4f339a987bf9eb94d931>:0
Slightly at my wits end because it does this even after clean install.