Simulot
Simulot
IImmich
Created by Simulot on 9/6/2023 in #help-desk-support
migration to v1.77.0 fails with sql error
immich_postgres | 2023-09-06 07:20:40.495 CEST [59] ERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
immich_postgres | 2023-09-06 07:20:40.495 CEST [59] DETAIL: Key (relname, relnamespace)=(migrations_id_seq, 2200) already exists.
immich_postgres | 2023-09-06 07:20:40.495 CEST [59] STATEMENT: CREATE TABLE "migrations" ("id" SERIAL NOT NULL, "timestamp" bigint NOT NULL, "name" character varying NOT NULL, CONSTRAINT "PK_8c82d7f526340ab734260ea46be" PRIMARY KEY ("id"))
immich_microservices | [Nest] 7 - 09/06/2023, 7:20:40 AM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
immich_microservices | QueryFailedError: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
immich_microservices | at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
immich_microservices | at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
immich_microservices | at async PostgresQueryRunner.executeQueries (/usr/src/app/node_modules/typeorm/query-runner/BaseQueryRunner.js:424:13)
immich_microservices | at async PostgresQueryRunner.createTable (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:410:9)
immich_microservices | at async MigrationExecutor.createMigrationsTableIfNotExist (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:351:13)
immich_microservices | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:129:9)
immich_microservices | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:260:35)
immich_microservices | at async DataSource.initialize (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:148:17)
immich_postgres | 2023-09-06 07:20:40.495 CEST [59] ERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
immich_postgres | 2023-09-06 07:20:40.495 CEST [59] DETAIL: Key (relname, relnamespace)=(migrations_id_seq, 2200) already exists.
immich_postgres | 2023-09-06 07:20:40.495 CEST [59] STATEMENT: CREATE TABLE "migrations" ("id" SERIAL NOT NULL, "timestamp" bigint NOT NULL, "name" character varying NOT NULL, CONSTRAINT "PK_8c82d7f526340ab734260ea46be" PRIMARY KEY ("id"))
immich_microservices | [Nest] 7 - 09/06/2023, 7:20:40 AM ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...
immich_microservices | QueryFailedError: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
immich_microservices | at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)
immich_microservices | at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
immich_microservices | at async PostgresQueryRunner.executeQueries (/usr/src/app/node_modules/typeorm/query-runner/BaseQueryRunner.js:424:13)
immich_microservices | at async PostgresQueryRunner.createTable (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:410:9)
immich_microservices | at async MigrationExecutor.createMigrationsTableIfNotExist (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:351:13)
immich_microservices | at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:129:9)
immich_microservices | at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:260:35)
immich_microservices | at async DataSource.initialize (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:148:17)
As consequences, the server send the welcome page
2 replies
IImmich
Created by Simulot on 8/11/2023 in #help-desk-support
Quicktime movie GPS isn't correctly imported
No description
1 replies