Database error after latest update


#1

Sonarr version (exact version): 3.0.0.348
Mono version (if Sonarr is not running on Windows): 4.0.4
OS: Mac High Sierra
Debug logs:

> [v3.0.0.316] System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
no such column: t0.ProfileId
  at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, System.UInt32 timeoutMS, System.String& strRemain) [0x0033c] in <61a20cde294d4a3eb43b9d9f6284613b>:0 
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x000f6] in <61a20cde294d4a3eb43b9d9f6284613b>:0 
  at System.Data.SQLite.SQLiteCommand.GetStatement (System.Int32 index) [0x00008] in <61a20cde294d4a3eb43b9d9f6284613b>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteCommand.GetStatement(int)
  at System.Data.SQLite.SQLiteDataReader.NextResult () [0x0011e] 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.ExecuteDbDataReader (System.Data.CommandBehavior behavior) [0x00000] in <61a20cde294d4a3eb43b9d9f6284613b>:0 
  at System.Data.Common.DbCommand.ExecuteReader () [0x00000] in /Users/builder/data/lanes/5533/mono-mac-sdk/external/bockbuild/builds/mono-x64/external/corefx/src/System.Data.Common/src/System/Data/Common/DbCommand.cs:110 
  at (wrapper remoting-invoke-with-check) System.Data.Common.DbCommand.ExecuteReader()
  at Marr.Data.DataMapper.Query[T] (System.String sql, System.Collections.Generic.ICollection`1[T] entityList, System.Boolean useAltName) [0x0006b] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:567 
  at Marr.Data.QGen.QueryBuilder`1[T].ToList () [0x00052] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\QueryBuilder.cs:279 
  at Marr.Data.QGen.SortBuilder`1[T].ToList () [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\SortBuilder.cs:176 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Get (System.Collections.Generic.IEnumerable`1[T] ids) [0x0001d] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:84 
  at NzbDrone.Core.Tv.SeriesService.GetSeries (System.Collections.Generic.IEnumerable`1[T] seriesIds) [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Tv\SeriesService.cs:62 
  at NzbDrone.Core.Download.Pending.PendingReleaseService.IncludeRemoteEpisodes (System.Collections.Generic.List`1[T] releases, System.Collections.Generic.Dictionary`2[TKey,TValue] knownRemoteEpisodes) [0x0008c] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Download\Pending\PendingReleaseService.cs:281 
  at NzbDrone.Core.Download.Pending.PendingReleaseService.GetPendingReleases () [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Download\Pending\PendingReleaseService.cs:256 
  at NzbDrone.Core.Download.Pending.PendingReleaseService.RemoveRejected (System.Collections.Generic.List`1[T] rejected) [0x00010] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Download\Pending\PendingReleaseService.cs:398 
  at NzbDrone.Core.Download.Pending.PendingReleaseService.Handle (NzbDrone.Core.Indexers.RssSyncCompleteEvent message) [0x00000] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Download\Pending\PendingReleaseService.cs:446 
  at NzbDrone.Core.Messaging.Events.EventAggregator.PublishEvent[TEvent] (TEvent event) [0x00116] in M:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Events\EventAggregator.cs:96 

Description of issue:
I tried auto-updating to the latest beta and since then haven’t been able to get it working again. I have restored the old app version, and the .config folder in the app data, from Time Machine backup, but still get this error.


#2

You’re running an old version of Sonarr and what looks like an updated database. You’ll need to update Sonarr first.

Please post your logs and link them next time.


#3

Is there some sort of manual update process that I need to do after downloading and replacing the old version? Bc I got the latest zip, expanded, and put in /Applications, but it still shows as 316 when I run it.


#4

http://services.sonarr.tv/v1/download/phantom/latest?version=3&os=macos&installer=true gets me 3.0.0.348 (the zip has the version and I verified the executable as well).


#5

Well, I got it working by launching it from the Terminal:
/Applications/Sonarr.app/Contents/MacOS/Sonarr

I am not really sure why it kept crashing when launching it normally, but that seemed to have fixed it somehow. Who knows what actually happened, but I am glad to have it back up and running.

Thanks for the quick help.


#6

I am getting same error on Qnap
SQL logic error no such column: t0.ProfileId

Version 3.0.0.298

and get it downgrading to 273


#7

You need to upgrade to 3.0.0.348. You can’t downgrade Sonarr without restoring an old database.


#8

I am on qnap and can only find 298


#9

Greg, we do not provide nor maintain a QNAP package. I suggest you seek assistance on the QNAP community apps forums https://forum.qnap.com/viewtopic.php?f=320&t=144234 .