candyman Posts - Answer Overflow

candyman

•Created by candyman on 4/2/2025 in #help-desk-support

Restoring 1.119.1 DB to 1.131.2 fails on Smart Search data

I'm trying to update my TrueNAS server from 24.04 to 24.10 and Immich along with it. My Immich db is not being migrated automatically by TrueNAS for some reason; Immich starts as if it's a brand new server. All of my images and users are gone on 24.10 with 1.131.2. So I took a postgres backup from the working kubernetes and am trying to restore it to the new docker container. I'm following the steps outlined here, just with a few modifications on the restore process: https://github.com/immich-app/immich/discussions/10906 My restore begins working but fails trying to copy Smart Search data

COPY 0
ERROR:  pgvecto.rs: Bad literal.
INFORMATION: hint = Bad sequence.
CONTEXT:  COPY smart_search, line 25928, column embedding: "[-0.012000048, -0.026440227, -0.020461267, -0.012008893, 0.0068139997, 0.002615924, 0.017675625, 0.0..."

COPY 0
ERROR:  pgvecto.rs: Bad literal.
INFORMATION: hint = Bad sequence.
CONTEXT:  COPY smart_search, line 25928, column embedding: "[-0.012000048, -0.026440227, -0.020461267, -0.012008893, 0.0068139997, 0.002615924, 0.017675625, 0.0..."

My postgres database location in the TrueNAS Immich App config is the default ixVolumes. I stopped the immich containers other than pgvecto during restore and dropped and recreated the immich db so it's fresh. Looking for any help on how I can fix the DB on 1.119.1 to get a working dump, or get TrueNAS to migrate immich correctly. I tried rerunning Smart Search job on 1.119.1 for All in the Immich Admin but this did not fix the issue after doing another dump. Thanks for any assistance!

27 replies

Gaming

Programming