Download | Wiki

"Candle" already exist error?


#1

After upgrade getting this error:

Unhandled Exception: Microsoft.Data.Sqlite.SqliteException: SQLite Error 1: ‘table “Candles” already exists’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
— End of stack trace from previous location where exception was thrown —
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteAsync(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQueryAsync(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQueryAsync(IEnumerable`1 migrationCommands, IRelationalConnection connection, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateAsync(String targetMigration, CancellationToken cancellationToken)
at ptfeeder.database.DbInitializer.Initialize(PtfDbContext context) in C:\projects\profittrailer-config-generator\pt-feeder\database\DbInitializer.cs:line 10
at pt_feeder.Startup.OnStarting() in C:\projects\profittrailer-config-generator\pt-feeder\Startup.cs:line 228
at pt_feeder.Startup.b__9_0() in C:\projects\profittrailer-config-generator\pt-feeder\Startup.cs:line 66
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
— End of stack trace from previous location where exception was thrown —
at System.Threading.ThreadPoolWorkQueue.Dispatch()

C:\Users\Administrator\Desktop\Binance8083\pt-feeder>PAUSE


#2

You need to delete the ptfeeder.db as per the upgrade instructions here, step 7.

After starting Feeder again, you should be good to go.


#3

Ahhhhh, found it. Buried in the database directory.
Working now
Thanks