immich-app/immich
1
0
Fork 0
mirror of https://github.com/immich-app/immich.git synced 2026-02-05 00:30:57 +03:00
Code Issues 11 Packages Projects Releases 10 Wiki Activity

[BUG] Delete user causes violation of FK constraint in 1.46 #679

New Issue
Closed
opened 2026-02-04 21:53:00 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-04 21:53:00 +03:00
Owner
Copy Link

Originally created by @zackpollard on GitHub (Feb 10, 2023).

Originally assigned to: @zackpollard on GitHub.

The bug

If a user existed with albums, that was then subsequently deleted, it seems we at some point, or even now still, don't clean up the relations correctly. This means that the new FK constraint in 1.46 on owner in album entity cannot be created, and the server boot loops.

The OS that Immich Server is running on

N/A

Version of Immich Server

1.46

Version of Immich Mobile App

1.46

Platform with the issue

  • Server
  • Web
  • Mobile

Your docker-compose.yml content

N/A

Your .env content

N/A

Reproduction steps

1. Run server 1.45
2. Create user
3. Create album
4. Delete user
5. Upgrade to 1.46
6. Server won't run migrations due to FK constraint violation

Additional information

No response

Originally created by @zackpollard on GitHub (Feb 10, 2023). Originally assigned to: @zackpollard on GitHub. ### The bug If a user existed with albums, that was then subsequently deleted, it seems we at some point, or even now still, don't clean up the relations correctly. This means that the new FK constraint in 1.46 on owner in album entity cannot be created, and the server boot loops. ### The OS that Immich Server is running on N/A ### Version of Immich Server 1.46 ### Version of Immich Mobile App 1.46 ### Platform with the issue - [X] Server - [ ] Web - [ ] Mobile ### Your docker-compose.yml content ```YAML N/A ``` ### Your .env content ```Shell N/A ``` ### Reproduction steps ```bash 1. Run server 1.45 2. Create user 3. Create album 4. Delete user 5. Upgrade to 1.46 6. Server won't run migrations due to FK constraint violation ``` ### Additional information _No response_
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
accessibility
changelog:enhancement
changelog:security
changelog:translation
cli
date-time
documentation
external-library
format
good first issue
needs-answer
nice to have
sharing
tech-debt
📱mobile
🖥️web
🗄️server
🧠machine-learning
No Label
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#679
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?