Migration Failing After Updating

Help & Support
1

Hello,

I have been having this issue since the anime got pushed to the develop branch last week. After updating, I am unable to start Nzbdrone, below is what it says when I try to start it. Any ideas how to fix this? Thanks in advance.

[Info] MigrationLogger: *** Migrating data source=/home/*****/.config/NzbDrone/nzbdrone.db;cache size=-10485760;datetimekind=Utc;journal mode=Wal ***
[Info] MigrationLogger: *** 53: add_series_sorttitle migrating ***
[Error] MigrationLogger: SQL logic error or missing database
duplicate column name: SortTitle
While Processing:
“ALTER TABLE “Series” ADD COLUMN “SortTitle” TEXT”

[Fatal] ConsoleApp: EPIC FAIL!

System.Exception: SQL logic error or missing database
duplicate column name: SortTitle
While Processing:
“ALTER TABLE “Series” ADD COLUMN “SortTitle” TEXT” —> System.Data.SQLite.SQLiteException: SQL logic error or missing database
duplicate column name: SortTitle
at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in :0
at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in :0
— End of inner exception stack trace —
at FluentMigrator.Runner.Processors.Sqlite.SqliteProcessor.ExecuteNonQuery (System.String sql) [0x00000] in :0
at FluentMigrator.Runner.Processors.Sqlite.SqliteProcessor.Process (System.String sql) [0x00000] in :0
at FluentMigrator.Runner.Processors.ProcessorBase.Process (FluentMigrator.Expressions.CreateColumnExpression expression) [0x00000] in :0
at FluentMigrator.Expressions.CreateColumnExpression.ExecuteWith (IMigrationProcessor processor) [0x00000] in :0
at FluentMigrator.Runner.MigrationRunner+<>c__DisplayClass18.b__15 () [0x00000] in :0
at FluentMigrator.Runner.StopWatch.Time (System.Action action) [0x00000] in :0
at FluentMigrator.Runner.MigrationRunner.AnnounceTime (System.String message, System.Action action) [0x00000] in :0
at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions (ICollection`1 expressions) [0x00000] in :0

2

Looks like a partial DB migration has left it in an unusable state, if you can zip up your DB and PM me a link to grab it (dropbox, mega, etc), I’ll fix it up and send it back.

If you prefer to do it yourself, you can drop the SortTitle column from the Series table and it should migrate properly.

3

Thanks for the fast reply. zip up just nzbdrone.db in the config folder?

4

Yes, please.