Sonarr version (exact version): (Should be latest Developer build, can’t login to check. Mono version (if Sonarr is not running on Windows): 3.10.0-2 OS: QTS 4.2.0 ((Debug logs)) (posted to hastebin or similar): Description of issue (if you think you’ve found a bug please include steps to reproduce):
I believe there was a recent update, as I can no longer enter Sonarr. When visiting the site I simply get the loading bar, and that’s it “Flowing Balls”.
I found this in the Google Chrome inspector, not sure if this means anything to you:
`{message: "database or disk is full↵database or disk is full",…}
description
:
"System.Data.SQLite.SQLiteException: database or disk is full↵database or disk is full↵at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement) <0x001f7>↵at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement) <0x000fd>↵at System.Data.SQLite.SQLiteDataReader.NextResult () <0x00560>↵at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior) <0x00245>↵at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior) <0x00037>↵at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior) <0x00047>↵at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader (System.Data.CommandBehavior) <0x00013>↵at System.Data.Common.DbCommand.ExecuteReader () <0x00018>↵at (wrapper remoting-invoke-with-check) System.Data.Common.DbCommand.ExecuteReader () <0x00057>↵at Marr.Data.DataMapper.Query<NzbDrone.Core.SeriesStats.SeasonStatistics> (string,System.Collections.Generic.ICollection`1<NzbDrone.Core.SeriesStats.SeasonStatistics>,bool) <0x00103>↵at Marr.Data.DataMapper.Query<NzbDrone.Core.SeriesStats.SeasonStatistics> (string,System.Collections.Generic.ICollection`1<NzbDrone.Core.SeriesStats.SeasonStatistics>) <0x0002f>↵at Marr.Data.DataMapper.Query<NzbDrone.Core.SeriesStats.SeasonStatistics> (string) <0x0005b>↵at NzbDrone.Core.SeriesStats.SeriesStatisticsRepository.SeriesStatistics () <0x00107>↵at NzbDrone.Core.SeriesStats.SeriesStatisticsService.SeriesStatistics () <0x0001a>↵at NzbDrone.Api.Series.SeriesModule.AllSeries () <0x0001a>↵at NzbDrone.Api.REST.RestModule`1<NzbDrone.Api.Series.SeriesResource>.<set_GetResourceAll>b__c (object) <0x00020>↵at (wrapper dynamic-method) object.CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func`2<object, object>,object) <0x00085>↵at Nancy.Routing.Route/<>c__DisplayClass4.<Wrap>b__3 (object,System.Threading.CancellationToken) <0x00108>↵"
message
:
"database or disk is full↵database or disk is full"
I’m not familiar enough with the back end QNAP (Linux) file directory to know which directories I’d need to check. Nor do I even know how to check what user is running Sonarr.
FIXED!
Turns out the version of Sonarr I had installed, vs the new one I installed, use different directories to store the DB and config.
OLD:
/share/MD0_DATA/homes/admin/.config/NzbDrone
NEW:
/share/MD0_DATA/SONARR_CONFIG
Once I put the DB back into the correct folder, it loaded all my shows again. (The DB was corrupt as you suspected, as I needed to use an older backup)
Any idea why the DB corrupts, this isn’t the first time I’ve had to restore backups or replace the DB entirely.
On OS X its because the filesystem and SQLite fail to cooperate, the file system says something has been written, but in reality it hasn’t. On other OSes it could be a number of things, sometimes bad data gets written, in some cases a bug in mono caused it. In this case it doesn’t look corrupt, but the filesystem not allowing SQLite to write the file.
