Issues with VectorChord migration | Immich | Page 1

weary plume Oct 25, 2025, 6:10 PM

#

I get error that migrations failed and that it is invalid upgrade path. for more info see immich......#typeorm-upgrade

ebon mirageBOT Oct 25, 2025, 6:10 PM

#

:wave: Hey @weary plume,

Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich immich .

References

Container Logs: docker compose logs docs
Container Status: docker ps -a docs
Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA

#

Checklist

I have...

:blue_square: verified I'm on the latest release(note that mobile app releases may take some time).
:blue_square: read applicable release notes.
:blue_square: reviewed the FAQs for known issues.
:blue_square: reviewed Github for known issues.
:blue_square: tried accessing Immich via local ip (without a custom reverse proxy).
:blue_square: uploaded the relevant information (see below).
:blue_square: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

Information

In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:

Your docker-compose.yml and .env files.
Logs from all the containers and their status (see above).
All the troubleshooting steps you've tried so far.
Any recent changes you've made to Immich or your system.
Details about your system (both software/OS and hardware).
Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
The version of the Immich server, mobile app, and other relevant pieces.
Any other information that you think might be relevant.

Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)

If this ticket can be closed you can use the /close command, and re-open it later if needed.

weary plume Oct 25, 2025, 6:10 PM

#

[Nest] 7  - 10/25/2025, 6:04:36 PM     LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 59627 rows
[Nest] 7  - 10/25/2025, 6:04:36 PM     LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 33845 rows
[Nest] 7  - 10/25/2025, 6:04:36 PM    WARN [Microservices:DatabaseRepository] Migration "1744910873969-InitialMigration" failed
[Nest] 7  - 10/25/2025, 6:04:36 PM   ERROR [Microservices:DatabaseRepository] Migrations failed: Error: Invalid upgrade path. For more information, see https://immich.app/errors#typeorm-upgrade ```

#

    container_name: immich_postgres
    image: ghcr.io/immich-app/postgres:16-vectorchord0.3.0-pgvectors0.3.0
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
     # Uncomment the DB_STORAGE_TYPE: 'HDD' var if your database isn't stored on SSDs
      DB_STORAGE_TYPE: 'HDD'
    ports:
      - '5432:5432'
    volumes:
      # Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data
    shm_size: 128mb
    restart: always

volumes:
  model-cache:```

#

I edited according to the specified upgrade instructions

severe ridge Oct 25, 2025, 6:43 PM

#

weary plume ``` database: container_name: immich_postgres image: ghcr.io/immich-app...

you did not share your Immich version (for the server) part

#

it's probably because you updated from a too old version and skipped the breaking changes

ebon mirageBOT Oct 25, 2025, 6:43 PM

#

https://github.com/immich-app/immich/discussions?discussions_q=is%3Aopen+label%3Achangelog%3Abreaking-change+sort%3Adate_created

weary plume Oct 25, 2025, 6:46 PM

#

severe ridge you did not share your Immich version (for the server) part

I did downgrade to the suggested which was the one before breaking changes

#

now trying to go realease version again

#

not sure if it will work

severe ridge Oct 25, 2025, 6:47 PM

#

weary plume I did downgrade to the suggested which was the one before breaking changes

which version?

weary plume Oct 25, 2025, 6:48 PM

#

v1.132.3

severe ridge Oct 25, 2025, 6:48 PM

#

Oh yes, so from 1?132?3 to realaes (I thinkk you can use "v2" now, should work
if you applied the breaeking chagnes of 1.136

weary plume Oct 25, 2025, 6:49 PM

#

severe ridge Oh yes, so from 1?132?3 to realaes (I thinkk you can use "v2" now, should work i...

wdym applied?

severe ridge Oct 25, 2025, 6:49 PM

#

well for example there is that

#

that might apply to your case

weary plume Oct 25, 2025, 6:50 PM

#

severe ridge well for example there is that

dang it, should have read that first

#

wait seems like it is working

#

but I do think I use realative path

#

let me check

#

oh I use absolute

#

phew

#

thanks for the guidance xticks

#

I can finally breath now that immich is running as it should

severe ridge Oct 25, 2025, 6:53 PM

#

Nice
even though I did not help that much, great that it works

#

Btw

ebon mirageBOT Oct 25, 2025, 6:53 PM

#

So when people say "x is not a backup tool" what they are actually saying is "you probably don't actually want a single point in time copy of your data", which is what that tool is doing.

And that "backup tools" exist today that:

can run on a schedule
only copy new/changed data (incremental)
keep track of changes over time in the backup, with the option to restore to a previous version

This gives you the ability to recover a file that was deleted some time ago, restore to a point prior to data corruption, etc., all while being space efficient (similar blocks are deduplicated)

Popular backup tools are restic and borg.

severe ridge Oct 25, 2025, 6:54 PM

#

you should have backups so you can worry less if anything goes wrong

weary plume Oct 25, 2025, 6:59 PM

#

I do have automated backups but I still worry because it is extra job to revert if something breaks

weary plume Oct 25, 2025, 7:01 PM

#

severe ridge you should have backups so you can worry less if anything goes wrong

The automated backups dumps are not sufficent?

#

are you using restic/borg?

rough valley Oct 25, 2025, 7:03 PM

#

weary plume The automated backups dumps are not sufficent?

I mean what if your hard drive dies

weary plume Oct 25, 2025, 7:09 PM

#

rough valley I mean what if your hard drive dies

I rsync the backup folder that automatic from immich goes to every night to another synology nas

#

this server and synolgy both run mirror raid

rough valley Oct 25, 2025, 7:12 PM

#

Rsync is not a good backup. What will you do if a file got corrupted from a few months ago?

weary plume Oct 26, 2025, 6:49 PM

#

rough valley Rsync is not a good backup. What will you do if a file got corrupted from a few ...

That's a good point, if that happens I would go cry hahah

#

I am a newbie to all this still so I will try to configure borg

ebon mirageBOT Oct 26, 2025, 7:02 PM

#

This thread has been closed. To re-open, use the button below.

ebon mirageBOT Oct 30, 2025, 10:32 PM

#

So when people say "x is not a backup tool" what they are actually saying is "you probably don't actually want a single point in time copy of your data", which is what that tool is doing.

And that "backup tools" exist today that:

can run on a schedule
only copy new/changed data (incremental)
keep track of changes over time in the backup, with the option to restore to a previous version

This gives you the ability to recover a file that was deleted some time ago, restore to a point prior to data corruption, etc., all while being space efficient (similar blocks are deduplicated)

Popular backup tools are restic and borg.

wind dust Oct 30, 2025, 10:32 PM

#

wrong channel oops

severe ridge Oct 30, 2025, 10:33 PM

#

wind dust wrong channel oops

Don't you have an exam to study for? 😛

wind dust Oct 30, 2025, 10:33 PM

#

severe ridge Don't you have an exam to study for? 😛

uuuuuhhhhh

#

the night is long enough i guess

severe ridge Oct 30, 2025, 10:34 PM

#

wind dust uuuuuhhhhh

I feel you man, no worries, I helped people here while I had to finish my master thesis

#Issues with VectorChord migration

References

Checklist

Information