immich-app/immich
1
0
Fork 0
mirror of https://github.com/immich-app/immich.git synced 2026-07-25 14:00:45 +03:00
Code Issues 783 Packages Projects Releases 22 Wiki Activity

[PR #7696] fix(server): remove shared links during user delete #11749

New Issue
Closed
opened 2026-02-05 14:45:11 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-05 14:45:11 +03:00
Owner
Copy Link

Original Pull Request: https://github.com/immich-app/immich/pull/7696

State: closed
Merged: Yes

Fixes issues during user deletion when the user has shared links.

immich_postgres          | 2024-03-07 03:47:24.007 UTC [360] ERROR:  update or delete on table "users" violates foreign key constraint "FK_66fe3837414c5a9f1c33ca49340" on table "shared_links"
immich_postgres          | 2024-03-07 03:47:24.007 UTC [360] DETAIL:  Key (id)=(1c54b3e7-4323-4801-a46d-2107af0ee001) is still referenced from table "shared_links".
immich_postgres          | 2024-03-07 03:47:24.007 UTC [360] STATEMENT:  DELETE FROM "users" WHERE "id" = $1
immich_microservices     | [Nest] 110  - 03/07/2024, 3:47:24 AM   ERROR [JobService] Unable to run job handler (backgroundTask/user-deletion): QueryFailedError: update or delete on table "users" violates foreign key constraint "FK_66fe3837414c5a9f1c33ca49340" on table "shared_links"
immich_microservices     | [Nest] 110  - 03/07/2024, 3:47:24 AM   ERROR [JobService] QueryFailedError: update or delete on table "users" violates foreign key constraint "FK_66fe3837414c5a9f1c33ca49340" on table "shared_links"
immich_microservices     |     at PostgresQueryRunner.query (/usr/src/app/src/driver/postgres/PostgresQueryRunner.ts:331:19)
immich_microservices     |     at processTicksAndRejections (node:internal/process/task_queues:95:5)
immich_microservices     |     at DeleteQueryBuilder.execute (/usr/src/app/src/query-builder/DeleteQueryBuilder.ts:77:33)
immich_microservices     |     at SubjectExecutor.executeRemoveOperations (/usr/src/app/src/persistence/SubjectExecutor.ts:720:17)
immich_microservices     |     at SubjectExecutor.execute (/usr/src/app/src/persistence/SubjectExecutor.ts:156:9)
immich_microservices     |     at EntityPersistExecutor.execute (/usr/src/app/src/persistence/EntityPersistExecutor.ts:182:21)
immich_microservices     |     at UserService.handleUserDelete (/usr/src/app/src/domain/user/user.service.ts:198:5)
immich_microservices     |     at /usr/src/app/src/domain/job/job.service.ts:158:27
immich_microservices     |     at Worker.processJob (/usr/src/app/node_modules/bullmq/src/classes/worker.ts:741:22)
immich_microservices     |     at Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/src/classes/worker.ts:944:16)
**Original Pull Request:** https://github.com/immich-app/immich/pull/7696 **State:** closed **Merged:** Yes --- Fixes issues during user deletion when the user has shared links. ```console immich_postgres | 2024-03-07 03:47:24.007 UTC [360] ERROR: update or delete on table "users" violates foreign key constraint "FK_66fe3837414c5a9f1c33ca49340" on table "shared_links" immich_postgres | 2024-03-07 03:47:24.007 UTC [360] DETAIL: Key (id)=(1c54b3e7-4323-4801-a46d-2107af0ee001) is still referenced from table "shared_links". immich_postgres | 2024-03-07 03:47:24.007 UTC [360] STATEMENT: DELETE FROM "users" WHERE "id" = $1 immich_microservices | [Nest] 110 - 03/07/2024, 3:47:24 AM ERROR [JobService] Unable to run job handler (backgroundTask/user-deletion): QueryFailedError: update or delete on table "users" violates foreign key constraint "FK_66fe3837414c5a9f1c33ca49340" on table "shared_links" immich_microservices | [Nest] 110 - 03/07/2024, 3:47:24 AM ERROR [JobService] QueryFailedError: update or delete on table "users" violates foreign key constraint "FK_66fe3837414c5a9f1c33ca49340" on table "shared_links" immich_microservices | at PostgresQueryRunner.query (/usr/src/app/src/driver/postgres/PostgresQueryRunner.ts:331:19) immich_microservices | at processTicksAndRejections (node:internal/process/task_queues:95:5) immich_microservices | at DeleteQueryBuilder.execute (/usr/src/app/src/query-builder/DeleteQueryBuilder.ts:77:33) immich_microservices | at SubjectExecutor.executeRemoveOperations (/usr/src/app/src/persistence/SubjectExecutor.ts:720:17) immich_microservices | at SubjectExecutor.execute (/usr/src/app/src/persistence/SubjectExecutor.ts:156:9) immich_microservices | at EntityPersistExecutor.execute (/usr/src/app/src/persistence/EntityPersistExecutor.ts:182:21) immich_microservices | at UserService.handleUserDelete (/usr/src/app/src/domain/user/user.service.ts:198:5) immich_microservices | at /usr/src/app/src/domain/job/job.service.ts:158:27 immich_microservices | at Worker.processJob (/usr/src/app/node_modules/bullmq/src/classes/worker.ts:741:22) immich_microservices | at Worker.retryIfFailed (/usr/src/app/node_modules/bullmq/src/classes/worker.ts:944:16) ```
OVERLORD added the pull-request label 2026-02-05 14:45:11 +03:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
accessibility
changelog:enhancement
changelog:security
changelog:skip
changelog:translation
cli
date-time
dependencies
documentation
external-library
format
good first issue
mobile-beta
mobile-beta
mobile-beta
needs-answer
nice to have
pull-request
Mirrored from GitHub Pull Request
 sharing
tech-debt
📱mobile
🖥️web
🗄️server
🧠machine-learning
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#11749
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?