d-dragon297 Posts - Answer Overflow

d-dragon297

•Created by d-dragon297 on 12/8/2024 in #help-desk-support

microservices worker error: QueryFailedError: duplicate key value violates unique constraint

After updating to Version 1.122.1 (using docker-compose) and try to start the containers again the following errors occurs resulting in a failed start Immich error:

immich_server            |   },
immich_server            |   length: 226,
immich_server            |   severity: 'ERROR',
immich_server            |   code: '23505',
immich_server            |   detail: 'Key (id)=(36) already exists.',
immich_server            |   hint: undefined,
immich_server            |   position: undefined,
immich_server            |   internalPosition: undefined,
immich_server            |   internalQuery: undefined,
immich_server            |   where: undefined,
immich_server            |   schema: 'public',
immich_server            |   table: 'migrations',
immich_server            |   column: undefined,
immich_server            |   dataType: undefined,
immich_server            |   constraint: 'PK_3a1b9f8427f50cd6123498b21df',
immich_server            |   file: 'nbtinsert.c',
immich_server            |   line: '663',
immich_server            |   routine: '_bt_check_unique'
immich_server            | }
immich_server            | microservices worker error: QueryFailedError: duplicate key value violates unique constraint "PK_3a1b9f8427f50cd6123498b21df"
immich_server            | microservices worker exited with code 1
immich_server            | Killing api process
immich_server exited with code 1

immich_server            |   },
immich_server            |   length: 226,
immich_server            |   severity: 'ERROR',
immich_server            |   code: '23505',
immich_server            |   detail: 'Key (id)=(36) already exists.',
immich_server            |   hint: undefined,
immich_server            |   position: undefined,
immich_server            |   internalPosition: undefined,
immich_server            |   internalQuery: undefined,
immich_server            |   where: undefined,
immich_server            |   schema: 'public',
immich_server            |   table: 'migrations',
immich_server            |   column: undefined,
immich_server            |   dataType: undefined,
immich_server            |   constraint: 'PK_3a1b9f8427f50cd6123498b21df',
immich_server            |   file: 'nbtinsert.c',
immich_server            |   line: '663',
immich_server            |   routine: '_bt_check_unique'
immich_server            | }
immich_server            | microservices worker error: QueryFailedError: duplicate key value violates unique constraint "PK_3a1b9f8427f50cd6123498b21df"
immich_server            | microservices worker exited with code 1
immich_server            | Killing api process
immich_server exited with code 1

8 replies

Gaming

Programming