ImmichI
Immich•3w ago
sbrow

Issues Migrating from 1.138.0 to 2.3.1 / vecto.rs -> vectorchord

Hello, I have been running immich since 2024-10-09, originally installing version 1.116.2.

Since it's december, I recently upgraded my OS from NixOS 25.05 to NixOS 25.11, and I have had horrendous issues since then.

When I try to start immich-server, I get migration issues with the asset_metadata_audit table. (will post logs when allowed). I tried restoring from backup

and I also tried manually migrating the vectorchord db which helped with the vecto.rs warnings, but doesn't get my system back online.

Here was my basic update process:

# as root
systemctl stop postgresql immich-server
rm -r /var/lib/postgresql/15

systemctl start postgresql
cd /var/lib/immich
 gunzip --stdout backups/immich-db-backup-20251203T020000-v1.138.0-pg15.13.sql.gz | sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" |  sudo -u immich psql --dbname=immich --username=immich

sudo -u postgres psql immich # Do the manual VectorChord migration steps

systemctl start immich-server


Rolling the system back to the previous phase works, but if I update the system leaving immich on the old version (i.e. postgres is updated, but immich is not), then it fails.

Any help would be appreciated 🙂

I have paid for a license, if that makes any difference.
Was this page helpful?