candyman
candyman
PostsComments
IImmich
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
SOLVED: I was able to manually fix my database and migrate to Immich 1.131.3 on TrueNAS 24.10. Details here: https://forums.truenas.com/t/immich-app-postgres-database-does-not-migrate-from-24-04-to-24-10/38207/2?u=candyman
27 replies
IImmich
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
No description
27 replies
IImmich
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
No description
27 replies
IImmich
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
Here's lines 25927 through 25929 - nothing weird jumping out to me 🤔 
$ cat -n dump_clean.sql | awk '$1>=25927 && $1<=25929'
 25927  42f4134d-46e2-4682-bc59-ededda66b9f2    \N      1600    1200    519     349     580     425     f6c654c8-453d-4a42-945b-b75e58d4b3bc    machine-learning
 25928  42f4134d-46e2-4682-bc59-ededda66b9f2    \N      1600    1200    1228    316     1299    401     3a6b1623-4303-4f6b-a8c4-c5fac8c55750    machine-learning
 25929  42f4134d-46e2-4682-bc59-ededda66b9f2    \N      1600    1200    1373    417     1468    532     92d9c8f1-f16d-496c-b57e-b49bc5778f74    machine-learning
$ cat -n dump_clean.sql | awk '$1>=25927 && $1<=25929'
 25927  42f4134d-46e2-4682-bc59-ededda66b9f2    \N      1600    1200    519     349     580     425     f6c654c8-453d-4a42-945b-b75e58d4b3bc    machine-learning
 25928  42f4134d-46e2-4682-bc59-ededda66b9f2    \N      1600    1200    1228    316     1299    401     3a6b1623-4303-4f6b-a8c4-c5fac8c55750    machine-learning
 25929  42f4134d-46e2-4682-bc59-ededda66b9f2    \N      1600    1200    1373    417     1468    532     92d9c8f1-f16d-496c-b57e-b49bc5778f74    machine-learning
27 replies
IImmich
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
27 replies
IImmich
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
Sorry, I think I messed up that output; let me correct it
27 replies
IImmich
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
Those are skippable errors though I believe, I just didn't clear the db out from my last restore attempt there. The COPY error is the real issue here. It fails at the same point when I drop and recrate the immich db and there aren't a ton of errors, see the attached output which is a fresh immich db. The immich server container is stopped while I'm working on the db container.
27 replies
IImmich
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
27 replies
IImmich
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 checked the images used in kubernetes and docker - they're both using pgvecto-rs:pg15-v0.2.0 so pgvector 0.2.0 it seems
27 replies
IImmich
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
Yep, checked the image and ran SELECT version(); on both containers. I'm stumped
27 replies
IImmich
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
The restore should work regardless of which immich version I'm restoring for though, right? The pgvecto container on TrueNAS 24.04 and 24.10 are running PostgreSQL 15.12 so the dump should be compatible. I'm following essentially this process recommended by Immich https://immich.app/docs/administration/backup-and-restore/#manual-backup-and-restore
27 replies