Skip to content

[BUG] SQLite Error 1: 'duplicate column name: arr_instance_id' #551

@jgl2832

Description

@jgl2832

Duplicate check

  • I have searched for existing issues and confirmed this is not a duplicate.

Before submitting a bug report, I have:

  • Reviewed the documentation.
  • Ensured I am using ghcr.io/cleanuparr/cleanuparr docker repository.
  • Ensured I am using the latest version.
  • Enabled verbose logging.

What is the behavior?

Cleanuparr won't start up, getting the following SQLite error: duplicate column name: arr_instance_id'

Which operating system do you use?

Linux

What type of deployment do you use?

Docker container

Relevant log output

cleanuparr-1  | Unhandled exception. Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'duplicate column name: arr_instance_id'.
cleanuparr-1  |    at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
cleanuparr-1  |    at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext()
cleanuparr-1  |    at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext()
cleanuparr-1  |    at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
cleanuparr-1  |    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
cleanuparr-1  |    at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
cleanuparr-1  |    at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
cleanuparr-1  | --- End of stack trace from previous location ---
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQueryAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteAsync(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean beginTransaction, Boolean commitTransaction, Nullable`1 isolationLevel, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteAsync(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean beginTransaction, Boolean commitTransaction, Nullable`1 isolationLevel, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQueryAsync(IReadOnlyList`1 migrationCommands, IRelationalConnection connection, MigrationExecutionState executionState, Boolean commitTransaction, Nullable`1 isolationLevel, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateImplementationAsync(DbContext context, String targetMigration, MigrationExecutionState state, Boolean useTransaction, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateImplementationAsync(DbContext context, String targetMigration, MigrationExecutionState state, Boolean useTransaction, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.<>c.<<MigrateAsync>b__22_1>d.MoveNext()
cleanuparr-1  | --- End of stack trace from previous location ---
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateAsync(String targetMigration, CancellationToken cancellationToken)
cleanuparr-1  |    at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.MigrateAsync(String targetMigration, CancellationToken cancellationToken)
cleanuparr-1  |    at Cleanuparr.Api.HostExtensions.InitAsync(WebApplicationBuilder builder)
cleanuparr-1  |    at Cleanuparr.Api.HostExtensions.InitAsync(WebApplicationBuilder builder)
cleanuparr-1  |    at Program.<Main>$(String[] args)
cleanuparr-1  |    at Program.<Main>(String[] args)
cleanuparr-1 exited with code 139 (restarting)

Anything else?

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions