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

❓Question🗄️Server☑️Ready

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

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

# 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.

Immich•3mo ago•

10 replies

sbrow

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

❓Question🗄️Server☑️Ready

asset_metadata_audit

asset_metadata_audit

# 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

# 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

I have paid for a license, if that makes any difference.

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

Similar Threads

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

Similar Threads

Similar Threads

Similar Threads