#Immich Helm Chart Migration Issue with Postgresql

1 messages · Page 1 of 1 (latest)

fluid summit
#

Hi i migrated my helm chart lately to the new pgvector.rs. For that i dumped the database and restored the dump in the new container.

After that i restarted Immich server, but now i get this Error Message:

is there a way to fix this in the database? there is no table shared_albums

abstract ravineBOT
#

:wave: Hey @fluid summit,

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

References

Checklist

  1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
  2. :ballot_box_with_check: I have read applicable release notes.
  3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
  4. :ballot_box_with_check: I have reviewed Github for known issues.
  5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
  6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
  7. :ballot_box_with_check: I have 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)

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

abstract ravineBOT
queen portal
fluid summit
#

i only have that old version of the database

queen portal
#

It's ok, read what I wrote later on GitHub.

#

I'm not sure this will help in your case, but as long as you have a backup it's worth a try.

fluid summit
#

you mean this?

UPDATE pg_catalog.pg_extension SET extversion = '0.2.0' WHERE extname = 'vectors';
queen portal
#

Wait a minute, I think I misunderstood something.

queen portal
#

I don't want to just say, it looks like duplicates in the database (probably you have duplicate entries in the database?) it looks like there is a migration mechanism that tried to run but failed
I see no mention of this problem in the past on GitHub or here on Discord.
Maybe @opal zealot will know how to help better on this issue

fluid summit
#

yeah same i mean i am fine if i just delete something so it works.

fluid summit
#

@queen portal any idea how i can fix this?

#

@opal zealot

opal zealot
#

When restoring, make sure that the db is clean. In particular, the immich server has to have never run with that db since it runs a bunch of migrations at startup that prevents the restore from working.

fluid summit
#

ah ok maybe thats the problem