Database problem after upgrade
updated to latest :release tag. Now postgres refuses to start. Theres a lot of these messages, but... how can so many checksums be missing?
immich_postgres | 2023-09-02 22:16:03.193 UTC [52792] ERROR: column "checksum" of relation "assets" contains null values
immich_postgres | 2023-09-02 22:16:03.193 UTC [52792] STATEMENT: ALTER TABLE "assets" ALTER COLUMN "checksum" SET NOT NULL
5 Replies
What's the version you upgraded from?
1.6 something. what bugs me is, that this happened before
fixed it last time using alex' help. used the same steps again
it works, but now my iphone is reuploading all assets, even though i can see, that they're still available
Oh man that is a big step to jump
yeah, i thought about using something like watchtower... we were on a big trip through asia and i kinda forgot. but i always just use "release" with immich (that might be a mistake. at work i always use a defined version).
I would love to just not have
release at all but I haven't been able to get that by the others ;)