Newest version (2.6.1) does not start after update
🗄️Server☑️Ready
Hi, after updating from 2.5.6 this night, the immich server does not start because of this error (see logs) and keeps restarting. When trying to restore the db inside a clean installation it says:
Error: /usr/lib/postgresql/14/bin/psql non-zero exit code (3)ERROR: could not create unique index "asset_pkey"DETAIL: Key (id)=(92fe239b-5ac0-4b88-986a-10b7586e03bc) is duplicated.
Error: /usr/lib/postgresql/14/bin/psql non-zero exit code (3)ERROR: could not create unique index "asset_pkey"DETAIL: Key (id)=(92fe239b-5ac0-4b88-986a-10b7586e03bc) is duplicated.
I run it on Ubuntu server 24 LTS, SSD storage. I'm not overly familiar with postgres, any help is appreciated.