Sonarr v3 - weird credential behavior and root folder missing (w10 - run as service )

R0n1n · April 21, 2020, 12:31am

Sonarr version 3.0.3.764
OS:Windows 10 ver1903
Description of issue:

Hello,
I’m a new user of Sonarr. So far, it is really ease to setup and use.
But lately, I’m running through a weird issue.

Sonarr v3 run as a service.

If I let it run with the system logon … I can see my data base of tv shows but I can’t access my network share and I got an error about the root folder.
If it runs with an admin account … Sonarr return an error : Unable to open database file

ilike2burnthing · April 21, 2020, 7:42am

R0n1n · April 21, 2020, 5:23pm

Before to post my issue here, I have read the FAQ … 3 times at least. But correct me if I’m wrong … SONARR v3 does not use NzbDrones as service… the only thing in the services manager is Sonarr Application Server

markus101 · April 21, 2020, 5:33pm

Correct, v3 renamed everything to Sonarr.

What do the debug logs show?

R0n1n · April 21, 2020, 5:55pm

here’s a part of the log file

[v3.0.3.764] System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
unable to open database file
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at Marr.Data.QGen.UpdateQueryBuilder`1.Execute() in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\UpdateQueryBuilder.cs:line 156
   at Marr.Data.DataMapper.Update[T](T entity, Expression`1 filter) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 674
   at NzbDrone.Core.Datastore.BasicRepository`1.UpdateMany(IList`1 models) in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:line 175
   at NzbDrone.Core.Qualities.QualityDefinitionService.InsertMissingDefinitions() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:line 90
   at NzbDrone.Core.Qualities.QualityDefinitionService.Handle(ApplicationStartedEvent message) in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Qualities\QualityDefinitionService.cs:line 107
   at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent](TEvent event) in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:line 92

20-4-21 13:40:18.4|Error|SonarrErrorPipeline|[GET /api/v3/series]

[v3.0.3.764] System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
unable to open database file
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList, Boolean useAltName) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 566
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 546
   at Marr.Data.DataMapper.Query[T](String sql) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 537
   at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsRepository.cs:line 35
   at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsService.cs:line 23
   at Sonarr.Api.V3.Series.SeriesModule.AllSeries() in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Api.V3\Series\SeriesModule.cs:line 108
   at Sonarr.Http.REST.RestModule`1.<set_GetResourceAll>b__33_0(Object options) in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Http\REST\RestModule.cs:line 123
   at Nancy.NancyModule.<>c__DisplayClass14_0`1.<Get>b__0(Object args)
   at Nancy.NancyModule.<>c__DisplayClass16_0`1.<Get>b__0(Object args, CancellationToken ct)
   at Nancy.Routing.Route`1.<Invoke>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRouteInvoker.<Invoke>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRequestDispatcher.<Dispatch>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.NancyEngine.<InvokeRequestLifeCycle>d__22.MoveNext()

20-4-21 13:40:19.0|Fatal|SonarrErrorPipeline|Request Failed. GET /api/v3/series

[v3.0.3.764] System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
unable to open database file
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList, Boolean useAltName) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 566
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 546
   at Marr.Data.DataMapper.Query[T](String sql) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 537
   at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsRepository.cs:line 35
   at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsService.cs:line 23
   at Sonarr.Api.V3.Series.SeriesModule.AllSeries() in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Api.V3\Series\SeriesModule.cs:line 108
   at Sonarr.Http.REST.RestModule`1.<set_GetResourceAll>b__33_0(Object options) in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Http\REST\RestModule.cs:line 123
   at Nancy.NancyModule.<>c__DisplayClass14_0`1.<Get>b__0(Object args)
   at Nancy.NancyModule.<>c__DisplayClass16_0`1.<Get>b__0(Object args, CancellationToken ct)
   at Nancy.Routing.Route`1.<Invoke>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRouteInvoker.<Invoke>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRequestDispatcher.<Dispatch>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.NancyEngine.<InvokeRequestLifeCycle>d__22.MoveNext()

20-4-21 13:42:40.8|Error|SonarrErrorPipeline|[GET /api/v3/series]

[v3.0.3.764] System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
unable to open database file
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList, Boolean useAltName) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 566
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 546
   at Marr.Data.DataMapper.Query[T](String sql) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 537
   at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsRepository.cs:line 35
   at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsService.cs:line 23
   at Sonarr.Api.V3.Series.SeriesModule.AllSeries() in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Api.V3\Series\SeriesModule.cs:line 108
   at Sonarr.Http.REST.RestModule`1.<set_GetResourceAll>b__33_0(Object options) in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Http\REST\RestModule.cs:line 123
   at Nancy.NancyModule.<>c__DisplayClass14_0`1.<Get>b__0(Object args)
   at Nancy.NancyModule.<>c__DisplayClass16_0`1.<Get>b__0(Object args, CancellationToken ct)
   at Nancy.Routing.Route`1.<Invoke>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRouteInvoker.<Invoke>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRequestDispatcher.<Dispatch>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.NancyEngine.<InvokeRequestLifeCycle>d__22.MoveNext()

20-4-21 13:42:40.9|Fatal|SonarrErrorPipeline|Request Failed. GET /api/v3/series

[v3.0.3.764] System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
unable to open database file
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList, Boolean useAltName) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 566
   at Marr.Data.DataMapper.Query[T](String sql, ICollection`1 entityList) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 546
   at Marr.Data.DataMapper.Query[T](String sql) in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:line 537
   at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsRepository.cs:line 35
   at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics() in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\SeriesStats\SeriesStatisticsService.cs:line 23
   at Sonarr.Api.V3.Series.SeriesModule.AllSeries() in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Api.V3\Series\SeriesModule.cs:line 108
   at Sonarr.Http.REST.RestModule`1.<set_GetResourceAll>b__33_0(Object options) in M:\BuildAgent\work\63739567f01dbcc2\src\Sonarr.Http\REST\RestModule.cs:line 123
   at Nancy.NancyModule.<>c__DisplayClass14_0`1.<Get>b__0(Object args)
   at Nancy.NancyModule.<>c__DisplayClass16_0`1.<Get>b__0(Object args, CancellationToken ct)
   at Nancy.Routing.Route`1.<Invoke>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRouteInvoker.<Invoke>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.Routing.DefaultRequestDispatcher.<Dispatch>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Nancy.NancyEngine.<InvokeRequestLifeCycle>d__22.MoveNext()

20-4-21 13:48:19.0|Info|NzbDroneServiceFactory|Attempting to stop application.
20-4-21 13:48:19.0|Info|OwinHostController|Attempting to stop OWIN host
20-4-21 13:48:19.1|Info|OwinHostController|Host has stopped
20-4-21 13:48:19.1|Info|NzbDroneServiceFactory|Application has finished stop routine.
20-4-21 13:48:19.1|Info|ConsoleApp|Exiting main.
20-4-21 13:48:47.8|Info|Bootstrap|Starting Sonarr - C:\ProgramData\Sonarr\bin\Sonarr.Console.exe - Version 3.0.3.764
20-4-21 13:48:48.4|Info|Router|Application mode: UninstallService
20-4-21 13:48:48.4|Info|ServiceProvider|Uninstalling Sonarr service
20-4-21 13:48:48.4|Info|ServiceProvider|Stopping Sonarr Service...
20-4-21 13:48:48.4|Info|ServiceProvider|Service is currently Stopped
20-4-21 13:48:48.4|Warn|ServiceProvider|Service Sonarr is already in stopped state.
20-4-21 13:48:53.5|Info|ServiceProvider|Sonarr successfully uninstalled
20-4-21 13:48:53.5|Info|ConsoleApp|Exiting main.

ilike2burnthing · April 21, 2020, 6:19pm

I meant part 2:
You’re using a mapped network drive (not a UNC path)
Solutions:

Change your paths to UNC paths (\server\share)
Run NzbDrone.exe via the Startup Folder

markus101 · April 21, 2020, 6:47pm

Please upload the whole log file and link it here. Best if you enable debug logging first.

R0n1n · April 21, 2020, 8:44pm

I use UNC path - to my SYNOLOGY - and in the sonarr folder, NzbDrone.exe doen’t existe

R0n1n · April 21, 2020, 9:05pm

Ok so I went with the hardcore solution… Uninstall, delete everything and install as brand new with sonarr v3.
I migrate from v2 to v3 so it might be the issue

markus101 · April 21, 2020, 9:10pm

In v3 NzbDrone.exe won’t exist, it’s renamed to Sonarr.exe.

Glad to hear you got it sorted.

system · May 5, 2020, 9:10pm

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.