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
4 Replies
:wave: Hey @GNNNNN,
Thanks for reaching out to us. Please follow the recommended actions below; this will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker compose ps docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
Checklist
1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: I have read applicable release notes.
3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
4. :ballot_box_with_check: I have reviewed Github for known issues.
5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files, making sure to use code formatting.
7. :ballot_box_with_check: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
If this ticket can be closed you can use the /close command, and re-open it later if needed.
Successfully submitted, a tag has been added to inform contributors. :white_check_mark:What’s a person cleanup job?
The actual questions is how you managed to have this many people 😅
it's a optional job you can create manually on job control page
I made some changes in machine learning settings to detect more people and merge them later.