UI gets bouncing balls, "Unable to open database" in logs

Sonarr version (exact version): 2.0.0.4230
Mono version (if Sonarr is not running on Windows): n/a
OS: Windows Server 2012 R2
((Debug logs)) (posted to hastebin or similar):

Description of issue:
Logged in to check on some series, all I get is the loading screen with bouncing balls back and forth. I have exited and relaunched Sonarr, but no change so far. New episodes don’t seem to be downloading. This install is less than two months old, but my library is hitting 20TB, about half of which is TV.

[v2.0.0.4230] 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, ICollection1 entityList, Boolean useAltName) in M:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:line 566 at Marr.Data.DataMapper.Query[T](String sql, ICollection1 entityList) in M:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:line 546
at Marr.Data.DataMapper.Query[T](String sql) in M:\BuildAgent\work\6c3239faf2b92630\src\Marr.Data\DataMapper.cs:line 537
at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics() in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\SeriesStats\SeriesStatisticsRepository.cs:line 25
at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics() in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Core\SeriesStats\SeriesStatisticsService.cs:line 24
at NzbDrone.Api.Series.SeriesModule.AllSeries() in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Api\Series\SeriesModule.cs:line 104
at NzbDrone.Api.REST.RestModule1.<set_GetResourceAll>b__32_0(Object options) in M:\BuildAgent\work\6c3239faf2b92630\src\NzbDrone.Api\REST\RestModule.cs:line 111 at CallSite.Target(Closure , CallSite , Func2 , Object )
at Nancy.Routing.Route.<>c__DisplayClass4.b__3(Object parameters, CancellationToken context)

Its either locked or corrupt, I can’t tell from the snippet you posted nor can I tell which database is the problem (nzbdrone.db or logs.db).

If its the log DB You can remove it and Sonarr will recreate it automatically. If its the main DB you’ll need to ((restore)) from a backup (which Sonarr make automatically).

Well I tried deleting the logs.db and then starting Sonarr again, and that threw an error.

I just deleted logs.db, downloaded and reinstalled the application and ti seems to be working again.

Thanks!

1 Like

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