GNNNNN
IImmich
•Created by GNNNNN on 11/26/2024 in #help-desk-support
postgres error while running person cleanup job
I found below error in postgresql log while running the person cleanup job:
2024-11-26 17:15:04.917 UTC [2918] ERROR: bind message has 41881 parameter formats but 0 parameters
2024-11-26 17:15:04.917 UTC [2918] STATEMENT: SELECT "PersonEntity"."id" AS "PersonEntity_id", "PersonEntity"."createdAt" AS "PersonEntity_createdAt", "PersonEntity"."updatedAt" AS "PersonEntity_updatedAt", "PersonEntity"."ownerId" AS "PersonEntity_ownerId", "PersonEntity"."name" AS "PersonEntity_name", "PersonEntity"."birthDate" AS "PersonEntity_birthDate", "PersonEntity"."thumbnailPath" AS "PersonEntity_thumbnailPath", "PersonEntity"."faceAssetId" AS "PersonEntity_faceAssetId", "PersonEntity"."isHidden" AS "PersonEntity_isHidden" FROM "person" "PersonEntity" WHERE "PersonEntity"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $1
7 replies
IImmich
•Created by GNNNNN on 7/13/2023 in #help-desk-support
immich bulk upload, immediate quit, error found in postgres
I am using the immich cli to upload some photos, but the job immediate quit without uploading anything
version: v1.66.1
command I use:
immich upload --key xxxxxx --server http://xxx:2283/api --recursive xxxxx --yes
Checking connectivity with Immich instance...
Server status: OK
Checking credentials...
Login status: OK
Successful authentication for user xxx
Indexing local assets...
Indexing complete, found 421 local assets
Comparing local assets with those on the Immich instance...
A total of 1 assets will be uploaded to the server
Start uploading...
Upload Progress | ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ | 0% 1/421 Current file
then it stops.
here is the error I found in postgres:
2023-07-13 17:09:31 2023-07-13 22:09:31.045 UTC [127] ERROR: duplicate key value violates unique constraint "UQ_userid_checksum"
2023-07-13 17:09:31 2023-07-13 22:09:31.045 UTC [127] DETAIL: Key ("ownerId", checksum)=(80281a6d-1a7d-418d-81e4-34f6bd87c43e, \x1f3200f004a6b5bf0efd1e7ba3a90a5f75d2105f) already exists.
4 replies